prototype_db

Tables (29)

AUTO_LOGIN

  • MEMBER_ID — NUMBER — Foreign key → MEMBER.ID — NOT NULL
  • SESSIONKEY — VARCHAR2(500)
  • DATE_EXPIRED — DATE

BLAME

  • ID — NUMBER — NOT NULL
  • DATE_CREATED — DATE — NOT NULL
  • CONTENT — VARCHAR2(4000) — NOT NULL
  • PROJECT_ID — NUMBER — Foreign key → PROJECT.ID — NOT NULL
  • MEMBER_ID — NUMBER — Foreign key → MEMBER.ID — NOT NULL

BLAME_REPLY

  • ID — NUMBER — NOT NULL
  • CONTENT — VARCHAR2(4000)
  • DATE_CREATED — DATE — NOT NULL
  • BLAME_ID — NUMBER — Foreign key → BLAME.ID — NOT NULL
  • MEMBER_ID — NUMBER — Foreign key → MEMBER.ID — NOT NULL

COMMUNITY

  • ID — NUMBER — NOT NULL
  • CONTENT — VARCHAR2(4000) — NOT NULL
  • IS_DELETED — VARCHAR2(1) — NOT NULL
  • DATE_CREATED — DATE — NOT NULL
  • DATE_UPDATED — DATE — NOT NULL
  • PROJECT_ID — NUMBER — Foreign key → PROJECT.ID — NOT NULL
  • MEMBER_ID — NUMBER — Foreign key → MEMBER.ID — NOT NULL
  • COMMUNITY_CATEGORY_ID — NUMBER — Foreign key → COMMUNITY_CATEGORY.ID — NOT NULL
  • PARENT_COMMUNITY_ID — NUMBER — Foreign key → COMMUNITY.ID

COMMUNITY_CATEGORY

  • ID — NUMBER — NOT NULL
  • NAME — VARCHAR2(100) — NOT NULL

CONFIRM_EMAIL

  • MEMBER_ID — NUMBER — Foreign key → MEMBER.ID — NOT NULL
  • DATE_EXPIRED — DATE — NOT NULL
  • SECURED_KEY — VARCHAR2(255) — NOT NULL

COUPON

  • ID — NUMBER — NOT NULL
  • PROJECT_CATEGORY_ID — NUMBER — NOT NULL
  • DISCOUNT_RATE — NUMBER — NOT NULL
  • DATE_CREATED — DATE — NOT NULL
  • DATE_UPDATED — DATE — NOT NULL
  • DATE_EXPIRED — DATE — NOT NULL

FAQ

  • ID — NUMBER — NOT NULL
  • TITLE — VARCHAR2(300) — NOT NULL
  • CONTENT — CLOB — NOT NULL
  • DATE_CREATED — DATE — NOT NULL
  • DATE_UPDATED — DATE — NOT NULL
  • IS_DELETED — VARCHAR2(1) — NOT NULL
  • MEMBER_ID — NUMBER — Foreign key → MEMBER.ID — NOT NULL

FILE

  • ID — NUMBER — NOT NULL
  • UPLOAD_NAME — VARCHAR2(256) — NOT NULL
  • SAVE_NAME — VARCHAR2(256) — NOT NULL
  • FILE_SIZE — NUMBER
  • FILE_TYPE — VARCHAR2(256)
  • MEMBER_ID — NUMBER — Foreign key → MEMBER.ID — NOT NULL
  • DATE_CREATED — DATE — NOT NULL

FILE_PROJECT

  • FILE_ID — NUMBER — Foreign key → FILE.ID — NOT NULL
  • PROJECT_ID — NUMBER — Foreign key → PROJECT.ID — NOT NULL

FOLLOW

  • FOLLOW — NUMBER — Foreign key → MEMBER.ID — NOT NULL
  • FOLLOWER — NUMBER — Foreign key → MEMBER.ID — NOT NULL

MEMBER

  • ID — NUMBER — NOT NULL
  • EMAIL — VARCHAR2(100) — NOT NULL
  • NICKNAME — VARCHAR2(100) — NOT NULL
  • PWD — VARCHAR2(100) — NOT NULL
  • IS_EMAIL_VERIFIED — VARCHAR2(1) — NOT NULL
  • IS_DELETED — VARCHAR2(1) — NOT NULL
  • DATE_LOGGEDIN — DATE — NOT NULL
  • DATE_CREATED — DATE — NOT NULL
  • DATE_UPDATED — DATE — NOT NULL
  • ADDRESS — VARCHAR2(1000)
  • PHONE — VARCHAR2(100)
  • PROFILE_IMG — NUMBER — Foreign key → FILE.ID
  • PROFILE_DETAIL — VARCHAR2(1000)

MEMBER_COUPON

  • MEMBER_ID — NUMBER — Foreign key → MEMBER.ID — NOT NULL
  • COUPON_ID — NUMBER — Foreign key → COUPON.ID — NOT NULL
  • USED — VARCHAR2(1) — NOT NULL

MEMBER_ROLE_CATEGORY

  • MEMBER_ID — NUMBER — Foreign key → MEMBER.ID — NOT NULL
  • ROLE_CATEGORY_ID — NUMBER — Foreign key → ROLE_CATEGORY.ID — NOT NULL

NOTICE

  • ID — NUMBER — NOT NULL
  • TITLE — VARCHAR2(300) — NOT NULL
  • CONTENT — CLOB — NOT NULL
  • DATE_CREATED — DATE — NOT NULL
  • DATE_UPDATED — DATE — NOT NULL
  • IS_DELETED — VARCHAR2(1) — NOT NULL
  • MEMBER_ID — NUMBER — Foreign key → MEMBER.ID — NOT NULL

