library

Tables (9)

Untitled (role)

  • Key (id) — bigint(20) — Primary key — NOT NULL
  • Field (authority) — varchar(255)

Untitled (user_role)

  • Key (id) — bigint(20) — Foreign key → user.Key — NOT NULL
  • Key (role) — bigint(20) — Foreign key → Untitled.Key — NOT NULL

Untitled (book)

  • Key (id) — bigint(20) — Primary key — NOT NULL
  • Key (publisher) — bigint(20) — Foreign key → Untitled.Key — NOT NULL
  • Key (classfication) — bigint(20) — Foreign key → Untitled.Key — NOT NULL
  • Field (disable) — bit — NOT NULL
  • Field (title) — varchar(255) — NOT NULL

Untitled (author)

  • Key (id) — bigint(20) — Primary key — NOT NULL
  • Field (name) — varchar(255) — NOT NULL

Untitled (publisher)

  • Key (id) — bigint(20) — Primary key — NOT NULL
  • Field (name) — varchar(255) — NOT NULL

Untitled (classfication)

  • Key (id) — bigint(20) — Primary key — NOT NULL
  • Field (name) — varchar(3) — NOT NULL

Untitled (log)

  • Key (id) — bigint(20) — Primary key — NOT NULL
  • Key (user) — bigint(20) — Foreign key → user.Key — NOT NULL
  • Key (book) — bigint(20) — Foreign key → Untitled.Key — NOT NULL
  • Field (reservation) — bit — NOT NULL
  • Field (loan) — bit — NOT NULL
  • Field2 (create) — datetime — NOT NULL
  • Field (update) — datetime

Untitled (book_author)

  • Key (book) — bigint(20) — Foreign key → Untitled.Key — NOT NULL
  • Key (author) — bigint(20) — Foreign key → Untitled.Key — NOT NULL

user

  • Key (id) — bigint(20) — Primary key — NOT NULL