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