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