Elec-Document

Tables (7)

Untitled (ebook)

  • Key (ebook_code) — bigint — Primary key — NOT NULL
  • Field (ebook_name) — varchar(50) — NOT NULL
  • Field (ebook_writer) — varchar(50) — NOT NULL
  • Field (file_extension) — varchar(10) — NOT NULL
  • Key (pub_code) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (elec_code) — bigint — Foreign key → Untitled.Key — NOT NULL

Untitled (accounting_voucher)

  • Key (accv_code) — bigint — Primary key — NOT NULL
  • Field (date) — date — NOT NULL
  • Field (summary) — varchar(100) — NOT NULL
  • Field (income) — int — NOT NULL
  • Field (expenses) — int — NOT NULL
  • Field2 (comment) — varchar(200)
  • Field (file_extension) — varchar(10) — NOT NULL
  • Key (elec_code) — bigint — Foreign key → Untitled.Key — NOT NULL

Untitled (publisher)

  • Key (pub_code) — bigint — Primary key — NOT NULL
  • Field (pub_name) — varchar(20) — NOT NULL

Untitled (major_category)

  • Key (mj_code) — bigint — Primary key — NOT NULL
  • Field (mj_name) — varchar(10) — NOT NULL

Untitled (mid_category)

  • Key (mid_code) — bigint — Primary key — NOT NULL
  • Field (mid_name) — varchar(10) — NOT NULL
  • Key (mj_code) — bigint — Foreign key → Untitled.Key — NOT NULL

Untitled (sub_category)

  • Key (sub_code) — bigint — Primary key — NOT NULL
  • Field (sub_name) — varchar(10) — NOT NULL
  • Key (mid_code) — bigint — Foreign key → Untitled.Key — NOT NULL

Untitled (elec_document)

  • Key (elec_code) — bigint — Primary key — NOT NULL
  • Field (elec_name) — varchar(50) — NOT NULL
  • Key (sub_code) — bigint — Foreign key → Untitled.Key — NOT NULL