sns
Tables (7)
board (Untitled2)
- boardId (Key) — auto_increment — Primary key — NOT NULL
- title (Field) — not null
- contents (Field2) — not null
- date (Field3) — not null
- show (Key2) — cascade — Foreign key → show.show — NOT NULL
- user_Id (Key3) — cascade — Foreign key → user.user_Id — NOT NULL
comments (Untitled5)
- commentsId (Key) — auto_increment — Primary key — NOT NULL
- comments (Field) — not null
- boardId (Key2) — cascade, not null — Foreign key → board.boardId — NOT NULL
- user_Id (Key3) — cascade, not null — Foreign key → user.user_Id — NOT NULL
- FcommentsId (Key4) — cascade — Foreign key → comments.commentsId — NOT NULL
file (Untitled4)
- filename (Key) — Primary key — NOT NULL
- user_Id (Key2) — not null, cascade — Foreign key → user.user_Id — NOT NULL
- boardId (Key3) — cascade — Foreign key → board.boardId — NOT NULL
- profile (Field) — not null
friend (Untitled3)
- friendId (Key) — auto_increment — Primary key — NOT NULL
- date (d) — not null
- user_Id (Key2) — not null,cascade — Foreign key → user.user_Id — NOT NULL
- friend (Key3) — not null,cascade — Foreign key → user.user_Id — NOT NULL
like (Untitled7)
- likeId (Key) — auto_increment — Primary key — NOT NULL
- boardId (Key2) — cascade — Foreign key → board.boardId — NOT NULL
- commentsId (Key3) — cascade — Foreign key → comments.commentsId — NOT NULL
- user_Id (Key4) — cascade, not null — Foreign key → user.user_Id — NOT NULL
show (Untitled6)
- show (Key) — Primary key — NOT NULL
user (Untitled)
- user_Id (Key) — auto_increment — Primary key — NOT NULL
- userId (Field) — not null
- password (Field2) — not null
- name (Field3) — not null
- birthday (Field4) — not null