ss
Tables (13)
bed_type
- bedType_id — TINYINT — Primary key — NOT NULL
- bed_type_name — VARCHAR(20) — NOT NULL
file
- file_id — BIGINT — Primary key — NOT NULL
- file_name — VARCHAR(100) — NOT NULL
hotel
- hotel_id — BIGINT — Primary key — NOT NULL
- hotel_name — VARCHAR(100) — NOT NULL
member
- user_id — BIGINT — Primary key — NOT NULL
- username — VARCHAR(20) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- points — INT — NOT NULL
reservation
- reservation_id — BIGINT — NOT NULL
- user_id — BIGINT
- room_id — BIGINT — NOT NULL
- reservation_code — VARCHAR(30)
- user_number — INT
- reservation_date — DATETIME — NOT NULL
- user_name — VARCHAR(50)
- user_phone — VARCHAR(20)
reservation_status
- reservation_status_id — TINYINT — Primary key — NOT NULL
- reservation_status_name — VARCHAR(20) — NOT NULL
review
- review_id — BIGINT — Primary key — NOT NULL
- hotel_id — BIGINT — NOT NULL
- review_content — VARCHAR(200)
review_file
- file_id — BIGINT — Primary key — NOT NULL
- review_id — BIGINT — NOT NULL
room
- room_id — BIGINT — Primary key — NOT NULL
- room_name — VARCHAR(20) — NOT NULL
- floor — TINYINT — NOT NULL
- capacity — TINYINT — NOT NULL
- smoking_room — BOOLEAN — NOT NULL
- has_bathtub — BOOLEAN — NOT NULL
- room_status_id — TINYINT — NOT NULL
- hotel_id — BIGINT — NOT NULL
- price — BIGINT — NOT NULL
- premium_price — BIGINT — NOT NULL
- view_id — TINYINT — NOT NULL
- bedType_id — TINYINT — NOT NULL
- created_at — DATETIME — NOT NULL
room_file
- file_id — BIGINT — Primary key — NOT NULL
- room_id — BIGINT — NOT NULL
room_status
- room_status_id — TINYINT — Primary key — NOT NULL
- room_status_name — VARCHAR(20) — NOT NULL
user_point
- user_point_id — BIGINT — Primary key — NOT NULL
- point_balance — INT — NOT NULL
- point_detail — VARCHAR(150) — NOT NULL
- point_date — DATE — NOT NULL
- user_id — BIGINT — NOT NULL
view_type
- view_id — TINYINT — Primary key — NOT NULL
- view_name — VARCHAR(20) — NOT NULL