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