NOTIFICATION

  • ID — NUMBER — NOT NULL
  • MEMBER_ID — NUMBER — Foreign key → MEMBER.ID — NOT NULL
  • CONTENT — VARCHAR2(1000) — NOT NULL
  • DATE_CREATED — DATE — NOT NULL
  • IS_READ — VARCHAR2(1) — NOT NULL

OAUTH

  • ID — NUMBER — NOT NULL
  • MEMBER_ID — NUMBER — Foreign key → MEMBER.ID — NOT NULL
  • ACCESS_TOKEN — VARCHAR2(255) — NOT NULL
  • PROVIDER — VARCHAR2(255) — NOT NULL

PROJECT

  • ID — NUMBER — NOT NULL
  • TITLE — VARCHAR2(100) — NOT NULL
  • SUB_TITLE — VARCHAR2(200) — NOT NULL
  • TARGET_AMOUNT — NUMBER — NOT NULL
  • DATE_PROJECT_STARTED — DATE — NOT NULL
  • DATE_PROJECT_CLOSED — DATE — NOT NULL
  • HASHTAG — VARCHAR2(4000)
  • THUMB_IMG — VARCHAR2(400) — NOT NULL
  • MAIN_IMG — VARCHAR2(400) — NOT NULL
  • SUMMARY — VARCHAR2(400) — NOT NULL
  • STORY — CLOB — NOT NULL
  • WRITER_NAME — VARCHAR2(100) — NOT NULL
  • WRITER_PROFILE_IMG — VARCHAR2(400) — NOT NULL
  • WRITER_SNS_INSTAGRAM — VARCHAR2(100)
  • WRITER_SNS_FACEBOOK — VARCHAR2(100)
  • WRITER_PHONE — VARCHAR2(100)
  • WRITER_EMAIL — VARCHAR2(100)
  • DATE_CREATED — DATE — NOT NULL
  • DATE_UPDATED — DATE — NOT NULL
  • MEMBER_ID — NUMBER — Foreign key → MEMBER.ID — NOT NULL
  • PROJECT_CATEGORY_ID — NUMBER — Foreign key → PROJECT_CATEGORY.ID — NOT NULL
  • PROJECT_STATUS_CATEGORY_ID — NUMBER — Foreign key → PROJECT_STATUS_CATEGORY.ID — NOT NULL

PROJECT_CATEGORY

  • ID — NUMBER — NOT NULL
  • NAME — VARCHAR2(100) — NOT NULL

PROJECT_STATUS_CATEGORY

  • ID — NUMBER — NOT NULL
  • DETAIL — VARCHAR2(100) — NOT NULL

RESERVE

  • ID — NUMBER — NOT NULL
  • BILLINGKEY — VARCHAR2(4000) — NOT NULL
  • ADDITIONAL_BILLINGS — NUMBER — NOT NULL
  • DATE_CREATED — DATE — NOT NULL
  • RECEIVER_NAME — VARCHAR2(100) — NOT NULL
  • RECEIVER_PHONE — NUMBER — NOT NULL
  • RECEIVER_ADDRESS — VARCHAR2(4000) — NOT NULL
  • REQUEST_FOR_DELIVERY — VARCHAR2(300)
  • RESERVE_STATUS_CATEGORY_ID — NUMBER — Foreign key → RESERVE_STATUS_CATEGORY.ID — NOT NULL
  • MEMBER_ID — NUMBER — Foreign key → MEMBER.ID — NOT NULL

RESERVE_REWARD

  • RESERVE_ID — NUMBER — Foreign key → RESERVE.ID — NOT NULL
  • REWARD_ID — NUMBER — Foreign key → REWARD.ID — NOT NULL
  • REWARD_SUM — NUMBER — NOT NULL

RESERVE_STATUS_CATEGORY

  • ID — NUMBER — NOT NULL
  • DETAIL — VARCHAR2(100) — NOT NULL

REVIEW

  • ID — NUMBER — NOT NULL
  • TITLE — VARCHAR2(300) — NOT NULL
  • CONTENT — CLOB — NOT NULL
  • DATE_CREATED — DATE — NOT NULL
  • DATE_UPDATED — DATE — NOT NULL
  • IS_DELETED — VARCHAR2(1) — NOT NULL
  • PROJECT_ID — NUMBER — Foreign key → PROJECT.ID — NOT NULL
  • MEMBER_ID — NUMBER — Foreign key → MEMBER.ID — NOT NULL

REWARD

  • ID — NUMBER — NOT NULL
  • PRICE — NUMBER — NOT NULL
  • NAME — VARCHAR2(200) — NOT NULL
  • DETAIL — VARCHAR2(4000) — NOT NULL
  • MAX_STOCK — NUMBER — NOT NULL
  • CURRENT_STOCK — NUMBER — NOT NULL
  • IS_ADDRESS_REQUIRED — VARCHAR2(1) — NOT NULL
  • DATE_DELIVERY_ESTIMATED — DATE — NOT NULL
  • PROJECT_ID — NUMBER — Foreign key → PROJECT.ID — NOT NULL
  • OPTION_FORM — VARCHAR2(1000)

ROLE_CATEGORY

  • ID — NUMBER — NOT NULL
  • NAME — VARCHAR2(100) — NOT NULL — 권한

VISITOR_COUNT_PER_DAY

  • DATE_VISITED — DATE — NOT NULL
  • COUNT — NUMBER — NOT NULL

VISITOR_PER_DAY

  • DATE_VISITED — DATE — Primary key — NOT NULL
  • MEMBER_ID — NUMBER — Foreign key → MEMBER.ID — NOT NULL

VOTE

  • MEMBER_ID — NUMBER — Foreign key → MEMBER.ID — NOT NULL
  • PROJECT_ID — NUMBER — Foreign key → PROJECT.ID — NOT NULL