Tragram

Tables (6)

Image1 (Untitled4)

  • img_id (Key) — char — Primary key — NOT NULL
  • img_url (Field) — char

Post1 (Untitled2)

  • Post ID (Key) — number — Primary key — NOT NULL
  • caption (Field2) — text
  • location (Field3) — char
  • time (Field) — timestamp
  • img_id (Key1) — Foreign key → Image1.img_id — NOT NULL

Project(実体) (Untitled)

  • Project ID (Key) — number — Primary key — NOT NULL
  • name (Field2) — char
  • caption (Field3) — text
  • Post ID (Key2) — number — Foreign key → Post1.Post ID — NOT NULL
  • comment ID (Key4) — number — Foreign key → comment1.comment ID — NOT NULL
  • like list ID (Key6) — number — Foreign key → like list ID.like list ID — NOT NULL
  • user id (Key3) — number — Foreign key → User1.user id — NOT NULL

User1 (Untitled3)

  • user id (Key) — number — Primary key — NOT NULL
  • name (Field) — text
  • created project list (Field2) — list
  • instagram access token (Field3) — text

comment1 (Untitled5)

  • comment ID (Key) — number — Primary key — NOT NULL
  • time (Field) — timestamp
  • comment (Field2) — text
  • user id (Key2) — number — Foreign key → User1.user id — NOT NULL

like list ID (Untitled6)

  • like list ID (Key) — number — Primary key — NOT NULL
  • user id (Key2) — number — Foreign key → User1.user id — NOT NULL