camagru
Tables (5)
comment (Untitled4)
- commentId (Key) — not null — Primary key — NOT NULL
- comment (Field2) — not null
- date (Field3) — not null
- userId (Key2) — not null — Foreign key → user.userId — NOT NULL
- postId (Key3) — not null — Foreign key → post.postId — NOT NULL
image (Untitled2)
- imageId (Key) — not null — Primary key — NOT NULL
- date (Field2) — not null
- image (Field3) — not null
- userId (Key2) — not null — Foreign key → user.userId — NOT NULL
like (Untitled5)
- userId (Key) — not null — Foreign key → user.userId — NOT NULL
- postId (Key2) — not null — Foreign key → post.postId — NOT NULL
post (Untitled3)
- postId (Key) — not null — Primary key — NOT NULL
- date (Field2) — not null
- likes (Field4)
- userId (Key2) — not null — Foreign key → user.userId — NOT NULL
- imageId (Key3) — not null — Foreign key → image.imageId — NOT NULL
user (Untitled)
- userId (Key) — not null — Primary key — NOT NULL
- email (Field) — not null
- username (Field2) — not null
- password (Field3) — not null
- auth (Field4) — always/none
- notice (Field5) — always/none