CoMu

Tables (4)

Board (Untitled3)

  • id — bigint — Primary key — NOT NULL
  • contents — varchar
  • createDate — timestamp
  • updateDate — timestamp
  • memberId — bigint — Foreign key → Member.id — NOT NULL

Comment (Untitled2)

  • id — bigint — Primary key — NOT NULL
  • username — varchar
  • contents — varchar
  • creatDate — timestamp
  • updateDate — timestamp
  • boardId — bigint — Foreign key → Board.id — NOT NULL
  • memberId — bigint — Foreign key → Member.id — NOT NULL

Friend (Untitled4)

  • id — bigint — Primary key — NOT NULL
  • memberId — bigint — Foreign key → Member.id — NOT NULL
  • memberid2 — bigint
  • status (Field) — varchar(255)

Member (Untitled)

  • id — bigint — Primary key — NOT NULL
  • username — varchar
  • email — varchar
  • password — varchar
  • birth — varchar
  • createDate — timestamp
  • updateDate — timestamp