Sure, here are the updated tables with sample records:

-- Table: student
CREATE TABLE student (
student\_id VARCHAR(10) PRIMARY KEY,
name VARCHAR(50),
email VARCHAR(50),
phone\_number VARCHAR(8),
date\_registered TIMESTAMP DEFAULT NOW()
);

INSERT INTO student (student\_id, name, email, phone\_number) VALUES
('s000001', 'John Smith', '[johnsmith@example.com](mailto:johnsmith@example.com)', '98765432'),
('s000002', 'Jane Doe', '[janedoe@example.com](mailto:janedoe@example.com)', '63235323'),
('s000003', 'Bob Johnson', '[bjohnson@example.com](mailto:bjohnson@example.com)', '62345532'),
('s000004', 'Mary Lee', '[marylee@example.com](mailto:marylee@example.com)', '92673454'),
('s000005', 'David Kim', '[davidkim@example.com](mailto:davidkim@example.com)', '92324232');

-- Table: product
CREATE TABLE product (
product\_id VARCHAR(10) PRIMARY KEY,
name VARCHAR(50),
description TEXT,
price DECIMAL(10, 2),
image\_url VARCHAR(100),
is\_available BOOLEAN DEFAULT true,
date\_added TIMESTAMP DEFAULT NOW(),
date\_updated TIMESTAMP DEFAULT NOW()
);

INSERT INTO product (product\_id, name, description, price, image\_url) VALUES
('p000001', 'Pen', 'Blue ink pen with grip', 2.50, '<https://example.com/pen.jpg>'),
('p000002', 'Notebook', '100-page A5 lined notebook', 5.00, '<https://example.com/notebook.jpg>'),
('p000003', 'Highlighter', 'Pack of 5 assorted color highlighters', 8.99, '<https://example.com/highlighters.jpg>'),
('p000004', 'Eraser', 'Set of 3 erasers in different colors', 1.99, '<https://example.com/erasers.jpg>'),
('p000005', 'Stapler', 'Standard size stapler with 200 staples', 6.50, '<https://example.com/stapler.jpg>');

-- Table: order
CREATE TABLE orders (
order\_id VARCHAR(10) PRIMARY KEY,
student\_id VARCHAR(10),
product\_id VARCHAR(10),
quantity INT,
total\_price DECIMAL(10, 2),
order\_date TIMESTAMP DEFAULT NOW(),
FOREIGN KEY (student\_id) REFERENCES student(student\_id),
FOREIGN KEY (product\_id) REFERENCES product(product\_id)
);

INSERT INTO orders (order\_id, student\_id, product\_id, quantity, total\_price) VALUES
('o000001', 's000001', 'p000002', 2, 10.00),
('o000002', 's000003', 'p000003', 1, 8.99),
('o000003', 's000002', 'p000001', 3, 7.50),
('o000004', 's000004', 'p000004', 5, 9.95),
('o000005', 's000005', 'p000005', 1, 6.50);

-- Table: club\_team
CREATE TABLE club\_team (
club\_team\_id VARCHAR(10) PRIMARY KEY,
name VARCHAR(50),
description TEXT,
student\_id VARCHAR(10),
FOREIGN KEY (student\_id) REFERENCES student(student\_id)
);

INSERT INTO club\_team (club\_team\_id, name, description, student\_id) VALUES
('c000001', 'Art Club', 'A club for students who love to draw and paint', 's000001'),
('c000002', 'Chess Club', 'A club for students who love to play chess', 's000002'),
('c000003
예, 다음은 샘플 레코드가 포함된 업데이트된 테이블입니다:-- 테이블: 학생CREATE TABLE student (student\_id VARCHAR(10) PRIMARY KEY,name VARCHAR(50),email VARCHAR(50),phone\_number VARCHAR(8),date\_registered TIMESTAMP DEFAULT NOW());INSERT INTO 학생 (학생\_id, 이름, 이메일, 전화번호\_번호) VALUES('s000001', 'John Smith', '[johnsmith@example.com](mailto:johnsmith@example.com)', '98765432'),('s000002', 'Jane Doe', '[janedoe@example.com](mailto:janedoe@example.com)', '63235323'),('s000003', 'Bob Johnson', '[bjohnson@example.com](mailto:bjohnson@example.com)', '62345532'),('s000004', 'Mary Lee', '[marylee@example.com](mailto:marylee@example.com)', '92673454'),('s000005', 'David Kim', '[davidkim@example.com](mailto:davidkim@example.com)', '92324232');-- 테이블: 제품CREATE TABLE product (product\_id VARCHAR(10) PRIMARY KEY,name VARCHAR(50),description TEXT,price DECIMAL(10, 2),image\_url VARCHAR(100),is\_available BOOLEAN DEFAULT true,날짜\_추가된 타임스탬프 기본값 지금(),날짜\_업데이트된 타임스탬프 기본값 지금());INSERT INTO 제품 (제품\_id, 이름, 설명, 가격, 이미지\_url) VALUES('p000001', '펜', '그립이 있는 파란색 잉크펜', 2.50, '<https://example.com/pen.jpg>'),('p000002', 'Notebook', '100페이지 A5 양장 노트', 5.00, '<https://example.com/notebook.jpg>'),('p000003', '형광펜', '모듬색 형광펜 5개입', 8.99, '<https://example.com/highlighters.jpg>'),('p000004', '지우개', '다양한 색상의 지우개 3개 세트', 1.99, '<https://example.com/erasers.jpg>'),('p000005', '스테이플러', '스테이플 200개가 있는 표준 사이즈 스테이플러', 6.50, '<https://example.com/stapler.jpg>');-- 테이블: 주문CREATE TABLE orders (order\_id VARCHAR(10) PRIMARY KEY,student\_id VARCHAR(10),product\_id VARCHAR(10),수량 INT,total\_price DECIMAL(10, 2),order\_date TIMESTAMP DEFAULT NOW(),FOREIGN KEY (student\_id) REFERENCES student(student\_id),FOREIGN KEY (product\_id) REFERENCES product(product\_id));INSERT INTO orders (order\_id, student\_id, product\_id, quantity, total\_price) VALUES('o000001', 's000001', 'p000002', 2, 10.00),('o000002', 's000003', 'p000003', 1, 8.99),('o000003', 's000002', 'p000001', 3, 7.50),('o000004', 's000004', 'p000004', 5, 9.95),('o000005', 's000005', 'p000005', 1, 6.50);-- 테이블: club\_teamCREATE TABLE club\_team (club\_team\_id VARCHAR(10) PRIMARY KEY,name VARCHAR(50),설명 TEXT,student\_id VARCHAR(10),FOREIGN KEY (학생\_id) REFERENCES student(학생\_id));INSERT INTO club\_team (club\_team\_id, 이름, 설명, 학생\_id) VALUES('c000001', '미술부', '그림 그리는 것을 좋아하는 학생들을 위한 동아리', 's000001'),('c000002', '체스동아리', '체스를 좋아하는 학생들을 위한 동아리', 's000002'),('c000003