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