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)