Neordinary-U

Tables (8)

Untitled (Session)

  • Key (id) — String — Primary key — NOT NULL
  • Field (sid) — String
  • Field (data) — VarChar(512)
  • Field (expiresAt) — Datetime

Untitled (Funding)

  • Key (id) — int — Primary key — NOT NULL
  • Field (title) — VarChar(255)
  • Field2 (description) — text
  • Field3 (goalMoney) — int
  • Field (fundedMoney) — int
  • Field2 (deadlineDate) — Datetime(6)
  • Field (CreatedAt) — Datetime(6)
  • Field2 (UpdatedAt) — Datetime(6)

Untitled (Megazine)

  • Key (id) — int — Primary key — NOT NULL
  • Key (UserId) — int — Foreign key → User.Key — NOT NULL
  • Field (title) — VarChar(255)
  • Field2 (body) — text
  • Field (CreatedAt) — Datetime(6)

Untitled (JoinedUser)

  • Key (id) — int — Primary key — NOT NULL
  • Key (FundingsId) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (UserId) — int — Foreign key → User.Key — NOT NULL
  • Field (CreatedAt) — Datetime(6)
  • Field (UpdatedAt) — Datetime(6)
  • Field (fundedMoney) — int

Untitled (Region)

  • Key (id) — int — Primary key — NOT NULL
  • Field (name) — VarChar(50)

Untitled (Photo)

  • Key (id) — int — Primary key — NOT NULL
  • Key (FundingId) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (url) — VarChar(255)

Untitled (MegazinePhoto)

  • Key (id) — int — Primary key — NOT NULL
  • Key (MegazineId) — int — Foreign key → Untitled.Key — NOT NULL
  • Field2 (url) — VarChar(255)

User

  • Key (id) — int — Primary key — NOT NULL
  • Key (RegionId) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (name) — VarChar(100)
  • Field2 (email) — VarChar(255)
  • Field (password) — VarChar(100)
  • Field (status) — ENUM
  • Field (inactiveDate) — Datetime(6)
  • Field (CreatedAt) — Datetime(6)