jeju

Tables (5)

1 (MEMBER_JEJU)

  • ID (아이디) — VARCHAR2 — Primary key — NOT NULL
  • SEQ (회원번호) — VARCHAR2
  • PW (비밀번호) — VARCHAR2
  • NAME (이름) — VARCHAR2
  • EMAIL (이메일) — VARCHAR2
  • BIRTH (생년월일) — VARCHAR2
  • DEL (삭제여부) — NUMBER
  • ISADMIN (관리자여부) — NUMBER

2 (SCHEDULES)

  • SEQ (여행일정번호) — NUMBER — Primary key — NOT NULL
  • ID (작성자) — VARCHAR2 — Foreign key → 1.ID — NOT NULL
  • TITLE (제목) — VARCHAR2
  • SDATE (시작일) — VARCHAR2
  • EDATE (종료일) — VARCHAR2
  • WDATE (작성일) — VARCHAR2

3 (DETAIL_SCHDULES)

  • SEQ (번호) — NUMBER — Primary key — NOT NULL
  • PARENT_SEQ (여행일정코드) — NUMBER — Foreign key → 2.SEQ — NOT NULL
  • STIME (일정시작시간) — VARCHAR2
  • DEST (여행목적지) — VARCHAR2

4 (SHIGHTS)

  • TITLE (관광지이름) — VARCHAR2 — Primary key — NOT NULL
  • SEQ (관광지번호) — NUMBER
  • CATEGORY (관광지종류) — NUMBER
  • THEME (관광지테마) — VARCHAR2
  • FILENAME (사진파일경로) — VARCHAR2
  • ADDRESS (관광지주소) — VARCHAR2
  • PHONE (관광지전화) — VARCHAR2
  • HOMEPAGE (관광지홈페이지) — VARCHAR2
  • CONTENT (관광지설명) — VARCHAR2
  • ADDSCHEDULE (일정추가횟수) — NUMBER
  • DEL (삭제여부) — NUMBER
  • READCOUNT (조회수) — NUMBER

5 (SHIGHTSREVIEW)

  • SEQ (리뷰번호) — VARCHAR2 — Primary key — NOT NULL
  • TITLE (관광지이름) — VARCHAR2 — Foreign key → 4.TITLE — NOT NULL
  • ID (작성자ID) — VARCHAR2
  • CONTENT (리뷰내용) — VARCHAR2
  • SCORE (평가점수) — NUMBER
  • Field