BOOK
Tables (4)
author
- id — int(11) — Primary key — NOT NULL
- name — varchar(50) — NOT NULL
- address — varchar(100)
- tel — varchar(50)
- email — varchar(100)
book
- id — int(11) — Primary key — NOT NULL
- name — varchar(100) — NOT NULL
- isbn — varchar(150) — NOT NULL
- price — double(5,2)
- author_id — int(11) — Foreign key → author.id
- press_id — int(11) — Foreign key → press.id
- print_id — int(11) — Foreign key → print.id
press
- id — int(11) — Primary key — NOT NULL
- name — varchar(50) — NOT NULL
- address — varchar(100)
- type — varchar(500)
print
- id — int(11) — Primary key — NOT NULL
- name — varchar(50)
- address — varchar(100)
- remark — varchar(500)