리눅스
테이블 (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