신동석
테이블 (9)
MEMBER
- MEMBER_ID — varchar2(10) — 기본 키 — NOT NULL
- MEMBER_PASSWORD — varchar2(200) — NOT NULL
- EMAIL — varchar2(100) — NOT NULL
- ENROLL_DATE — SYSDATE
- city — varchar2(30)
- country — varchar2(30)
- PHONE — number
- image — blob
- grade — varchar2(20)
- avgscore — number
- introduce — varchar2(200)
- pay — char(20)
- Field — VARCHAR(255)
NOTICE
- NOTICE_NO — NUMBER — 기본 키 — NOT NULL
- NOTICE_TITLE — VARCHAR2(100) — NOT NULL — 해당 지역 코드
- NOTICE_WRITER — VARCHAR2(15)
- NOITCE_CONTENT — VARCHAR2(4000)
- NOTICE_DATE — DATE
- FILEPATH — VARCHAR2(1)
- STATUS — VARCHAR2(1) — NOT NULL — 해당 지도 경도
- cat1 — VARCHAR2(38)
Place
- contentid — varchar2(100) — 기본 키 — NOT NULL
- address — VARCHAR2(1000) — NOT NULL
- areacode — number(100) — NOT NULL — 해당 지역 코드
- sigungucode — number(100)
- cat3 — VARCHAR2(38)
- contenttypeid — varchar2(100)
- firstimage — varchar2(200)
- mapx — VARCHAR2(1000) — NOT NULL — 해당 지도 경도
- mapy — VARCHAR2(1000) — NOT NULL — 해당 장소 위도
- TITLE — VARCHAR2(100) — 해당 관광지 이름
- cat1 — VARCHAR2(38)
- cat2 — VARCHAR2(38)
REVIEW
- MEMBER_ID — varchar2(10) — 외래 키 → MEMBER.MEMBER_ID — NOT NULL
- REVIEW_NO — // — NOT NULL
- REVIEW_TITLE — varchar2(100)
- REVIEW_CONTENT — varchar2(1000)
- REVIEW_IMAGE — blob — NOT NULL
- REVIEW_DATE — sysdate
chat
- MEMBER_ID — varchar2(10) — 외래 키 → MEMBER.MEMBER_ID — NOT NULL
- content — varchar2(1000)
- DATE — varchar2(100)
- ROOM — varchar2(30)
plan
- PLAN_CODE — varchar2(100) — 기본 키 — NOT NULL
- PLANNER_NO — varchar2(10) — 외래 키 → planner.PLANNER_NO — NOT NULL
- MEMBER_ID — varchar2(10) — 외래 키 → planner.MEMBER_ID — NOT NULL
- DAY — varchar2(10)
- LATITUDE — varchar2(1000)
- LONGITUDE — varchar2(1000)
- MEMO — varchar2(1000)
- PLACE_NAME — varchar2(100)
planner
- PLANNER_NO — varchar2(10) — 기본 키 — NOT NULL
- MEMBER_ID — varchar2(10) — 외래 키 → MEMBER.MEMBER_ID — NOT NULL
- PLANNER_TITLE — varchar2(1000)
- TRAVEL_DAYS — number
- WRITTEN_DATE — DATE
- IMAGES — varchar2(100)
- THEME — varchar(100)
- AREACODE — NUMBER
- SIGUNGUCODE — NUMBER
- SCORE — number
report
- MEMBER_ID2 — varchar2(10) — 외래 키 → MEMBER.MEMBER_ID — NOT NULL
- MEMBER_ID — varchar2(10)
- PLAN_ID — varchar2(10)
- TITLE — varchar2(1000)
- content — varchar2(1000)
- DATE — sysdate
request
- MEMBER_ID — varchar2(10) — 기본 키 — NOT NULL
- PLANNER_NO — varchar2(10) — 외래 키 → planner.PLANNER_NO — NOT NULL
- MEMBER_ID2 — varchar2(10) — 외래 키 → planner.MEMBER_ID — NOT NULL
- PLANNER_ID — varchar2(10)
- CONTENT — varchar2(100)
- STARTDAY — varchar2(30)
- ENDDAY — VARCHAR(255)
- TRANSPORT — varchar2(100)
- THEME — varchar2(100)
- Approval — varchar2(10)
- Payment_Status — varchar2(10)