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)