미정

테이블 (28)

Untitled (message_pic)

  • Key (message_pic_id) — bigint — 기본 키 — NOT NULL
  • Key (message_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
  • Field (pic) — varcher(200) — NOT NULL

Untitled (state)

  • Key (state_id) — bigint — 기본 키 — NOT NULL
  • Field (state_name) — varcher(30) — NOT NULL — 일반, 성인, 프리미엄, 독점, 특정이벤트 대상

Untitled (novel_state)

  • Key (novel_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
  • Key (state_id) — bigint — 외래 키 → Untitled.Key — NOT NULL

Untitled (novel_tag)

  • Key (novel_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
  • Key (tag_id) — bigint — 외래 키 → Untitled.Key — NOT NULL

Untitled (tag)

  • Key (tag_id) — bigint — 기본 키 — NOT NULL
  • Field (tag_name) — varcher(20) — NOT NULL — 무협, 판타지

Untitled (emojis_detail)

  • Key (emojis_detail_id) — bigint — 기본 키 — NOT NULL
  • Key (emojis_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
  • Field (pic) — varchar(200) — NOT NULL
  • Field (name) — varcher(30) — NOT NULL

Untitled (user_emojis)

  • (user_id) — bigint — 외래 키 → user.user_id — NOT NULL
  • Key (emojis_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
  • Field (created_at) — datetime — NOT NULL

Untitled (emojis)

  • Key (emojis_id) — bigint — 기본 키 — NOT NULL
  • Key (novel_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
  • Field (name) — varcher(30) — NOT NULL
  • Field (coin) — int — NOT NULL — 이모티콘 가격
  • Field (type) — varcher(5) — NOT NULL
  • Field (created_at) — datetime — NOT NULL
  • Field (updated_at) — datetime — NOT NULL

Untitled (user_buy)

  • Key (user_buy_id) — bigint — 기본 키 — NOT NULL
  • Key (buy_coin_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
  • (user_id) — bigint — 외래 키 → user.user_id — NOT NULL
  • Field (tid) — varcher(100) — NOT NULL
  • Field (created_at) — datetime — NOT NULL
  • Field (paid_at) — datetime — NOT NULL

Untitled (buy_coin)

  • Key (buy_coin_id) — bigint — 기본 키 — NOT NULL
  • Field (coin_num) — int — NOT NULL — 코인 개수
  • Field (price) — int — NOT NULL

Untitled (novel_donation)

  • Key (donation_id) — bigint — 기본 키 — NOT NULL
  • (user_id) — bigint — 외래 키 → user.user_id — NOT NULL
  • Key (novel_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
  • Field (coin) — int — NOT NULL
  • Field (created_at) — datetime — NOT NULL

Untitled (notice_pic)

  • Key (notice_pic_id) — bigint — 기본 키 — NOT NULL
  • Key (notice_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
  • Field (pic) — varcher(200) — NOT NULL

Untitled (notice)

  • Key (notice_id) — bigint — 기본 키 — NOT NULL
  • Key (novel_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
  • Field (created_at) — datetime — NOT NULL
  • Field (updated_at) — datetime — NOT NULL
  • Field (title) — varcher(30) — NOT NULL
  • Field (contents) — varcher(3000) — NOT NULL

Untitled (message)

  • Key (message_id) — bigint — 기본 키 — NOT NULL
  • (user_id) — bigint — 외래 키 → user.user_id — NOT NULL
  • Key (admin_id) — bigint — 외래 키 → Untitled2.Key — NOT NULL
  • Field (title) — varchar(100) — NOT NULL
  • Field (contents) — varchar(3000) — NOT NULL
  • Field (target_id) — bigint
  • Field (target_name) — varchar(5)
  • Field (type) — varchar(5) — NOT NULL
  • Field (created_at) — datetime — NOT NULL

Untitled (novel_manager)

  • Key (novel_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
  • Key (admin_id) — bigint — 외래 키 → Untitled2.Key — NOT NULL

Untitled (event)

  • Key (event_id) — bigint — 기본 키 — NOT NULL
  • Key (admin_id) — bigint — 외래 키 → Untitled2.Key — NOT NULL
  • Field (contents) — text — NOT NULL
  • Field (title) — varchar(100) — NOT NULL
  • Field (discount) — int — NOT NULL — 할인이 아닌 이벤트도 있음
  • Field (type) — varchar(5) — NOT NULL
  • Field (created_at) — datetime — NOT NULL
  • Field (updated_at) — datetime — NOT NULL

Untitled (chapter_ps)

  • Key (chapter_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
  • Field (contents) — varcher(1000) — NOT NULL
  • Field (pic) — varcher(100) — NOT NULL

Untitled (chapter_pic)

  • Key (chapter_pic_id) — bigint — 기본 키 — NOT NULL
  • Key (chapter_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
  • Field (pic) — varcher(100) — NOT NULL

Untitled (chapter_comment)

  • Key (chapter_comment_id) — bigint — 기본 키 — NOT NULL
  • Key (read_id) — bigint — 외래 키 → Untitled2.Key — NOT NULL
  • Field (comment) — varchar(1000)
  • Field (pic) — varchar(100)
  • Field (state) — int — NOT NULL
  • Field (created_at) — datetime — NOT NULL

Untitled (user_novel_like)

  • (user_id) — bigint — 외래 키 → user.user_id — NOT NULL
  • Key (novel_id) — bigint — 외래 키 → Untitled.Key — NOT NULL

Untitled (user_chapter_like)

  • (user_id) — bigint — 외래 키 → user.user_id — NOT NULL
  • Key (chapter_id) — bigint — 외래 키 → Untitled.Key — NOT NULL

Untitled (common_code)

  • Key (code_id) — bigint — 기본 키 — NOT NULL
  • Field (code_name) — varcher(30) — NOT NULL
  • Field (table_code) — varcher(3) — NOT NULL
  • Field (type_code) — varcher(5) — NOT NULL
  • Field (created_at) — datetime — NOT NULL
  • Field (updated_at) — datetime — NOT NULL

Untitled (novel_chapter)

  • Key (chapter_id) — bigint — 기본 키 — NOT NULL
  • Key (episode_Id) — bigint — 외래 키 → Untitled.Key — NOT NULL
  • Field (count) — int — NOT NULL
  • Field (contents) — text — NOT NULL
  • Field (state) — int — NOT NULL
  • Field (upload_at) — datetime — NOT NULL — 게시 시간(기입 안하면 디폴트로 created_at)
  • Field (created_at) — datetime — NOT NULL
  • Field (updated_at) — datetime — NOT NULL

Untitled (novel_episode)

  • Key (episode_Id) — bigint — 기본 키 — NOT NULL
  • Key (novel_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
  • Field (episode_name) — varchar(30) — NOT NULL

Untitled (novel)

  • Key (novel_id) — bigint — 기본 키 — NOT NULL
  • (user_id) — bigint — 외래 키 → user.user_id
  • Field (title) — varcher(100) — NOT NULL
  • Field (contents) — varcher(3000)
  • Field (count) — bigint — NOT NULL
  • Field (pic) — varcher(200) — NOT NULL
  • Field (type) — varcher(5) — NOT NULL
  • Field (created_at) — datetime — NOT NULL
  • Field (updated_at) — datetime — NOT NULL

Untitled2 (user_chapter_read)

  • Key (read_id) — bigint — 기본 키 — NOT NULL
  • (user_id) — bigint — 외래 키 → user.user_id — NOT NULL
  • Key (chapter_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
  • Field (count) — int — NOT NULL — 필요 없는 컬럼인듯?
  • Field (novel_id) — bigint — NOT NULL
  • Field (created_at) — datetime — NOT NULL
  • Field (updated_at) — datetime — NOT NULL

Untitled2 (admin)

  • Key (admin_id) — bigint — 기본 키 — NOT NULL
  • Field (a_id) — varcher(30) — NOT NULL — 유니크
  • Field (q_pw) — varcher(200) — NOT NULL
  • Field (name) — varcher(30) — NOT NULL
  • Field (phone) — varcher(11) — NOT NULL

user

  • (user_id) — bigint — 기본 키 — NOT NULL
  • Field (name) — varchar(30) — NOT NULL — 이름
  • Field (nick_name) — varchar(20) — 닉네임 최대 10자
  • Field (email) — varchar(30) — NOT NULL — 유니크
  • Field2 (pw) — varchar(200) — NOT NULL
  • Field (pic) — varcher(200) — NOT NULL
  • Field (coin) — int — NOT NULL — 결제/후원용 재화
  • Field (type) — varchar(5) — NOT NULL
  • Field (created_at) — datetime — NOT NULL
  • Field2 (updated_at) — datetime — NOT NULL
  • Field (birthday) — date — NOT NULL