prototye_db_2
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 (Key) — 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)
- 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 — NOT NULL
- REWARD_ID — NUMBER — Foreign key → REWARD.ID — NOT NULL
- Key — Foreign key → RESERVE.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