신동석

테이블 (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)