erd1
Tables (3)
member
- member_number — NUMBER(10) — Primary key — NOT NULL
- name — VARCHAR2(50)
- id — VARCHAR2(50)
- password — VARCHAR2(50)
- mnum — NUMBER(10) — Foreign key → movies.mnum — NOT NULL
- member_number (member_number2) — NUMBER(10) — Foreign key → reservation.member_number — NOT NULL
- mnum (mnum2) — NUMBER(10) — Foreign key → reservation.mnum — NOT NULL
movies
- mnum — NUMBER(10) — Primary key — NOT NULL
- movie — VARCHAR2(100)
- director — VARCHAR2(50)
- count — NUMBER(5)
- price — NUMBER(10, 2)
reservation
- member_number — NUMBER(10) — Primary key — NOT NULL
- mnum — NUMBER(10) — Foreign key → movies.mnum — NOT NULL
- reservation_date — DATE
- seats — NUMBER(3)