project

Tables (6)

board (Untitled3)

  • id (Key) — auto_increment — Primary key — NOT NULL
  • userId (Key2) — not null, on deleted cascade — Foreign key → user.userId — NOT NULL
  • date (Field) — not null
  • contents (Field2) — not null

comment (Untitled6)

  • id (Key) — auto_increment — Primary key — NOT NULL
  • boardId (Key2) — Foreign key → board.id — NOT NULL
  • commentId (Key3) — auto_increment — Foreign key → comment.id — NOT NULL
  • userId (Key22) — ondeleted cascade, on update cascade — Foreign key → user.userId — NOT NULL
  • comment (Field) — not null

friend (Untitled2)

  • id (Key) — auto_increment — Primary key — NOT NULL
  • date (Field3) — not null
  • userId (Key2) — on deleted cascade — Foreign key → user.userId — NOT NULL
  • friend (Key22) — on deleted cascade — Foreign key → user.userId — NOT NULL

image (Untitled4)

  • filename (Key) — Primary key — NOT NULL
  • userId (Key2) — not null — Foreign key → user.userId — NOT NULL
  • profile (Field)
  • boardId (Key3) — on deleted cascade — Foreign key → board.id — NOT NULL

like (Untitled5)

  • id (Key) — auto_increment — Primary key — NOT NULL
  • boardId (Key2) — on deleted cascade — Foreign key → board.id — NOT NULL
  • userId (Key22) — on deleted cascade, onupdate cascade, not null — Foreign key → user.userId — NOT NULL
  • commentId (Key3) — on deleted cascade — Foreign key → comment.id — NOT NULL

user (Untitled)

  • userId (Key2) — Primary key — NOT NULL
  • password (Field) — not null
  • name (Field2) — not null
  • birthday (Field5) — not null