도서관 관리 물리적 ERD
테이블 (12)
Untitled (member)
- Key (member_id) — 기본 키 — NOT NULL
- Field (tel_no)
- Field (member_name)
- Field (address)
- Field (email)
- Field (unsubscribe_yn)
- Field (golden_member_yn)
- Field (return_yn)
- Field (reg_date)
Untitled (company)
- Key (comp_reg_no) — 기본 키 — NOT NULL
- Field (comp_name)
- Field (name)
- Field (address)
- Field (business_type)
- Field (business_item)
Untitled (rent)
- Key (rental_no) — 기본 키 — NOT NULL
- Field (rent_date)
- Key (member_id) — 외래 키 → Untitled.Key — NOT NULL
Untitled (tax_bill)
- Key (rcv_no) — 기본 키 — NOT NULL
- Field (comp_no)
- Field (issue_date)
- Field (supply_price_sum)
- Field (tax_sum)
- Key (comp_reg_no) — 외래 키 → Untitled.Key — NOT NULL
Untitled (rent_)
- Key (book_id) — 외래 키 → Untitled.Key — NOT NULL
- Key (rental_no) — 외래 키 → Untitled.Key — NOT NULL
- Field (return_due_date)
- Field (return_yn)
- Field (return_type)
- Field (late_charge_yn)
Untitled (tax_invoice)
- Key (serial_no) — 기본 키 — NOT NULL
- Key (rcv_no) — 외래 키 → Untitled.Key — NOT NULL
- Field (supply_date)
- Field (item)
- Field (spec)
- Field (mount)
- Field (unit_price)
- Field (supply_price)
- Field (tax_amount)
Untitled (book)
- Key (book_id) — 기본 키 — NOT NULL
- Field (stock_date)
- Field (etc_infop)
- Key (rcv_no) — 외래 키 → Untitled.Key — NOT NULL
- Key (product_no) — 외래 키 → Untitled.Key — NOT NULL
Untitled (product)
- Key (product_no) — 기본 키 — NOT NULL
- Field (class_symbol)
- Field (title)
- Field (author)
- Field (publisherp)
- Field (publish_year)
- Field (domestic_yn)
- Field (old_new)
- Key (class_no) — 외래 키 → Untitled.Key — NOT NULL
Untitled (env_rariable)
- Key (var_name) — 기본 키 — NOT NULL
- Field (var_value)
- Field (var_desc)
Untitled (book_club)
- Key (club_id) — 기본 키 — NOT NULL
- Field (club_name)
- Field (no_of_member)
- Field (age)
- Key (member_id) — 외래 키 → Untitled.Key — NOT NULL
Untitled (rent_statistics)
- Key (rent_date) — 기본 키 — NOT NULL
- Key (class_no) — 외래 키 → Untitled.Key — NOT NULL
- Field (new_book_yn)
- Field (no_of_book_rent)
- Field (no_of_rent_member)
Untitled (dewei_table)
- Key (class_no) — 기본 키 — NOT NULL
- Field (class_name)