도서관 관리 물리적 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)