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