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