StudyCafe

Tables (4)

Payment (Untitled4)

  • order_number (주문번호) — Foreign key → Reservation.order_number — NOT NULL
  • price (결제금액)
  • add_charge (추가요금)

Reservation (Untitled3)

  • order_number (주문번호) — Primary key — NOT NULL
  • start_time (시작시간)
  • end_time (종료시간)

Seat (Untitled2)

  • seat_number (좌석번호) — Primary key — NOT NULL
  • seat_user (좌석사용자)
  • reservation (예약가능상태)

Users (Untitled)

  • user_id (유저고유번호) — Primary key — NOT NULL
  • name (이름)
  • phone_number (전화번호)
  • password (비밀번호)
  • cash (가지고있는 금액)
  • grade (회원등급)