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)