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)