SPRING_FOR_PPT
Tables (13)
AREA
- Key (AREANUM) — NUMBER — Primary key — NOT NULL
- DO — VARCHAR2(20 BYTE)
- SI — VARCHAR2(20 BYTE)
- GU — VARCHAR2(20 BYTE)
- DONG — VARCHAR2(20 BYTE)
- LAT — NUMBER
- LNG — NUMBER
ATTR
- Key (CONTENT_ID) — NUMBER — Primary key — NOT NULL
- Key2 (TYPE_ID) — NUMBER — Primary key — NOT NULL
- 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)
FAV
- Key — NUMBER — Primary key — NOT NULL
- BOARDNO — NUMBER
- USER_ID — VARCHAR2(100 BYTE) — Foreign key
- Key (Key2) — Foreign key → USERS.Key — NOT NULL
MEDIA
- Key2 (MEDIA_ID) — NUMBER — Primary key — NOT NULL
- TITLE — VARCHAR2(100 BYTE)
- STOR_URL — VARCHAR2(225 BYTE)
- CONTENTID — NUMBER
- SORT_NO — NUMBER
- USER_ID — VARCHAR2(100 BYTE) — Foreign key
- BOARDNO — NUMBER — Foreign key
- Key — Foreign key → TBL_BOARD.Key — NOT NULL
- Key (Key2) — Foreign key → USERS.Key — NOT NULL
POI
- Key (POI_ID) — NUMBER — Primary key — NOT NULL
- 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) — Foreign key
- POINT_TOTAL — NUMBER
- POINT_GET — NUMBER
- POINT_OUT — NUMBER
- POINT_DATE — DATE
- Key — Foreign key → USERS.Key — NOT NULL
REPORT
- Key (REPROTNUM) — VARCHAR2(20 BYTE) — Primary key — NOT NULL
- 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
- Key2 (RESNUM) — NUMBER — Primary key — NOT NULL
- USER_ID — VARCHAR2(100 BYTE) — Foreign key
- PACKNAME — VARCHAR2(50 BYTE)
- PRICE — NUMBER
- AREANUM — NUMBER — Foreign key
- 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
- Key (BOARDNO) — NUMBER — Primary key — NOT NULL
- 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
- Key (BOARDNO) — NUMBER — Primary key — NOT NULL
- COMMENTNO — 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)
- Key (BOARDNO2) — NUMBER — Foreign key → TBL_BOARD.Key — NOT NULL
TBL_REVIEW
- Key2 (BOARDNO) — NUMBER — Primary key — NOT NULL
- USER_ID — VARCHAR2(100 BYTE) — Foreign key
- FAV — NUMBER
- CNT — NUMBER
- CDATETIME — DATE
- RES_NUM — NUMBER — Foreign key
- Key — Foreign key → USERS.Key — NOT NULL
- Key2 — Foreign key → RESERVATION.Key2 — NOT NULL
- Key (Key22) — Foreign key — NOT NULL
THEME
- Key (THEMENUM) — NUMBER — Primary key — NOT NULL
- THEMENAME — VARCHAR2(50 BYTE)
- THEMECODE — VARCHAR2(30 BYTE)
- SORT_NO — NUMBER
USERS
- Key (USER_ID) — VARCHAR2(100 BYTE) — Primary key — NOT NULL
- 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