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)