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