Trip

테이블 (3)

문의사항 (qna)

  • qnanumber — number — 기본 키 — NOT NULL
  • usernumber — number — 외래 키 → 유저.usernumber — NOT NULL
  • qnatitle — varchar2(100)
  • qnadetail — varchar2(500)
  • id — varchar2(100)
  • qnapw — varchar2(500)
  • answer — varchar2(500)
  • qdate — date
  • adate — date
  • qnaimg — varchar2(500)

여행국가 (country)

  • countrynum — number — 기본 키 — NOT NULL
  • country — varchar2(100)
  • city — varcahar2(200)
  • tripstyle — varchar2(200)
  • contentname — varchar2(200)
  • contentdetail — varchar2(200)
  • recommandmonth — varchar2(100)
  • countrydetail — varchar2(500)

유저 (user)

  • usernumber — number — 기본 키 — NOT NULL
  • id — varchar2(100)
  • pw — varchar2(500)
  • phone — varchar2(100)
  • email — varcahr2(300)
  • age — number
  • tripstyle — varchar2(100)