PinterestClone

Tables (5)

Board (Untitled2)

  • Board ID (board_id) — int(11) — Primary key — NOT NULL
  • Name (board_name) — varchar(30)
  • Like (like_count) — int(11)
  • Create Date (create_date) — timestamp
  • Delete Date (delete_date) — timestamp
  • Modify Date (modified_date) — timestamp
  • Delete Status (delete_status) — int(11)
  • Id (id2) — varchar(20) — Foreign key → User-Board.Id — NOT NULL

Board-Pin (Untitled4)

  • Board ID (board_id) — int(11) — Foreign key → Board.Board ID — NOT NULL
  • Pin ID (pin_id) — int(11) — Foreign key → Pin.Pin ID — NOT NULL

Pin (Untitled3)

  • Pin ID (pin_id) — int(11) — Primary key — NOT NULL
  • Pin Name (pin_name) — varchar(30)
  • Description (description) — varchar(100)
  • Image Address (image_address) — varchar(100)
  • Source Address (source_address) — varchar(100)
  • Like (like_count) — int(11)
  • Create Date (create_date) — timestamp
  • Delete Date (delete_date) — timestamp
  • Modify Date (modifed_date) — timestamp
  • Delete Status (delete_status) — int(11)

User (Untitled)

  • Id (id) — varchar(20) — Primary key — NOT NULL
  • Password (password) — varchar(30)
  • Last Name (last_name) — varchar(30)
  • First Name (first_name) — varchar(30)
  • User Id (user_id) — varchar(30)
  • Birthday (birthday) — varchar(10)
  • Create Date (create_date) — timestamp
  • Delete Date (delete_date) — timestamp
  • Modify Date (modified_date) — timestamp
  • Delete Status (delete_status) — int(11)

User-Board (Untitled5)

  • Id (id) — varchar(20) — Foreign key → User.Id — NOT NULL