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 (회원등급)