리눅스

테이블 (7)

Adress_

  • Address_number — Integer — 기본 키 — NOT NULL
  • membernumber — Varchar(20) — 외래 키 → Member_.membernumber — NOT NULL
  • Address_post_number — Varchar(10)
  • Address_detailed_adress — Varchar(20)
  • Address_baseadress — Varchar(30)

Book_

  • Book_number — Integer — 기본 키 — NOT NULL
  • Book_name — Varchar(20)
  • Book_stock — Integer
  • Book_price — Integer

Card_

  • Card_cardnumber — Varchar(12) — 기본 키 — NOT NULL
  • membernumber — Varchar(20) — 외래 키 → Member_.membernumber — NOT NULL
  • Card_term — Integer(4)
  • Card_cardkinds — Varchar(20)

Member_

  • membernumber — Varchar(20) — 기본 키 — NOT NULL
  • Member_password — Varchar(20)
  • Member_name — Varchar(4)
  • recommend_number — Varchar(20)
  • member_point — Integer

Order_

  • Order_ordernumber — Integer — 기본 키 — NOT NULL
  • membernumber — Varchar(20) — 외래 키 → Member_.membernumber — NOT NULL
  • Order_cardkinds — Varchar(20)
  • Order_cardnumber — Varchar(12)
  • Order_cardterm — Integer
  • Order_postnumber — Varchar(10)
  • Order_adress — Varchar(30)
  • Order_detailedadress — Varchar(20)
  • Order_orderdate — DATETIME

Orderlist_

  • Order_ordernumber — Integer — 외래 키 → Order_.Order_ordernumber — NOT NULL
  • Book_number — Integer — 외래 키 → Book_.Book_number — NOT NULL
  • Orderlist_quantity — Integer
  • Orderlist_totalprice — Integer
  • Order_orderdate — DATETIME

login_session

  • login_number — Varchar(20) — 기본 키 — NOT NULL
  • login_name — Varchar(4) — NOT NULL
  • login_point — Integer — NOT NULL