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