Angmond

Tables (5)

Cart (찜목록)

  • Cart_Num (찜__번호) — INT — Primary key — NOT NULL
  • Room_Type (방타입) — char(10)
  • Stroe_Name (지점명) — vchar(20)
  • User_id (회원_아이디2) — char(15) — Foreign key → Users.User_id — NOT NULL

Reservation (예약목록)

  • R_Num (예약번호) — INT — Primary key — NOT NULL
  • Room_Type (방타입) — char(10)
  • Store_Name (지점) — vchar(20)
  • User_id (회원_아이디2) — char(15) — Foreign key → Users.User_id — NOT NULL

Rooms (룸실)

  • Room_Type (방타입) — char(10) — Primary key — NOT NULL
  • Room_Price (방가격) — INT
  • Room_Current (방갯수) — INT
  • Store_Name (지점명2) — vchar(20) — Foreign key → Store.Store_Name — NOT NULL
  • R_Num (예약번호) — INT — Foreign key → Reservation.R_Num — NOT NULL
  • Cart_Num (찜__번호) — INT — Foreign key → Cart.Cart_Num — NOT NULL

Store (지점)

  • Store_Name (지점명) — vchar(20) — Primary key — NOT NULL
  • R_Num (예약번호) — INT — Foreign key → Reservation.R_Num — NOT NULL

Users (회원)

  • User_id (회원_아이디) — char(15) — Primary key — NOT NULL
  • User_Name (회원_이름) — varchar(10)
  • User_pw (회원_비밀번호) — varchar(20)
  • User_Email (회원_이메일) — varchar(25)
  • User_Tel (회원_전화번호) — varchar(12) — NOT NULL