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)