munglog

Tables (14)

comments

  • id — bigint — Primary key — NOT NULL
  • content — text — NOT NULL
  • registration_date — datetime — NOT NULL
  • correction_date — datetime — NOT NULL
  • post_id — bigint — Foreign key → posts.id — NOT NULL
  • user_id — bigint — Foreign key → users.user_id — NOT NULL

content_images

  • id — bigint — Primary key — NOT NULL
  • post_id — bigint — Foreign key → posts.id — NOT NULL
  • originname (fim_originname) — varchar(255) — NOT NULL
  • filename — varchar(255) — NOT NULL
  • filesize — bigint — NOT NULL
  • height — bigint — NOT NULL
  • width — bigint — NOT NULL
  • upload_time — datetime — NOT NULL

follows

  • id — bigint — Primary key — NOT NULL
  • follower_id — bigint — Foreign key → users.user_id — NOT NULL
  • following_id — bigint — Foreign key → users.user_id — NOT NULL
  • date_created — datetime — NOT NULL

like_posts

  • user_id — bigint — Foreign key → users.user_id — NOT NULL
  • post_id — bigint — Foreign key → posts.id — NOT NULL

likes

  • user_id — bigint — Foreign key → users.user_id — NOT NULL
  • posts_id (post_id) — bigint — Foreign key → posts.id — NOT NULL

posts

  • id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → users.user_id — NOT NULL
  • title — varchar(50) — NOT NULL
  • content — text — NOT NULL
  • created_date — datetime — NOT NULL
  • registration_date — datetime — NOT NULL
  • correction_date — datetime — NOT NULL
  • veiw_count (view_count) — bigint — NOT NULL
  • publish_status — boolean — NOT NULL
  • access_status — boolean — NOT NULL
  • thumbnail — bigint — Foreign key → thumbnails.id
  • serise — bigint — Foreign key → serises.id — NOT NULL

profile_images

  • id — bigint — Primary key — NOT NULL
  • originname (fim_originname) — varchar(255) — NOT NULL
  • filename — varchar(255) — NOT NULL
  • filesize — bigint — NOT NULL
  • height — bigint — NOT NULL
  • width — bigint — NOT NULL
  • upload_time — datetime — NOT NULL

recent_posts

  • user_id — bigint — Foreign key → users.user_id — NOT NULL
  • post_id — bigint — Foreign key → posts.id — NOT NULL
  • reading_date — datetime — NOT NULL

roles

  • role_id — bigint — Primary key — NOT NULL
  • name — VARCHAR(10) — NOT NULL

serises

  • id — bigint — Primary key — NOT NULL
  • name — varchar(10) — NOT NULL
  • user_id — bigint — Foreign key → users.user_id — NOT NULL

tags

  • id — bigint — Primary key — NOT NULL
  • name — varchar(10) — NOT NULL
  • post_id — bigint — Foreign key → posts.id — NOT NULL

thumbnails

  • id — bigint — Primary key — NOT NULL
  • originname (fim_originname) — varchar(255) — NOT NULL
  • filename — varchar(255) — NOT NULL
  • filesize — bigint — NOT NULL
  • height — bigint — NOT NULL
  • width — bigint — NOT NULL
  • upload_time — datetime — NOT NULL

user_roles

  • user_role_id — bigint — Primary key — NOT NULL
  • role_id — bigint — Foreign key → roles.role_id — NOT NULL
  • user_id — bigint — Foreign key → users.user_id — NOT NULL

users

  • user_id (id) — bigint — Primary key — NOT NULL
  • name — varchar(10) — NOT NULL
  • email — varchar(254) — NOT NULL
  • password — varchar(50) — NOT NULL
  • username — varchar(50) — NOT NULL
  • introduction — varchar(255)
  • is_email_subscribed — boolean — NOT NULL
  • blog_title — varchar(50) — NOT NULL
  • registration_date — datetime — NOT NULL
  • profile_image — bigint — Foreign key → profile_images.id