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