TripMate
Tables (20)
AREA
- SEQ — NUMBER
- NAME — VARCHAR2(500 BYTE)
- LOCATION — VARCHAR2(600 BYTE)
- PHOTO — VARCHAR2(600 BYTE)
AREA_REPLY
- SEQ — NUMBER
- MEM_SEQ — NUMBER
- AREA_SEQ — NUMBER
- MEM_NICK — VARCHAR2(30 BYTE)
- PHOTO — VARCHAR2(200 BYTE)
- TEXT — VARCHAR2(3000 BYTE)
- SCORE — NUMBER
CB_HEART
- SEQ — NUMBER
- PAR_SEQ — NUMBER
- MEM_SEQ — NUMBER
COMPANY_BOARD
- SEQ — NUMBER
- MEM_SEQ — NUMBER
- TITLE — VARCHAR2(100 BYTE)
- CONTENTS — VARCHAR2(3000 BYTE)
- RECRUIT — NUMBER
- PRESENT — NUMBER
- TOUR — VARCHAR2(30 BYTE)
- GENDER — VARCHAR2(6 BYTE)
- START_DATE — DATE
- END_DATE — DATE
- EXPIRED — VARCHAR2(20 BYTE)
- WRITEN_DATE — DATE
- VIEW_COUNT — NUMBER
- REC_COUNT — NUMBER
- REP_COUNT — NUMBER
- NICK — VARCHAR2(100 BYTE)
- BOARD_NUM — NUMBER
COM_MEM
- PAR_SEQ — NUMBER
- MEM_SEQ — NUMBER
COM_REPLY
- SEQ — NUMBER
- PAR_SEQ — NUMBER
- MEM_SEQ — NUMBER
- CONTENTS — VARCHAR2(1000 BYTE)
- WRITEN_DATE — DATE
- NICK — VARCHAR2(100 BYTE)
COM_REPLY_REPLY
- SEQ — NUMBER
- PAR_SEQ — NUMBER
- MEM_SEQ — NUMBER
- CONTENTS — VARCHAR2(1000 BYTE)
- WRITEN_DATE — DATE
- NICK — VARCHAR2(100 BYTE)
DASHBOARD
- STAN_DATE — NUMBER
- VISITOR — NUMBER
- USER_N — NUMBER
- PLAN — NUMBER
- TOUR_BOARD — NUMBER
- COM_BOARD — NUMBER
DETAIL_PLAN
- PAR_SEQ — NUMBER
- AREA_SEQ — NUMBER
- PLAN_DATE — DATE
- SEQ — NUMBER
MEMBER
- SEQ — NUMBER
- EMAILID — VARCHAR2(100 BYTE)
- PW — VARCHAR2(150 BYTE)
- NICK — VARCHAR2(30 BYTE)
- GENDER — VARCHAR2(20 BYTE)
- AGE — NUMBER
- PHONE — VARCHAR2(30 BYTE)
- PH_OPEN — VARCHAR2(20 BYTE)
- PREFERENCE — VARCHAR2(30 BYTE)
- TEXT — VARCHAR2(255 BYTE)
- PHOTO — VARCHAR2(200 BYTE)
- VIOLATION — NUMBER
- SNS_DIVISION — VARCHAR2(100 BYTE)
- SIGNUP_DATE — DATE
NOTICE
- SEQ — NUMBER
- TITLE — VARCHAR2(100 BYTE)
- CONTENTS — VARCHAR2(4000 BYTE)
- NICK — VARCHAR2(30 BYTE)
- WRITEN_DATE — DATE
- VIEW_COUNT — NUMBER
PLAN
- SEQ — NUMBER
- MEM_SEQ — NUMBER
- TITLE — VARCHAR2(100 BYTE)
- STARTDATE — DATE
- ENDDATE — DATE
- THEME — VARCHAR2(30 BYTE)
- ACCOUNT — NUMBER
- MEMO — VARCHAR2(4000 BYTE)
- WRITEN_DATE — DATE
REACTIONS
- SEQ — NUMBER
- MEM_SEQ — NUMBER
- LOGINSEQ — NUMBER
- TITLE — VARCHAR2(120 BYTE)
- NICK — VARCHAR2(50 BYTE)
- BOARD_NUM — NUMBER
- REACTION — VARCHAR2(100 BYTE)
- REACTIONER — VARCHAR2(100 BYTE)
- TIME — DATE
SAVED
- SEQ — NUMBER
- MEM_SEQ — NUMBER
- AREA_SEQ — NUMBER
TB_HEART
- SEQ — NUMBER
- PAR_SEQ — NUMBER
- MEM_SEQ — NUMBER
TEMP
- PAR_SEQ — NUMBER
- AREA_SEQ — NUMBER
- PLAN_DATE — DATE
- SEQ — NUMBER
TOUR_BOARD
- SEQ — NUMBER
- MEM_SEQ — NUMBER
- TITLE — VARCHAR2(100 BYTE)
- CONTENTS — VARCHAR2(4000 BYTE)
- CATEGORY — VARCHAR2(10 BYTE)
- WRITEN_DATE — DATE
- VIEW_COUNT — NUMBER
- REC_COUNT — NUMBER
- REP_COUNT — NUMBER
- NICK — VARCHAR2(100 BYTE)
- BOARD_NUM — NUMBER
TOUR_REPLY
- SEQ — NUMBER
- PAR_SEQ — NUMBER
- MEM_SEQ — NUMBER
- CONTENTS — VARCHAR2(1000 BYTE)
- WRITEN_DATE — DATE
- NICK — VARCHAR2(100 BYTE)
TOUR_REPLY_REPLY
- SEQ — NUMBER
- PAR_SEQ — NUMBER
- MEM_SEQ — NUMBER
- CONTENTS — VARCHAR2(1000 BYTE)
- WRITEN_DATE — DATE
- NICK — VARCHAR2(100 BYTE)
VISIT
- V_DATE — DATE