dfdf

Tables (11)

ANSWER

  • ANSWER_NO — NUMBER — Primary key — NOT NULL
  • MEM_NO — NUMBER — Foreign key → MEMBER.MEM_NO — NOT NULL
  • ANSWER_TITLE — VARCHAR2(255) — NOT NULL
  • ANSWER_CONTENT — VARCHAR2(1000) — NOT NULL
  • DATETIME — DATE — NOT NULL
  • STATUS — VARCHAR2(1)

ATTACH

  • ATTACH_NO — NUMBER — Primary key — NOT NULL
  • ATTACH_PATH — VARCHAR2(300)
  • ATTACH_ORIGIN — VARCHAR2(300)
  • ATTACH_CHANGE — VARCHAR2(300)
  • REVIEW_NO — NUMBER — Foreign key → REVIEW.REVIEW_NO — NOT NULL

MEMBER

  • MEM_NO — NUMBER — Primary key — NOT NULL
  • MEM_ID — VARCHAR2(100) — NOT NULL
  • MEM_EMAIL — VARCHAR2(100) — NOT NULL
  • MEM_PASSWORD — VARCHAR2(100) — NOT NULL
  • MEM_NAME — VARCHAR2(20) — NOT NULL
  • MEM_PHONE — VARCHAR2(13) — NOT NULL
  • MEM_ADDRESS — VARCHAR2(300)
  • MEM_GENDER — VARCHAR2(1)
  • MEM_LEVEL — NUMBER
  • MEM_REGDATE — DATE
  • STATUS — VARCHAR2(1)

NOTICE

  • NOTICE_NO — NUMBER — Primary key — NOT NULL
  • NOTICE_TITLE — VARCHAR2(255) — NOT NULL
  • NOTICE_CONTENT — VARCHAR2(1000) — NOT NULL
  • FILE — VARCHAR2(255)
  • DATETIME — DATE — NOT NULL
  • STATUS — VARCHAR2(1) — NOT NULL

PLACE

  • PLACE_NO — NUMBER — Primary key — NOT NULL
  • PLACE_ADDR — VARCHAR2(150)
  • PLACE_NAME — VARCHAR2(250)
  • PLACE_PHONE — VARCHAR2(200)
  • PLACE_GROUP — VARCHAR2(30)
  • PLACE_LON — NUMBER
  • PLACE_LAT — NUMBER
  • PLACE_CATEGORY — VARCHAR2(30)
  • PLACE_DATE — DATE
  • PLACE_STATUS — VARCHAR2(1)
  • REGION_NO — NUMBER — Foreign key → REGION.REGION_NO — NOT NULL
  • PLACE_URL — VARCHAR2(1000)
  • PLACE_COUNT — NUMBER
  • PLACE_SCORE — NUMBER
  • PLACE_TOTALSCORE — NUMBER
  • PLACE_SCORECOUNT — NUMBER

QUESTION

  • QUESTION_NO — NUMBER — Primary key — NOT NULL
  • MEM_NO — NUMBER — Foreign key → MEMBER.MEM_NO — NOT NULL
  • CATEGORY — VARCHAR2(10) — NOT NULL
  • QUESTION_TITLE — VARCHAR2(255) — NOT NULL
  • QUESTION_CONTENT — VARCHAR2(1000)
  • DATETIME — DATE — NOT NULL
  • STATUS — VARCHAR2(1) — NOT NULL

REGION

  • REGION_NO — NUMBER — Primary key — NOT NULL
  • REGION_NAME — VARCHAR2(255)

REVIEW

  • REVIEW_NO — NUMBER — Primary key — NOT NULL
  • REVIEW_TITLE — VARCHAR2(200) — NOT NULL
  • REVIEW_CONTENT — VARCHAR2(3000) — NOT NULL
  • REVIEW_REGDATE — DATE — NOT NULL
  • VISIT_COUNT — NUMBER — NOT NULL
  • REVIEW_STATUS — VARCHAR2(1) — NOT NULL
  • ATTACH_COUNT — NUMBER
  • MEM_NO — NUMBER — Foreign key → MEMBER.MEM_NO — NOT NULL
  • PLACE_NO — NUMBER — Foreign key → PLACE.PLACE_NO — NOT NULL

TRAVEL

  • TRAVEL_NO — NUMBER — Primary key — NOT NULL
  • TRAVEL_NAME — VARCHAR2(90)
  • TRAVEL_MEMO — VARCHAR2(900)
  • TRAVEL_REGDATE — DATE — NOT NULL
  • TRAVEL_STATUS — VARCHAR2(1) — NOT NULL
  • MEM_NO — NUMBER — Foreign key → MEMBER.MEM_NO — NOT NULL

TRAVEL_DETAIL

  • DETAIL_NO — NUMBER — Primary key — NOT NULL
  • TRAVEL_DATE — DATE — NOT NULL
  • TRAVEL_NO — NUMBER — Foreign key → TRAVEL.TRAVEL_NO — NOT NULL

TRAVEL_PLACE

  • DETAIL_NO — NUMBER — Foreign key → TRAVEL_DETAIL.DETAIL_NO — NOT NULL
  • PLACE_NO — NUMBER — Foreign key → PLACE.PLACE_NO — NOT NULL