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