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