Spring_team
Tables (16)
AREA
- AREANUM — NUMBER
- DO — VARCHAR2(20 BYTE)
- SI — VARCHAR2(20 BYTE)
- GU — VARCHAR2(20 BYTE)
- DONG — VARCHAR2(20 BYTE)
- LAT — NUMBER
- LNG — NUMBER
ATTR
- CONTENT_ID — NUMBER
- TYPE_ID — NUMBER
- MOOD_UNIQUE — NUMBER(3,2)
- ADVENTURE — FLOAT(126)
- BUDGET — FLOAT(126)
- COUPLE — FLOAT(126)
- FAMILY — FLOAT(126)
- FRIEND — FLOAT(126)
- HEALING — FLOAT(126)
- LUXURY — FLOAT(126)
- QUIET — FLOAT(126)
- MAPX — NUMBER(18,10)
- MAPY — NUMBER(18,10)
CUPON
- CUPON_ID — VARCHAR2(40 BYTE)
- NAME — VARCHAR2(50 BYTE)
- DIS_RATE — NUMBER
- ISSUE_DT — DATE
- EXPIRY_DT — DATE
- USER_ID — VARCHAR2(100 BYTE)
- USED — CHAR(1 BYTE)
FAV
- FAVNO — NUMBER
- BOARDNO — NUMBER
- USER_ID — VARCHAR2(100 BYTE)
MEDIA
- MEDIA_ID — NUMBER
- TITLE — VARCHAR2(100 BYTE)
- STOR_URL — VARCHAR2(225 BYTE)
- CONTENTID — NUMBER
- SORT_NO — NUMBER
- USER_ID — VARCHAR2(100 BYTE)
- BOARDNO — NUMBER
POI
- POI_ID — NUMBER
- CONTENT_ID — NUMBER
- TYPE_ID — NUMBER
- RES_NUM — NUMBER
- RESERV_DATE — DATE
- RATING — NUMBER
- CONTENT — CLOB
- PLACE_NAME — VARCHAR2(255 BYTE)
POINT
- USER_ID — VARCHAR2(100 BYTE)
- POINT_TOTAL — NUMBER
- POINT_GET — NUMBER
- POINT_OUT — NUMBER
- POINT_DATE — DATE
REPORT
- REPORTNUM — VARCHAR2(20 BYTE)
- REPORT_TYPE — VARCHAR2(10 BYTE)
- REPORTED_USER_ID — VARCHAR2(100 BYTE)
- CONTENT — VARCHAR2(100 BYTE)
- BOARDNO — NUMBER
- COMMENTNO — NUMBER
- REPORT_CNT — NUMBER
- REPORT_USER_ID — VARCHAR2(100 BYTE)
RESERVATION
- RES_NUM — NUMBER
- USER_ID — VARCHAR2(100 BYTE)
- PACKNAME — VARCHAR2(50 BYTE)
- PRICE — NUMBER
- AREANUM — NUMBER
- THEMNUM — VARCHAR2(50 BYTE)
- DESCRIPT — VARCHAR2(400 BYTE)
- RDATETIME — DATE
- STATUS — VARCHAR2(20 BYTE)
- DEADLINE — DATE
- START_DATE — DATE
- END_DATE — DATE
- ETC_CONTENT — VARCHAR2(400 BYTE)
- FOOD_BUDGET — NUMBER(10,2)
- ACCOM_BUDGET — NUMBER(10,2)
- ETC_BUDGET — NUMBER(10,2)
- ACT_BUDGET — NUMBER(10,2)
TBL_BOARD
- BOARDNO — NUMBER
- USER_ID — VARCHAR2(100 BYTE)
- TITLE — VARCHAR2(50 BYTE)
- CONTENTS — CLOB
- FAV — NUMBER
- CNT — NUMBER
- CDATETIME — DATE
- UDATETIME — DATE
- TYPE — CHAR(2 BYTE)
- REPORT_CNT — NUMBER
TBL_COMMENT
- COMMENTNO — NUMBER
- BOARDNO — NUMBER
- USER_ID — VARCHAR2(100 BYTE)
- ORG_CMTNO — NUMBER
- CONTENTS — VARCHAR2(100 BYTE)
- ADOPT — CHAR(1 BYTE)
- CDATETIME — DATE
- UDATETIME — DATE
- NICKNAME — VARCHAR2(20 BYTE)
TBL_REVIEW
- BOARDNO — NUMBER
- USER_ID — VARCHAR2(100 BYTE)
- FAV — NUMBER
- CNT — NUMBER
- CDATETIME — DATE
- RES_NUM — NUMBER
THEME
- THEMENUM — NUMBER
- THEMENAME — VARCHAR2(50 BYTE)
- THEMECODE — VARCHAR2(30 BYTE)
- SORT_NO — NUMBER
TRIP_ITINERARY_ITEM
- ID — NUMBER(19,0)
- CONTENT_ID — NUMBER(19,0)
- CONTENT_TYPE_ID — NUMBER(10,0)
- DAY_NUMBER — NUMBER(10,0)
- MAPX — VARCHAR2(255 CHAR)
- MAPY — VARCHAR2(255 CHAR)
- ORDER_NUMBER — NUMBER(10,0)
- PLACE_NAME — VARCHAR2(255 CHAR)
- PRICE — NUMBER(10,0)
- TRIP_ID — NUMBER(19,0)
TRIP_RESERVATION
- ID — NUMBER(19,0)
- CREATED_AT — TIMESTAMP
- END_DATE — DATE
- HEAD_COUNT — NUMBER(10,0)
- START_DATE — DATE
- TOTAL_BUDGET — NUMBER(19,0)
- TRIP_NAME — VARCHAR2(255 CHAR)
- USER_ID — VARCHAR2(255 CHAR)
USERS
- USER_ID — VARCHAR2(100 BYTE)
- NAME — VARCHAR2(30 BYTE)
- PASSWORD — VARCHAR2(225 BYTE)
- NICKNAME — VARCHAR2(20 BYTE)
- PHONE — VARCHAR2(20 BYTE)
- BIRTH — DATE
- ADDR — VARCHAR2(225 BYTE)
- STATUS — CHAR(1 BYTE)
- EMAIL — VARCHAR2(225 BYTE)
- GENDER — CHAR(1 BYTE)
- CDATETIME — DATE
- UDATETIME — DATE
- CNT — NUMBER
- END_SUBS — DATE