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