newsFeed-project
Tables (4)
board
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → user.id — NOT NULL
- title — VARCHAR(100) — NOT NULL
- contents — VARCHAR(500) — NOT NULL
- image — LONGBLOB
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
- deleted_at — DATETIME(6)
comment
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → user.id — NOT NULL
- board_id — BIGINT — Foreign key → board.id — NOT NULL
- contents — VARCHAR(200) — NOT NULL
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
- deleted_at — DATETIME(6)
friend
- id — BIGINT — Primary key — NOT NULL
- follower_id — BIGINT — Foreign key → user.id — NOT NULL
- following_id — BIGINT — Foreign key → user.id — NOT NULL
- approval — TINYINT — NOT NULL
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
user
- id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(50) — NOT NULL
- name — VARCHAR(10) — NOT NULL
- birth — DATETIME(6) — NOT NULL
- image — LONGBLOB
- mbti — VARCHAR(4)
- password — VARCHAR(60) — NOT NULL
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
- deleted_at — DATETIME(6)