111
Tables (10)
Cart
- cart_id — NUMBER(10)
- member_id — NUMBER(10)
- item_id — NUMBER(10)
- quantity — NUMBER(5)
- created_at — DATE
Class
- class_id — NUMBER(10)
- title — VARCHAR2(255) — NOT NULL
- description — CLOB
- location — VARCHAR2(255)
- start_date — DATE
- end_date — DATE
- price — NUMBER(10, 2) — NOT NULL
- instructor_id — NUMBER(10)
- created_at — DATE
Delivery
- delivery_id — NUMBER(10)
- order_id — NUMBER(10)
- delivery_address — VARCHAR2(255)
- delivery_date — DATE
- status — VARCHAR2(20)
- created_at — DATE
Inquiry
- inquiry_id — NUMBER(10)
- member_id — NUMBER(10)
- instructor_id — NUMBER(10)
- subject — VARCHAR2(255)
- message — CLOB
- created_at — DATE
Instructor
- 강사ID (instructor_id) — NUMBER(10) — Primary key — NOT NULL
- instructor_id (11) — NUMBER(10)
- full_name — VARCHAR2(255) — NOT NULL
- email — VARCHAR2(255) — NOT NULL
- phone_number — VARCHAR2(20)
- bio — CLOB
- created_at — DATE
Member
- member_id — NUMBER(10)
- username — VARCHAR2(255) — NOT NULL
- password — VARCHAR2(255) — NOT NULL
- full_name — VARCHAR2(255) — NOT NULL
- email — VARCHAR2(255) — NOT NULL
- phone_number — VARCHAR2(20)
- created_at — DATE
Order
- order_id — NUMBER(10)
- member_id — NUMBER(10)
- total_amount — NUMBER(10, 2)
- order_date — DATE
- status — VARCHAR2(20)
- created_at — DATE
Reservation
- reservation_id — NUMBER(10)
- class_id — NUMBER(10)
- member_id — NUMBER(10)
- reservation_date — DATE
- status — VARCHAR2(20)
- created_at — DATE
Review
- review_id — NUMBER(10)
- class_id — NUMBER(10)
- member_id — NUMBER(10)
- rating — NUMBER(1, 0)
- comment — CLOB — LO
- created_at — DATE
SharedItem
- item_id — NUMBER(10)
- title — VARCHAR2(255)
- description — CLOB
- price — NUMBER(10, 2)
- seller_id — NUMBER(10)
- created_at — DATE