AccommodationManager
테이블 (5)
리뷰 (TB_REVIEW)
- ACC_NO (PK2) — NUMBER — 외래 키 → 숙박.ACC_NO — NOT NULL
- COMMENTS (Field) — VARCHAR2(100)
- SCORE (Field2) — NUMBER
- REGEDATE (Field3) — DATE
- MEMBER_NO (FK) — NUMBER — 외래 키 → 회원.MEMBER_NO — NOT NULL
숙박 (TB_Accommodation)
- ACC_NO (PK) — NUMBER — 기본 키 — NOT NULL
- ACC_TYPE (Field3) — CHAR(10)
- ACC_NAME (Field) — VARCHAR2(30)
- ACC_LOCAL (Field2) — CHAR(10)
- ROOM_NAME (Field4) — VARCHAR2(30)
- NUMBEROFPEOPLE (Field5) — NUMBER
- ROOM_INFO (Field6) — VARCHAR2(4000)
- PRICE (Field7) — NUMBER
예약 (TB_RESERVE)
- RESERVE_NO (PK) — NUMBER — 기본 키 — NOT NULL
- PRICE (Field4) — NUMBER
- REGDATE (Field) — DATE
- CHECKIN (Field2) — DATE
- CHECKOUT (Field3) — DATE
- MEMBER_NO (FK) — NUMBER — 외래 키 → 회원.MEMBER_NO — NOT NULL
- ACC_NO (PK2) — NUMBER — 외래 키 → 숙박.ACC_NO — NOT NULL
찜 (TB_WISHLIST)
- MEMBER_NO (PK) — NUMBER — 외래 키 → 회원.MEMBER_NO — NOT NULL
- ACC_NO (PK2) — NUMBER — 외래 키 → 숙박.ACC_NO — NOT NULL
회원 (TB_MEMBER)
- MEMBER_NO (PK) — NUMBER — 기본 키 — NOT NULL
- MEMBER_NAME (Field1) — VARCHAR2(20)
- MEMBER_ID (Field) — VARCHAR2(20) — NOT NULL
- MEMBER_PWD (Field2) — VARCHAR2(20)