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