210322

Tables (26)

BLAME

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

BLAME_REPLY

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

COMMUNITY_CATEGORY

  • ID — NUMBER — Primary key — NOT NULL
  • NAME — VARCHAR2(100) — NOT NULL — 값

CONFIRM_EMAIL

  • MEMBER_ID — NUMBER — Primary key — NOT NULL
  • DATE_EXPIRED — DATE — NOT NULL
  • SECURED_KEY — VARCHAR2(255) — NOT NULL

COUPON

  • ID — NUMBER — Primary key — 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 — Primary key — 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 — NOT NULL

FILE

  • ID — NUMBER — Primary key — NOT NULL
  • UPLOAD_NAME — VARCHAR2(256) — NOT NULL
  • SAVE_NAME — VARCHAR2(256) — NOT NULL
  • FILE_SIZE — NUMBER
  • FILE_TYPE — VARCHAR2(256)
  • DATE_CREATED — DATE — NOT NULL

FILE_MEMBER

  • FILE_ID — NUMBER — Foreign key → FILE.ID — NOT NULL
  • MEMBER_ID — NUMBER — 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 — Primary key — NOT NULL
  • FOLLOWER — NUMBER — Primary key — NOT NULL

MEMBER_COUPON

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

NOTICE

  • ID — NUMBER — Primary key — 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 — NOT NULL

NOTIFICATION

  • ID — NUMBER — Primary key — NOT NULL
  • MEMBER_ID — NUMBER — NOT NULL
  • DETAIL — VARCHAR2(1000) — NOT NULL
  • DATE_CREATED — DATE — NOT NULL
  • IS_READ — VARCHAR2(1) — NOT NULL

OAUTH

  • ID — NUMBER — Primary key — NOT NULL
  • MEMBER_ID — NUMBER — NOT NULL
  • ACCESS_TOKEN — VARCHAR2(255) — NOT NULL
  • PROVIDER — VARCHAR2(255) — NOT NULL

PROJECT

  • ID — NUMBER — Primary key — 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 — 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 — Primary key — NOT NULL
  • NAME — VARCHAR2(100) — NOT NULL

PROJECT_STATUS_CATEGORY

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

RESERVE

  • ID — NUMBER — Primary key — 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)
  • MEMBER_ID — NUMBER — 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 — Primary key — NOT NULL
  • DETAIL — VARCHAR2(100) — NOT NULL — 카테고리

REVIEW

  • ID — NUMBER — Primary key — 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 — NOT NULL

REWARD

  • ID — NUMBER — Primary key — NOT NULL
  • PRICE — NUMBER — NOT NULL
  • NAME — VARCHAR2(200) — NOT NULL
  • DETAIL — VARCHAR2(4000) — NOT NULL
  • MAX_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 — Primary key — NOT NULL
  • ROLE_CATEGORY_AUTHORITY — VARCHAR2(255) — NOT NULL

VISITOR_COUNT_PER_DAY

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

VISITOR_PER_DAY

  • DATE_VISITED — DATE — Primary key — NOT NULL
  • MEMBER_ID — NUMBER — Primary key — NOT NULL

VOTE

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