test
Tables (22)
AUTO_LOGIN
- AUTO_LG_UNO — NUMBER — Foreign key → USER_TB.USER_NO — NOT NULL
- AUTO_SESSIONKEY — VARCHAR2(500)
- AUTO_EXPIRYDATE — DATE
DAYCOUNT
- VISIT_DATE — DATE — Primary key — NOT NULL
- USER_NO — NUMBER — Foreign key → USER_TB.USER_NO — NOT NULL
DAYTOTAL
- VISIT_DATE — DATE — Primary key — NOT NULL
- TOTAL_COUNT — NUMBER — NOT NULL
FAQ
- FAQ_NO — NUMBER — Primary key — NOT NULL — SEQ_FAQ_NO;
- FAQ_TITLE — VARCHAR2(300) — NOT NULL
- FAQ_CONTENT — CLOB — NOT NULL
- FAQ_ENROLL_DATE — DATE — NOT NULL
- FAQ_MODIFY_DATE — DATE — NOT NULL
- FAQ_STATUS — VARCHAR2(1) — NOT NULL
- FAQ_WRITER — NUMBER — Foreign key → USER_TB.USER_NO — NOT NULL
FOLLOW_TB
- FOLLOW — NUMBER — Foreign key → USER_TB.USER_NO — NOT NULL
- FOLLOWER — NUMBER — Foreign key → USER_TB.USER_NO — NOT NULL
HISTORY
- RESERVE_NO — NUMBER — Foreign key → RESERVE.RESERVE_NO — NOT NULL
- REWARD_NO — NUMBER — Foreign key → REWARD.REWARD_NO — NOT NULL
- REWARD_SUM — NUMBER — NOT NULL — 리워드개수;
LIKE_TB
- LIKE_USER — NUMBER — Foreign key → USER_TB.USER_NO — NOT NULL
- LIKE_PRJ — NUMBER — Foreign key → PROJECT_TB.PROJECT_NO — NOT NULL
NOTICE
- NOTICE_NO — NUMBER — Primary key — NOT NULL — SEQ_NOT_NO;
- NOTICE_TITLE — VARCHAR2(300) — NOT NULL
- NOTICE_CONTENT — CLOB — NOT NULL
- NOTICE_ER_DT — DATE — NOT NULL
- NOTICE_MF_DT — DATE — NOT NULL
- NOTICE_STATUS — VARCHAR2(1) — NOT NULL
- NOTICE_WRITER — NUMBER — Foreign key → USER_TB.USER_NO — NOT NULL
PROJECT_CG
- PROJECT_CT_NO — NUMBER — Primary key — NOT NULL — CATEGORY_NO/프로젝트카테고리번호;
- PROJECT_CT_NAME — VARCHAR2(100) — NOT NULL
PROJECT_STATUS
- PROJECT_ST_NO — NUMBER — Primary key — NOT NULL — STATUS_NO/프로젝트상태번호;
- PROJECT_ST_DETAIL — VARCHAR2(100) — NOT NULL
PROJECT_TB
- PROJECT_NO — NUMBER — Primary key — NOT NULL — SEQ_PROJ_NO;
- PROJECT_TITLE — VARCHAR2(100) — NOT NULL
- PROJECT_STITLE — VARCHAR2(200) — NOT NULL
- PROJECT_GOAL — NUMBER — NOT NULL
- PROJECT_THUMB_IMG — VARCHAR2(400) — NOT NULL
- PROJECT_START_DT — DATE — NOT NULL
- PROJECT_CLOSE_DT — DATE — NOT NULL
- PROJECT_HASHTAG — VARCHAR2(4000)
- PROJECT_MAIN_IMG — VARCHAR2(400) — NOT NULL
- PROJECT_SUMMARY — VARCHAR2(400) — NOT NULL
- PROJECT_STORY — CLOB — NOT NULL
- PROJECT_AT_NM — VARCHAR2(100) — NOT NULL
- PROJECT_AT_PF — VARCHAR2(400) — NOT NULL
- PROJECT_AT_SNS1 — VARCHAR2(100)
- PROJECT_AT_SNS2 — VARCHAR2(100)
- PROJECT_AT_CONT — VARCHAR2(100)
- PROJECT_AT_EM — VARCHAR2(100)
- PROJECT_ER_DT — DATE — NOT NULL
- PROJECT_MF_DT — DATE — NOT NULL
- PROJECT_WRITER — NUMBER — Foreign key → USER_TB.USER_NO — NOT NULL
- PROJECT_CT_NO — NUMBER — Foreign key → PROJECT_CG.PROJECT_CT_NO — NOT NULL
- PROJECT_ST_NO — NUMBER — Foreign key → PROJECT_STATUS.PROJECT_ST_NO — NOT NULL
REPLY
- REPLY_NO — NUMBER — Primary key — NOT NULL — SEQ_RPL_NO;
- REPLY_CONTENT — VARCHAR2(4000) — NOT NULL
- REPLY_STATUS — VARCHAR2(1) — NOT NULL
- REPLY_WRI_DT — DATE — NOT NULL
- REPLY_MODI_DT — DATE — NOT NULL
- REPLY_REF_PNO — NUMBER — Foreign key → PROJECT_TB.PROJECT_NO — NOT NULL
- REPLY_WRITER — NUMBER — Foreign key → USER_TB.USER_NO — NOT NULL
- REPLY_CG_NO — NUMBER — Foreign key → REPLY_CG.REPLY_CG_NO — NOT NULL
REPLY_CG
- REPLY_CG_NO — NUMBER — Primary key — NOT NULL — CATEGORY_NO/댓글카테고리번호;
- PEPLY_CG_NM — VARCHAR2(100) — NOT NULL
REPORT_REPLY
- REPORT_RP_NO — NUMBER — Primary key — NOT NULL
- REPORT_RP_CONTENT — VARCHAR2(4000)
- REPORT_RP_DT — DATE — NOT NULL
- REPORT_RP_REF_RNO — NUMBER — Foreign key → REPORT_TB.REPORT_NO — NOT NULL
- REPORT_RP_WRITER — NUMBER — Foreign key → USER_TB.USER_NO — NOT NULL
REPORT_TB
- REPORT_NO — NUMBER — Primary key — NOT NULL — SEQ_REP_NO;
- REPORT_DATE — DATE — NOT NULL
- REPORT_CONTENT — VARCHAR2(4000) — NOT NULL
- REPORT_REF_PNO — NUMBER — Foreign key → PROJECT_TB.PROJECT_NO — NOT NULL
- REPORT_WRITER — NUMBER — Foreign key → USER_TB.USER_NO — NOT NULL
RESERVE
- RESERVE_NO — NUMBER — Primary key — NOT NULL — SEQ_RES_NO;
- BILLINGKEY — VARCHAR2(4000) — NOT NULL
- ADDITIONAL — NUMBER — NOT NULL
- RESERVE_DATE — DATE — NOT NULL
- RESERVE_NAME — VARCHAR2(100) — NOT NULL
- RESERVE_CONTRACT — NUMBER — NOT NULL
- RESERVE_ADDRESS — VARCHAR2(4000) — NOT NULL
- RESERVE_REQUEST — VARCHAR2(300)
- RESERVE_USER — NUMBER — Foreign key → USER_TB.USER_NO — NOT NULL
RESERVE_STATUS
- RESERVE_ST_NO — NUMBER — Primary key — NOT NULL
- RESERVE_ST_DETAIL — VARCHAR2(100) — NOT NULL
REVIEW
- REVIEW_NO — NUMBER — Primary key — NOT NULL — SEQ_PROJ_RV_NO;
- REVIEW_TITLE — VARCHAR2(300) — NOT NULL
- REVIEW_CONTENT — CLOB — NOT NULL
- REVIEW_ER_DT — DATE — NOT NULL
- REVIEW_MF_DT — DATE — NOT NULL
- REVIEW_STATUS — VARCHAR2(1) — NOT NULL
- REVIEW_REF_PNO — NUMBER — Foreign key → PROJECT_TB.PROJECT_NO — NOT NULL
- REVIEW_WRITER — NUMBER — Foreign key → USER_TB.USER_NO — NOT NULL
REWARD
- REWARD_NO — NUMBER — Primary key — NOT NULL — SEQ_RWD_NO;
- REWARD_PRICE — NUMBER — NOT NULL
- REWARD_NAME — VARCHAR2(200) — NOT NULL
- REWARD_EXPLAIN — VARCHAR2(4000) — NOT NULL
- REWARD_LIMIT — NUMBER — NOT NULL
- REWARD_SHIP_CDT — VARCHAR2(1) — NOT NULL
- REWARD_SHIP_DT — DATE — NOT NULL
- REWORD_OP_ADD — VARCHAR2(4000)
- REWORD_REF_PNO — NUMBER — Foreign key → PROJECT_TB.PROJECT_NO — NOT NULL
- REWORD_OP_NO — NUMBER — Foreign key → REWARD_OPTION.REWORD_OP_NO — NOT NULL
REWARD_OPTION
- REWORD_OP_NO — NUMBER — Primary key — NOT NULL — OPTION_NO/리워드
- REWORD_OP_DETAIL — VARCHAR2(1000) — NOT NULL
SUBREPLY
- SUBRE_NO — NUMBER — Primary key — NOT NULL — SEQ_SUBRPL_NO;
- SUBRE_CON — VARCHAR2(4000) — NOT NULL
- SUBRE_STATUS — VARCHAR2(1) — NOT NULL
- SUBRE_WRI_DT — DATE — NOT NULL
- SUBRE_MODI_DT — DATE — NOT NULL
- SUBRE_WRITER — NUMBER — Foreign key → USER_TB.USER_NO — NOT NULL
- SUBRE_REF_RNO — NUMBER — Foreign key → REPLY.REPLY_NO — NOT NULL
USER_TB
- USER_NO — NUMBER — NOT NULL — SEQ_USER_NO;
- USER_EMAIL — VARCHAR2(100) — NOT NULL
- USER_NICKNAME — VARCHAR2(100) — NOT NULL
- USER_PWD — VARCHAR2(100) — NOT NULL
- USER_EM_AUTH_YN — VARCHAR2(1) — NOT NULL
- USER_ADMIN_YN — VARCHAR2(1) — NOT NULL
- USER_STATUS — VARCHAR2(1) — NOT NULL
- USER_ER_DT — DATE — NOT NULL
- USER_LOGIN_DATE — DATE — NOT NULL
- USER_MF_DT — DATE — NOT NULL
- USER_ADDR — VARCHAR2(1000)
- USER_PHONE — VARCHAR2(100)
- USER_PF_IMG — VARCHAR2(1000)
- USER_SELF — VARCHAR2(1000)