dreamBulider

테이블 (5)

Member (Untitled)

  • member_id (PK) — BigInt — 기본 키 — NOT NULL
  • email (Field) — varchar(50) — NOT NULL
  • password (Field2) — varchar(255) — NOT NULL
  • name (Field3) — varchar(25) — NOT NULL

board (Untitled2)

  • Board_id (Key) — Bigint — 기본 키 — NOT NULL
  • member_id (FK) — BigInt — 외래 키 → Member.member_id — NOT NULL — FK
  • title (Field) — varchar — NOT NULL
  • content (Field2) — varchar — NOT NULL
  • regTime (Field3) — timeStamp — NOT NULL
  • updateTime (Field4) — timeStamp
  • invisible (Field5) — tinyint — NOT NULL

hashTagTable (Untitled4)

  • hashTag_id (Key) — Bigint — 기본 키 — NOT NULL
  • Board_id (Key2) — Bigint — 외래 키 → board.Board_id — NOT NULL
  • hashTag (Field) — varchar

reply (Untitled5)

  • reply_id (Key) — bigint — 기본 키 — NOT NULL

좋아요 (Untitled3)

  • liked_id (Key) — 기본 키 — NOT NULL
  • member_id (FK) — BigInt — 외래 키 → Member.member_id — NOT NULL — FK
  • Board_id (Key2) — Bigint — 외래 키 → board.Board_id — NOT NULL — FK
  • isLike (Field) — tinyInt — NOT NULL