programmers-first-project

Tables (4)

order (Untitled3)

  • id (Key) — INT UNSIGNED — Primary key — NOT NULL
  • user_id (Key2) — INT UNSIGNED — Foreign key → user.id — NOT NULL
  • show_id (Key3) — INT UNSIGNED — Foreign key → show.id — NOT NULL
  • date (Field2) — DATETIME — NOT NULL
  • quantity (Field) — TINYINT UNSIGNED — NOT NULL

show (공연)

  • id (Key) — INT UNSIGNED — Primary key — NOT NULL
  • title (Field) — VARCHAR(1000) — NOT NULL
  • date (Field2) — DATETIME — NOT NULL
  • price (Field3) — INT UNSIGNED — NOT NULL
  • description (Field4) — VARCHAR(10000)

show_image (Untitled)

  • id (Key2) — INT UNSIGNED — Primary key — NOT NULL
  • show_id (Key) — INT UNSIGNED — Foreign key → show.id — NOT NULL
  • url (Field) — VARCHAR(1000) — NOT NULL

user (Untitled2)

  • id (Key) — INT UNSIGNED — Primary key — NOT NULL
  • name (Field) — VARCHAR(1000) — NOT NULL
  • email (Field2) — VARCHAR(1000) — NOT NULL
  • password (Field3) — VARCHAR(1000) — NOT NULL
  • phone_number (Field4) — VARCHAR(1000) — NOT NULL