letsgo-mini
Tables (8)
category
- id — NOT NULL — Primary key — NOT NULL
- name — NOT NULL
- created_at — NOT NULL
- updated_at — NOT NULL
comment
- id — NOT NULL — Primary key — NOT NULL
- parent_comemnt_id — NULL — Foreign key → comment.id — NOT NULL
- user_id — NOT NULL — Foreign key → user.id — NOT NULL
- post_id — NOT NULL — Foreign key → post.id — NOT NULL
- content — NOT NULL
- created_at — NOT NULL
- updated_at — NOT NULL
image
- id — NOT NULL — Primary key — NOT NULL
- url_type_id — NOT NULL — Foreign key → url_type.id — NOT NULL
- description — NOT NULL
- filename — NOT NULL
- new_filename — NOT NULL
- size — NOT NULL
- instance — NOT NULL
- created_at — NOT NULL
- updated_at — NOT NULL
like_comment
- id — NOT NULL — Primary key — NOT NULL
- user_id — NOT NULL — Foreign key → user.id — NOT NULL
- comment_id — NOT NULL — Foreign key → comment.id — NOT NULL
like_post
- id — NOT NULL — Primary key — NOT NULL
- post_id — NOT NULL — Foreign key → post.id — NOT NULL
- user_id — NOT NULL — Foreign key → user.id — NOT NULL
post
- id — NOT NULL — Primary key — NOT NULL
- title — NOT NULL
- viewed — NOT NULL
- picture — NOT NULL
- content — NOT NULL
- created_at — NOT NULL
- udpated_at (updated_at) — NOT NULL
- category_id — NOT NULL — Foreign key → category.id — NOT NULL
- user_id — NOT NULL — Foreign key → user.id — NOT NULL
url_type
- id — NOT NULL — Primary key — NOT NULL
- url — NOT NULL
- created_at — NOT NULL
- updated_at — NOT NULL
user
- id — NOT NULL — Primary key — NOT NULL
- profile_picture_url — NOT NULL
- name — NOT NULL
- password — NOT NULL
- created_at — NOT NULL
- updated_at — NOT NULL