KitPage V1
Tables (21)
Kit
- kit_uid — bigint — Primary key — NOT NULL
- device_id — varchar
- token — varchar
- content_id — varchar
- content_type — varchar
- modified_at — datetime
- created_at — datetime
- kihno_kit_uid — varchar
Kit_log
- kit_log_uid — bigint — Primary key — NOT NULL
- kit_uid — bigint
- device_id — varchar
- modified_at — datetime
- created_at — datetime
Member
- member_uid — bigint — Primary key — NOT NULL
- email — varchar
- password — varchar
- name — varchar
- role — varchar
- nickname — varchar
- profile_image_uid — bigint
- ip_address — varchar
- region — varchar
- model_name — varchar
- modified_at — datetime
- craeted_at (created_at) — datetime
Member_log
- member_log_uid — bigint — Primary key — NOT NULL
- member_uid — bigint
- ip_address — varchar
- region — varchar
- model_name — varchar
- modified_at — datetime
- created_at — datetime
comibook_log
- comicbook_log_uid — bigint — Primary key — NOT NULL
- kit_uid — bigint
- device_id — varchar
- comicbook_detail_uid — bigint
- modified_at — datetime
- created_at — datetime
comicbook
- comicbook_uid — bigint — Primary key — NOT NULL
- content_id — varchar
- title — varchar
- subtitle — varchar
- info_text — varcahr
- rate — double
- cover_image_uid — bigint
- writer — varchar
- illustrator — varchar
- company — varchar
- genre — varchar
- region — varchar
- modified_at — datetime
- created_at — datetime
comicbook_bookmark
- bookmark_uid — bigint — Primary key — NOT NULL
- content_id — varchar
- detail_uid — bigint
- device_id — varchar
- kit_uid — bigint
- status — varchar
- modified_at — datetime
- created_at — datetime
comicbook_detail
- comicbook_detail_uid — bigint — Primary key — NOT NULL
- comicbook_uid — bigint
- content_id — varchar
- title — varchar
- chaptor — varchar
- page — int
- rate — double
- image_uid — bigint
- region — varchar
- modified_at — datetime
- created_at — datetime
comment
- comment_uid — bigint — Primary key — NOT NULL
- member_uid — bigint
- post_uid — bigint
- parent_comment_uid — bigint
- content — varchar
- nickname — varchar
- modified_at — datetime
- created_at — datetime
ebook
- ebook_uid — bigint — Primary key — NOT NULL
- content_id — varchar
- title — varchar
- subtitle — varchar
- into_text (info_text) — varchar
- rate — double
- cover_image_uid — bigint
- author — varchar
- company — varchar
- genre — varchar
- region — varchar
- modified_at — datetime
- created_at — datetime
ebook_detail
- ebook_detail_uid — bigint — Primary key — NOT NULL
- ebook_uid — bigint
- content_id — varchar
- title — varchar
- chaptor — varchar
- page — int
- content — longtext
- region — varchar
- modified_at — datetime
- created_at — datetime
ebook_log
- ebook_log_uid — bigint — Primary key — NOT NULL
- kit_uid — bigint
- device_id — varchar
- ebook_detail_uid — bigint
- row — int
- modified_at — datetime
- created_at — datetime
image
- image_uid — bigint — Primary key — NOT NULL
- image_path — varchar
- image_size — varchar
- width — varchar
- height — varchar
- image_code — varchar
- modified_at — datetime
- created_at — datetime
movie
- movie_uid — bigint — Primary key — NOT NULL
- content_id — varchar
- artist — artist
- title — varchar
- stream_url — varchar
- cover_image_uid — bigint
- movie_code — varchar
- modified_at — datetime
- created_at — datetime
music
- music_uid — bigint — Primary key — NOT NULL
- content_id — varchar
- album — varchar
- artist — varchar
- title — varchar
- file_path — varchar
- play_time — varchar
- modified_at — datetime
- created_at — datetime
photobook
- photobook_uid — bigint — Primary key — NOT NULL
- content_id — varchar
- title — varchar
- subtitle — varchar
- info_text — varchar
- rate — double
- cover_image_uid — bigint
- artist — varchar
- photographer — varchar
- company — varchar
- genre — varchar
- region — varchar
- modified_at — datetime
- created_at — datetime
photobook_detail
- photobook_detail_uid — bigint — Primary key — NOT NULL
- photobook_uid — bigint
- content_id — varchar
- title — varchar
- chaptor — varchar
- page — int
- cover_image_uid (image_uid) — bigint
- Field (region) — varchar
- modified_at — datetime
- created_at — datetime
photobook_log
- photobook_log_uid — bigint — Primary key — NOT NULL
- kit_uid — bigint
- device_id — varchar
- photobook_detail_uid — bigint
- modified_at — datetime
- created_at — datetime
post
- post_uid — bigint — Primary key — NOT NULL
- member_uid — bigint
- title — varchar
- content — varchar
- nickname — varchar
- modified_at — datetime
- created_at — datetime
push
- push_uid — bigint — Primary key — NOT NULL
- kit_uid — bigint
- content_id — varchar
- device_id — varchar
- token — varchar
- modified_at — datetime
- created_at — datetime
push_log
- push_log_uid — bigint — Primary key — NOT NULL
- device_id — varchar
- kit_uid — bigint
- push_type — varchar
- modified_at — datetime
- created_at — datetime