ontrip

테이블 (8)

Q&A (qna)

  • qnanum — number — 기본 키 — NOT NULL
  • qnatitle — varchar2(200)
  • qnadetail — varchar2(1000)
  • userid — varchar2(100)
  • qnapw — varchar2(200)
  • secret — varchar2(200)

관리자비밀번호 (adminpw)

  • adminpw — varchar2(200) — 기본 키 — NOT NULL

답변 (answer)

  • answernum — number — 기본 키 — NOT NULL
  • qnanum — number — 외래 키 → Q&A.qnanum — NOT NULL
  • id — varchar2(200)
  • answer — varchar2(500)

여행지 (country)

  • countrynum — number — 기본 키 — NOT NULL
  • country — varchar2(200)
  • tripname — varchar2(200)
  • tripimg — varchar2(300)
  • lat — varchar2(200)
  • llong — varchar2(200)
  • address — varchar2(300)
  • tripstyle — varchar2(100)
  • branch — number
  • tripdetail — varchar2(1000)

와이파이/이심 (wifi)

  • wifinum — number — 기본 키 — NOT NULL
  • wifiname — varchar2(200)
  • wifiimg — varchar2(500)
  • wifidetail — varchar2(1000)
  • wifilink — varchar2(500)
  • wificountry — varchar2(300)
  • wifiday — number

좋아요 (like)

  • countrynum — number — 외래 키 → 여행지.countrynum — NOT NULL
  • wifinum — number — 외래 키 → 와이파이/이심.wifinum — NOT NULL
  • packagenum — number — 외래 키 → 패키지.packagenum — NOT NULL
  • id — varchar2(200)
  • like — number

패키지 (package)

  • packagenum — number — 기본 키 — NOT NULL
  • packagename — varchar2(200)
  • packageimg — varchar2(500)
  • packagedetail — varchar2(1000)
  • packagelink — varchar2(500)
  • packagecountry — varchar2(300)
  • packageday — number

회원 (ontripuser)

  • usernymber (usernumber) — number — 기본 키 — NOT NULL
  • id — varchar2(200)
  • pw — varchar2(500)
  • phone — varchar2(100)
  • email — varchar2(200)
  • birth — varchar2(100)
  • tripstyle — varchar2(100)
  • admin — varchar2(200)