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