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