programmers_공연데이터베이스

테이블 (3)

Untitled (Users)

  • Key (user_id) — INT — 기본 키 — NOT NULL
  • Field2 (username) — VARCHAR(255)
  • Field (email) — VARCHAR(255)
  • Field (password) — VARCHAR(255)
  • Field (phone_number) — VARCHAR(30)

bookings (Bookings)

  • Key (booking_id) — INT — 기본 키 — NOT NULL
  • Field (booking_date) — DATETIME
  • Field (seat_number) — VARCHAR(255)
  • Field (quantity) — INT
  • Key (performance_id) — INT — 외래 키 → performances.Key — NOT NULL
  • Key (user_id) — INT — 외래 키 → Untitled.Key — NOT NULL

performances (Performances)

  • Key (performance_id) — INT — 기본 키 — NOT NULL
  • Field2 (title) — VARCHAR(255)
  • Field (date) — DATETIME
  • Field (venue) — VARCHAR(255)
  • Field (ticket_price) — FLOAT
  • Field (availability) — BOOLEAN
  • Field (image_url) — VARCHAR(255)