SuperStudy
Tables (3)
5rr (Comment)
- Key (id) — LONG — Primary key — NOT NULL
- Key (postId) — LONG — Foreign key → Untitled2.Key — NOT NULL
- (userEmail) — VARCHAR — Foreign key → Member.id — NOT NULL
- Field (contents) — VARCHAR — NOT NULL
- Field (created_at) — DATETIME — NOT NULL
Member (User)
- (id) — LONG — Primary key — NOT NULL
- Field (email) — VARCHAR — NOT NULL
- Field (name) — VARCHAR — NOT NULL
- Field (picture) — VARCHAR — NOT NULL
- Field (role) — VARCHAR — NOT NULL
Untitled2 (Post)
- Key (id) — LONG — Primary key — NOT NULL
- (userEmail) — VARCHAR — Foreign key → Member.id — NOT NULL
- Field (title) — VARCHAR
- Field (address) — VARCHAR
- Field (category) — VARCHAR
- Field (totalPersons) — INT
- Field (joinPersons) — INT
- Field (vacancy) — INT
- Field (contents) — VARCHAR
- Field (created_at) — DATETIME