artizen
Tables (12)
RecommandContents (Untitled7)
- id — NOTNULL — Primary key — NOT NULL
contents (Untitled2)
- content_id (contentId) — NOTNULL — Primary key — NOT NULL
- content_sum (contentSum) — NULL
- content_name (contentName) — NOTNULL
- target — NULL
- category — NOTNULL
- start_day (startDay) — NOTNULL
- end_day (endDay) — NOTNULL
- likes — NULL
- is_accepted (isAccepted) — NOTNULL
- writer_id (writerId) — NOTNULL — Foreign key → writer.writer_id — NOT NULL — 시퀀스로 자동 증가 되는 값이어야 하나...?
funding_contents (Untitled5)
- funding_id (fundingId) — NOTNULL — Primary key — NOT NULL
- detail — NULL
- transaction — NULL
- production_cost (productionCost) — NULL
- purpose — NULL
- min_invest (minInvest) — NULL
- content_id (contentId) — NOTNULL — Foreign key → contents.content_id — NOT NULL
gift (Untitled9)
- gift_id (giftId) — NOTNULL — Primary key — NOT NULL
- criterion — NOTNULL
- gift_list (giftList) — NOTNULL
- ticket_cnt (ticketCnt) — NOTNULL
- content_id (contentId) — NOTNULL — Foreign key → contents.content_id — NOT NULL
image (Untitled11)
- image_id (imageId) — NOT NULL — Primary key — NOT NULL
- content_id (contentId) — NOTNULL — Foreign key → contents.content_id — NOT NULL
- image_url (imageUrl)
- image_name (imageName)
reviews (Untitled6)
- review_id (reviewId) — NOTNULL — Primary key — NOT NULL
- review — NOTNULL
- score — NOTNULL
- user_id (userId) — NOTNULL — Foreign key → users.user_id — NOT NULL — 시퀀스로 자동 증가 되는 값이어야 하나...?
- content_id (contentId) — NOTNULL — Foreign key → contents.content_id — NOT NULL
support (Untitled4)
- support_id (supportId) — NOT NULL — Primary key — NOT NULL — 후원 콘텐츠랑 pk명이 겹쳐서 supp_id로 지정
- price — NOTNULL
- user_id (userId) — NOTNULL — Foreign key → users.user_id — NOT NULL — 시퀀스로 자동 증가 되는 값이어야 하나...?
- content_id (contentId) — NOTNULL — Foreign key → contents.content_id — NOT NULL
support_contents (Untitled8)
- sc_id (scId) — NOTNULL — Primary key — NOT NULL
- detail — NULL
- team_detail (teamDetail) — NULL
- plan_detail (planDetail) — NULL
- content_id (contentId) — NOTNULL — Foreign key → contents.content_id — NOT NULL
ticket (Untitled3)
- ticket_id (ticketId) — NOT NULL — Primary key — NOT NULL
- user_id (userId) — NOTNULL — Foreign key → users.user_id — NOT NULL — 시퀀스로 자동 증가 되는 값이어야 하나...?
- content_id (contentId) — NOTNULL — Foreign key → contents.content_id — NOT NULL
user_info (Untitled10)
- info_id (infoId) — NOTNULL — Primary key — NOT NULL
- name — NOTNULL
- password — NOTNULL
- email — NOTNULL
- accounts — NULL
- bank — NULL
- balance — NULL
- nickname — NULL
users (CopyOfUntitled)
- user_id (userId) — NOTNULL — Primary key — NOT NULL — 시퀀스로 자동 증가 되는 값이어야 하나...?
- identity — NOTNULL
- character — NULL
- interests
- info_id (infoId) — NOTNULL — Foreign key → user_info.info_id — NOT NULL
writer (Untitled)
- writer_id (writerId) — NOTNULL — Primary key — NOT NULL — 시퀀스로 자동 증가 되는 값이어야 하나...?
- info_id (infoId) — NOTNULL — Foreign key → user_info.info_id — NOT NULL