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