dabo
Tables (5)
Article (Untitled2)
- PK (Key) — BIGINT — Primary key — NOT NULL
- reviewer (Key2) — BIGINT — Foreign key → User.PK — NOT NULL
- category (Key3) — BIGINT — Foreign key → Category.PK — NOT NULL
- name (Field) — VARCHAR
- rate (Field2) — DECIMAL
- comment (Field3) — VARCHAR
Category (Untitled3)
- PK (Key) — BIGINT — Primary key — NOT NULL
- name (Field) — VARCHAR
Genre (Untitled4)
- PK (Key) — BIGINT — Primary key — NOT NULL
- name (Field) — VARCHAR
Genre-Article (Untitled5)
- PK (Key) — BIGINT — Primary key — NOT NULL
- article (Key2) — BIGINT — Foreign key → Article.PK — NOT NULL
- genre (Key3) — BIGINT — Foreign key → Genre.PK — NOT NULL
User (Untitled)
- PK (Key) — BIGINT — Primary key — NOT NULL
- username (Field) — VARCHAR
- password (Field2) — VARCHAR
- nickname (Field3) — VARCHAR
- is_active (Field4) — BIGINT
- created_at (Field5) — DATETIME