DB 9조
테이블 (11)
Ad
- ad_id — BIGINT — 기본 키
- is_Banner (isBanner) — type
- title — VARCHAR(200) — NOT NULL
- body — TEXT
- image — VARCHAR(255)
- target_url — VARCHAR(255)
- is_active — TINYINT(1) — NOT NULL
- created_at — DATETIME — NOT NULL
Board
- board_id — BIGINT — 기본 키
- name — VARCHAR(100) — NOT NULL
- school_id — BIGINT — 외래 키 → School.school_id — NOT NULL
Comment
- comment_id — BIGINT — 기본 키
- content — TEXT — NOT NULL
- created_at — DATETIME — NOT NULL
- is_anonymous — TINYINT(1) — NOT NULL
- user_id — BIGINT — 외래 키 → User.user_id
- post_id — BIGINT — 외래 키 → Post.post_id
CommentLike
- user_id — BIGINT — 외래 키 → User.user_id
- comment_id — BIGINT — 외래 키 → Comment.comment_id
Notification
- notification_id — BIGINT — 기본 키
- type — ENUM(1,0) — NOT NULL
- created_at — DATETIME — NOT NULL
- comment_id — BIGINT — 외래 키 → Comment.comment_id
- post_id — BIGINT — 외래 키 → Post.post_id
Post
- post_id — BIGINT — 기본 키
- title — VARCHAR(200) — NOT NULL
- content — TEXT — NOT NULL
- image — VARCHAR(255)
- created_at — DATETIME — NOT NULL
- is_anonymous — TINYINT(1) — NOT NULL
- user_id — BIGINT — 외래 키 → User.user_id
- board_id (board_id2) — BIGINT — 외래 키 → Board.board_id
PostLike
- user_id — BIGINT — 외래 키 → User.user_id
- post_id — BIGINT — 외래 키 → Post.post_id
PostScrap
- user_id — BIGINT — 외래 키 → User.user_id
- post_id — BIGINT — 외래 키 → Post.post_id
School
- school_id — BIGINT — 기본 키 — NOT NULL
- name — VARCHAR(100) — NOT NULL
User
- user_id — BIGINT — 기본 키
- nickname — VARCHAR(50) — NOT NULL
- profile_image — VARCHAR(255)
- school_id — BIGINT — 외래 키 → School.school_id — NOT NULL
User-Notification
- user_id — BIGINT — 외래 키 → User.user_id
- notification_id — BIGINT — 외래 키 → Notification.notification_id
- is_read — Boolean
- is_alarm — Boolean