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)