Project
Tables (4)
Board (board)
- num (Num) — INT(10) — Primary key — NOT NULL
- userID (user_id) — VARCHAR(20) — Foreign key → Member.userID — NOT NULL
- id (Id) — VARCHAR(10)
- name (Name) — VARCHAR(10)
- subject (Subject) — VARCHAR(100)
- content (Content) — TEXT
- regist_day (Regist_Day) — VARCHAR(30)
- hit (Hit) — INT(10)
- ip (IP) — VARCHAR(20)
Member (member)
- userID (user_id) — VARCHAR(20) — Primary key — NOT NULL
- userPassword (user_password) — VARCHAR(20)
- userEmail (user_email) — VARCHAR(30)
- userEnFirtName (EnFirstname) — VARCHAR(20)
- userEnLastName (EnLastName) — VARCHAR(20)
- userKoName (KoName) — VARCHAR(20)
- userBirth (user_birth) — VARCHAR(30)
- userNumber (user_number) — VARCHAR(20)
Reservation (reservation)
- r_number — INT(10) — Primary key — NOT NULL
- userID (user_id) — VARCHAR(20) — Foreign key → Member.userID — NOT NULL
- room_id — INT(10) — Foreign key → Room.room_id — NOT NULL
- r_id — VARCHAR(30)
- r_adults — INT(10)
- r_kids — INT(10)
- r_checkin — DATE
- r_checkout — DATE
- r_type — VARCHAR(50)
- r_price — INT(10)
- r_time — INT(10
Room (room)
- room_id — INT(10) — Primary key — NOT NULL
- room_type — VARCHAR(50)
- room_size — INT(10)
- room_price — INT(10)
- room_img — VARCHAR(60)
- room_count (room_countc) — INT(10)