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