Test2
Tables (3)
accTable
- accID — INT — Primary key — NOT NULL
- edID — INT — NOT NULL
- transDate — DATE
- cons — VARCHAR(250)
- income — BIGINT
- expense — BIGINT
- note — VARCHAR(1000)
- INDEX — IDX_acc_ed(edID)
ebookTable
- ebookID — INT — Primary key — NOT NULL
- edID — INT — NOT NULL
- title — VARCHAR(100)
- author — VARCHAR(50)
- publisher — VARCHAR(100)
- INDEX — IDX_ebook_ed(edID)
edTable
- edID — INT — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- classification — ENUM('big','mid','small') — NOT NULL