점프투스프링부트

테이블 (3)

BOARD (Untitled2)

  • id (Key) — integer — 기본 키 — NOT NULL
  • user_id (Key2) — integer — 외래 키 → USER.id — NOT NULL
  • title (Field2) — string
  • content (Field3) — string
  • created_at (Field4) — datetime
  • modified_at (Field5) — datetime
  • deleted_at (Field6) — datetime
  • is_deleted (Field7) — boolean

COMMENT (Untitled3)

  • id (Key) — integer — 기본 키 — NOT NULL
  • user_id (Key2) — integer — 외래 키 → USER.id — NOT NULL
  • board_id (Key3) — integer — 외래 키 → BOARD.id — NOT NULL
  • content (Field) — string
  • created_at (Field2) — datetime
  • modified_at (Field3) — datetime
  • deleted_at (Field4) — datetime
  • is_deleted (Field5) — boolean

USER (Untitled)

  • id (Key) — integer — 기본 키 — NOT NULL
  • user_name (Field) — string
  • password (Field2) — string
  • email (Field3) — string
  • nickname (Field4) — string
  • role (Field5) — string
  • created_at (Field6) — datetime
  • modified_at (Field7) — datetime
  • deleted_at (Field8) — datetime
  • is_deleted (Field9) — boolean