독서실 예약

테이블 (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