likelion_page
Tables (3)
comment
- id (Key) — INTEGER — Primary key — NOT NULL
- id (Key2) — INTEGER — Foreign key → post.id — NOT NULL
- id (Key22) — INTEGER — Foreign key → post.id — NOT NULL
- content (Field) — TEXT
- created_at (Field2) — TIMESTAMP
- updated_at (Field3) — TIMESTAMP
- like_count (Field4) — INTEGER
- dislike_count (Field5) — INTEGER
- parent_comment_id (Field6) — INTEGER
- depth (Field7) — INTEGER
post
- id (Key) — INTEGER — Primary key — NOT NULL
- id (Key2) — INTEGER — Foreign key → user.id — NOT NULL
- title (Field3) — VARCHAR
- content (Field) — TEXT
- created_at (Field2) — TIMESTAMP
- updated_at (Field4) — TIMESTAMP
- view_count (Field5) — INTEGER
- like_count (Field6) — INTEGER
- comment_count (Field7) — INTEGER
user
- id (Key) — INTEGER — Primary key — NOT NULL
- username (Field) — VARCHAR
- email (Field2) — VARCHAR
- password (Field3) — VARCHAR
- created_at (Field4) — TIMESTAMP
- updated_at (Field5) — TIMESTAMP
- profile_picture (Field6) — VARCHAR
- last_login (Field7) — TIMESTAMP