kaco
Tables (5)
comments (Untitled4)
- id (Key) — BIGINT — Primary key — NOT NULL
- post_id (Key2) — BIGINT — Foreign key → posts.id — NOT NULL
- user_id (Key3) — BIGINT — Foreign key → users.id — NOT NULL
- content (Field3) — TEXT
- created_at (Field4) — DATETIME
- updated_at (Field5) — DATETIME
post_likes (Untitled5)
- id (Key) — BIGINT — Primary key — NOT NULL
- post_id (Key2) — BIGINT — Foreign key → posts.id — NOT NULL
- user_id (Key3) — BIGINT — Foreign key → users.id — NOT NULL
- created_at (Field3) — DATETIME
posts (Untitled3)
- id (Key) — BIGINT — Primary key — NOT NULL
- user_id (Key2) — BIGINT — Foreign key → users.id — NOT NULL
- title (Field2) — VARCHAR(200)
- content (Field3) — TEXT
- created_at (Field4) — DATETIME
- updated_at (Field5) — DATETIME
users (Untitled2)
- id (Key) — BIGINT — Primary key — NOT NULL
- email (Field) — VARCHAR(100)
- password (Field2) — VARCHAR(255)
- nickname (Field3) — VARCHAR(50)
- profile_image (Field4) — VARCHAR(255)
- created_at (Field5) — DATETIME
- updated_at (Field6) — DATETIME