독서실 예약
테이블 (6)
Payment (payment)
- payment_id (Key) — bigint — 기본 키 — NOT NULL
- email — varchar(100) — 외래 키 → User.email — NOT NULL
- payment_type (Field) — varchar(20)
- total_amount (Field2) — varchar(20)
- installment (Field3) — vharchar(20)
Seat (seats)
- seat_number — bigint — 기본 키 — NOT NULL
- status (seat_zone) — varchar(10)
- useYn (seat_type) — char(1)
- seat_zone (use_yn) — char(1)
Ticket (tickets)
- Key (ticket_id) — bigint — 기본 키 — NOT NULL
- ticket_type — varchar(10)
- Field2 (time_slot) — varchar(10)
- Field (ticket_time) — bigint
User (users)
- email — varchar(100) — 기본 키 — NOT NULL
- password — varchar(100)
- Field
UserSeat (user_seat)
- email — varchar(100) — 외래 키 → User.email — NOT NULL
- seat_number — bigint — 외래 키 → Seat.seat_number — NOT NULL
- create_at (Field) — datetime
- code (Field2) — varchar(20)
UserTicket (user_ticket)
- email (user_ticket_id) — bigint — 기본 키 — NOT NULL
- Key (ticket_id) — bigint — 외래 키 → Ticket.Key — NOT NULL
- email — varchar(100) — 외래 키 → User.email — NOT NULL
- Field (created_at) — datetime
- Field (updated_at) — datetime
- Field (start_date) — datetime
- Field (end_date) — datetime
- Field (expire_time) — bigint