test
Tables (6)
Board (board)
- PK (board_id) — BIGINT — Primary key — NOT NULL
- title — VARCHAR
- content — VARCHAR
- createdAt (created_at) — DATETIME
- updatedAt (updated_at) — DATETIME
- deletedAt (deleted_at) — DATETIME
- FK (user_id) — BIGINT — Foreign key → User.PK — NOT NULL
Comment (comment)
- PK (comment_id) — BIGINT — Primary key — NOT NULL
- content — VARCHAR
- createdAt (created_at) — DATETIME
- updatedAt (updated_at) — DATETIME
- deletedAt (deleted_at) — DATETIME
- FK (board_id) — BIGINT — Foreign key → Board.PK — NOT NULL
- FK (user_id) — BIGINT — Foreign key → User.PK — NOT NULL
Question (question)
- PK (question_id) — BIGINT — Primary key — NOT NULL
- content — VARCHAR
- createdAt (created_at) — DATETIME
- FK (self_introduction_id) — BIGINT — Foreign key → SelfIntroduction.PK — NOT NULL
SelfIntroduction (self_introduction)
- PK (self_introduction_id) — BIGINT — Primary key — NOT NULL
- content — VARCHAR
- createdAt (creatd_at) — DATETIME
- FK (user_id) — BIGINT — Foreign key → User.PK — NOT NULL
- FK (user_id2) — BIGINT — Foreign key → User.PK — NOT NULL
User (user)
- PK (user_id) — BIGINT — Primary key — NOT NULL
- name — VARCHAR
- email — VARCHAR
- password — VARCHAR
- createdAt (created_at) — DATETIME
- updatedAt (updated_at) — DATETIME
- deletedAt (deleted_at) — DATETIME
Video (video)
- PK (video_id) — BIGINT — Primary key — NOT NULL
- title — VARCHAR
- link — VARCHAR
- createdAt (creatd_at) — DATETIME
- FK (uset_id) — BIGINT — Foreign key → User.PK — NOT NULL