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)