Myproject

Tables (3)

Member (Untitled)

  • member_no — number(10) — Primary key — NOT NULL
  • name — varchar2(50)
  • phone — varchar2(50)
  • join_date — date
  • remain_time — number(10)

Seat (Untitled2)

  • seat_no — number(10) — Primary key — NOT NULL
  • seat_status — number(1)

Usage (Untitled3)

  • usage_no — number(10) — Primary key — NOT NULL
  • start_time — date
  • end_time — date
  • member_no — number(10) — Foreign key → Member.member_no — NOT NULL
  • seat_no — number(10) — Foreign key → Seat.seat_no — NOT NULL