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)