MiniProject
Tables (4)
Untitled (seat)
- Field (seat_number) — char(2) — Primary key — NOT NULL
- musical_id — number — Foreign key → musical.musical_id — NOT NULL
- Field (sold) — char(1)
Untitled (ticket)
- Key (ticketid) — number — Primary key — NOT NULL
- user_id (userid) — varchar2 — Foreign key → User.user_id — NOT NULL
- Field (seat_number) — char(2) — Foreign key → Untitled.Field — NOT NULL
- musical_id — number — Foreign key → Untitled.musical_id — NOT NULL
User (users)
- user_id (userid) — varchar2 — Primary key — NOT NULL
- name — varchar2 — NOT NULL
- age — number
- gender — char(1)
- Field (password)
musical
- musical_id — number — Primary key — NOT NULL
- Field (title) — varchar2 — NOT NULL
- Field2 (actor) — varchar2
- Field3 (genre) — varchar2
- Field4 (date) — date
- Field (hall)