newsdb

Tables (7)

Categories (Untitled4)

  • Key — SMALLINT — Primary key — NOT NULL
  • name (Field) — VARCHAR(8)

Categories2 (Untitled7)

  • Key — SMALLINT — Primary key — NOT NULL
  • category_id (Key2) — SMALLINT — Foreign key → Categories.Key — NOT NULL
  • name (Field) — VARCHAR(16)

Comments (Untitled2)

  • Key — INT — Primary key — NOT NULL
  • news_id (Key3) — INT — Foreign key → News.Key — NOT NULL
  • user_id (Key2) — INT — Foreign key → Users.Key — NOT NULL
  • content (Field) — TEXT
  • created_at (Field2) — DATETIME

News (Untitled)

  • Key — INT — Primary key — NOT NULL
  • platform_id (Key2) — SMALLINT — Foreign key → Platform.Key — NOT NULL
  • category_id (Key3) — SMALLINT — Foreign key → Categories.Key — NOT NULL
  • category2_id (Key4) — SMALLINT — Foreign key → Categories2.Key — NOT NULL
  • title (Field) — VATCHAR(256)
  • press (Field8) — VARCHAR(16)
  • writer (Field2) — VATCHAR(16)
  • created_at (Field3) — DATETIME
  • update_at (Field4) — DATETIME
  • content (Field5) — TEXT
  • stickers (Field6) — JSON
  • url (Field7) — VATCHAR(128)

Platform (Untitled5)

  • Key — SMALLINT — Primary key — NOT NULL
  • name (Field) — VARCHAR(8)

Stickers (Untitled3)

  • Key — INT — Primary key — NOT NULL
  • name (Field) — VARCHAR(16)

Users (Untitled6)

  • Key — INT — Primary key — NOT NULL
  • platform_id (Key2) — SMALLINT — Foreign key → Platform.Key — NOT NULL
  • name (Field) — VARCHAR(16)
  • idno (Field2) — VARCHAR(16)