게시판

테이블 (5)

Board (Untitled2)

  • board_id (Key) — bigint — 기본 키 — NOT NULL
  • user_id (Key2) — bigint — 외래 키 → user.user_id — NOT NULL
  • title (Field) — varchar
  • content (Field2) — text
  • image_url (Field3) — varchar(255)
  • created_at (Field4) — timestamp
  • modified_at (Field5) — timestamp
  • is_notice (Field6) — boolean
  • board_status (Field7) — enum

Comment (Untitled3)

  • comment_id (Key) — bigint — 기본 키 — NOT NULL
  • user_id (Key2) — bigint — 외래 키 → user.user_id — NOT NULL
  • board_id (Key3) — bigint — 외래 키 → Board.board_id — NOT NULL
  • content (Field) — text
  • created_at (Field2) — timestamp
  • modified_at (Field3) — timestamp

Role (Untitled4)

  • role_id (Key) — bigint — 기본 키 — NOT NULL
  • user_id (Key2) — bigint — 외래 키 → user.user_id — NOT NULL
  • role (Field) — varchar(10)

View (Untitled5)

  • view_id (Key) — bigint — 기본 키 — NOT NULL
  • user_id (Key2) — bigint — 외래 키 → user.user_id — NOT NULL
  • board_id (Key3) — bigint — 외래 키 → Board.board_id — NOT NULL

user (Untitled)

  • user_id (Key) — bigint — 기본 키 — NOT NULL
  • email (Field) — varchar(30)
  • password (Field2) — varchar(255)
  • nickname (Field3) — varchar(10)
  • created_at (Field5) — timestamp
  • modified_at (Field6) — timestamp
  • user_status (Field7) — enum