KTB-Community
Tables (4)
comment (Untitled4)
- id (Key) — BIGINT — Primary key — NOT NULL
- user_id (Key3) — BIGINT — Foreign key → user.id — NOT NULL
- post_id (Key2) — BIGINT — Foreign key → post.id — NOT NULL
- content (Field2) — TEXT — NOT NULL
- deleted (Field3) — TINYINT(1) — NOT NULL
- created_at (Field) — TIMESTAMP — NOT NULL
like (Untitled2)
- id (Key) — BIGINT — Primary key — NOT NULL
- user_id (Key3) — BIGINT — Foreign key → user.id — NOT NULL
- post_id (Key2) — BIGINT — Foreign key → post.id — NOT NULL
post (Untitled)
- id (Key) — BIGINT — Primary key — NOT NULL
- title (Field) — VARCHAR(100) — NOT NULL
- content (Field2) — LONGTEXT — NOT NULL
- attachement_image_url (Field3) — TEXT
- deleted (Field5) — TINYINT(1) — NOT NULL
- lookup_count (Field6) — INT — NOT NULL
- created_at (Field4) — TIMESTAMP — NOT NULL
user
- id (Key) — BIGINT — Primary key — NOT NULL
- email (VARCHAR(255)) — VARCHAR(255) — NOT NULL
- password (Field2) — VARCHAR(255) — NOT NULL
- nickname (Field) — VARCHAR(100) — NOT NULL
- profile_image_url (Field3) — TEXT — NOT NULL
- deleted (Field4) — TINYINT(1) — NOT NULL