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