instagram

Tables (13)

Avatar (CopyOfUntitled)

  • id (Key) — Integer — Primary key — NOT NULL
  • user (Key2) — Integer — Foreign key → User.id — NOT NULL
  • image (Field2) — Image — NOT NULL
  • created (Field3) — DateTime — NOT NULL

Comment (CopyOfCopyOfUntitled2)

  • id (Key) — Integer — Primary key — NOT NULL
  • post (Key2) — Integer — Foreign key → Post.id — NOT NULL
  • author (Key5) — Integer — Foreign key → User.id — NOT NULL
  • head (Key3) — Integer — Foreign key → Comment.id — NOT NULL
  • who (Key4) — Integer — Foreign key → Comment.id — NOT NULL
  • content (Field) — Char — NOT NULL

Group (Untitled3)

  • id (Key) — Integer — Primary key — NOT NULL
  • creator (Key2) — Integer — Foreign key → User.id — NOT NULL

GroupMessage (CopyOfCopyOfUntitled332)

  • id (Field) — Integer — Primary key — NOT NULL
  • group (Key) — Integer — Foreign key → Group.id — NOT NULL
  • message (Field2) — Text — Foreign key → Message.keyword — NOT NULL
  • author (Key2) — Integer — Foreign key → User.id — NOT NULL
  • created (Field3) — DateTime — NOT NULL
  • deleted (Field5) — Boolean

Heart (CopyOfCopyOfCopyOfUntitled2)

  • id (Key) — Integer — Primary key — NOT NULL
  • post (Key2) — Integer — Foreign key → Post.id — NOT NULL
  • author (Key3) — Integer — Foreign key → User.id — NOT NULL
  • created (Field) — DateTime — NOT NULL

Image (CopyOfUntitled2)

  • id (Key) — Integer — Primary key — NOT NULL
  • post (Key2) — Integer — Foreign key → Post.id — NOT NULL
  • file (Field) — Image — NOT NULL

Message (CopyOfUntitled33)

  • keyword (Field) — Text — Primary key — NOT NULL

Notice (CopyOfCopyOfUntitled)

  • id (Key) — Integer — Primary key — NOT NULL
  • user (Key2) — Integer — Foreign key → User.id — NOT NULL
  • content (Field2) — Char — NOT NULL
  • created (Field3) — DateTime — NOT NULL
  • Field — Boolean — NOT NULL

Participant (CopyOfCopyOfUntitled33)

  • id (Key) — Integer — Primary key — NOT NULL
  • group (Key3) — Integer — Foreign key → Group.id — NOT NULL
  • user (Key2) — Integer — Foreign key → User.id — NOT NULL
  • title (Field) — Char — NOT NULL
  • created (Field2) — DateTime — NOT NULL

Post (Untitled2)

  • id (Key) — Integer — Primary key — NOT NULL
  • author (Key2) — Integer — Foreign key → User.id — NOT NULL
  • content (Field2) — Text — NOT NULL
  • created (Field3) — DateTime — NOT NULL
  • updated (Field4) — DateTime — NOT NULL

Tag (CopyOfCopyOfCopyOfCopyOfUntitled2)

  • keyword (Key) — Char — Primary key — NOT NULL

TagPost (CopyOfCopyOfCopyOfCopyOfCopyOfUntitled2)

  • post (Key) — Integer — Foreign key → Post.id — NOT NULL
  • keyword (Key2) — Char — Foreign key → Tag.keyword — NOT NULL

User (Untitled)

  • id (Key) — Integer — Primary key — NOT NULL
  • username (Field) — Email — NOT NULL
  • password (Field2) — Password — NOT NULL
  • name (Field3) — Char
  • phone (Field4) — Char
  • email (Field5) — Email
  • description (Field6) — Text
  • following (Key3) — Integer — Foreign key → User.id — NOT NULL