online-reservation-project
Tables (5)
Performance (pref) (공연)
- perf_id (공연ID) — int — Primary key — NOT NULL
- perf_name (이름) — varchar(45) — NOT NULL
- perf_description (설명) — varchar(400) — NOT NULL
- perf_category (Field3) — varchar(45) — NOT NULL
- perf_price (가격) — int — NOT NULL — 최대 50,000p
- perf_address (Field) — varchar(45) — NOT NULL
- perf_image (Field2) — varchar(200)
- created_At (업로드 시간) — timestamp — NOT NULL
- updated_At (수정 시간) — timestamp — NOT NULL
PerformanceDetail(prefd) (Untitled)
- perfd_id (Key) — int — Primary key — NOT NULL
- Perf_id (공연ID) — int — Foreign key → Performance (pref).perf_id — NOT NULL
- date (Field) — varchar(45) — NOT NULL
- time (Field2) — varchar(45) — NOT NULL
Reservation (res) (예매)
- res_id (예매ID) — int — Primary key — NOT NULL
- User_id (유저ID) — int — Foreign key → User.user_id — NOT NULL
- Pref_id (공연ID) — int — Foreign key → Performance (pref).perf_id — NOT NULL
- Seat_id (좌석ID) — int — Foreign key → Seat.seat_id — NOT NULL
- Perfd_id (Field3) — int — NOT NULL
- price (Field) — int — NOT NULL
- created_At (Field2) — timestamp — NOT NULL
Seat (좌석)
- seat_id (좌석ID) — int — Primary key — NOT NULL
- Perfd_id (Key) — int — Foreign key → PerformanceDetail(prefd).perfd_id — NOT NULL
- seat_row (열) — varcher(1) — NOT NULL — A~D
- seat_num (번호) — int — NOT NULL
- seat_reservation (예매여부) — tinyint(1) — NOT NULL
User (사용자)
- user_id (유저ID) — int — Primary key — NOT NULL
- user_email (아이디) — varchar(100) — NOT NULL
- user_password (비밀번호) — varchar(200) — NOT NULL — 암호화
- user_name (이름) — varchar(45) — NOT NULL
- user_point (포인트) — int — NOT NULL — 단위: p
- user_image (사진) — varchar(100)
- is_admin (Field) — tinyint(1) — NOT NULL — true 일시 admin