미정
테이블 (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