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