asd
테이블 (4)
제품
- item_num — varchar(10) — 기본 키 — NOT NULL
- item_name — varchar(20)
- item_main_category — varchar(10)
- item_sub_category — varchar(10)
- item_price — Integer
- item_stock — Integer
- item_detail — Text
- item_filename — varchar(20)
주문
- Key — VARCHAR(255) — 기본 키 — NOT NULL
- member_id — varchar(20) — NOT NULL
주소
- address_num — Integer — 기본 키 — NOT NULL
- address_address — varchar(50)
- address_post — varchar(10)
- address_detail — varchar(50)
회원
- member_id — varchar(20) — 기본 키 — NOT NULL
- member_pw — varchar(255)
- member_name — varchar(30)
- member_phone — varchar(20)
- member_gender — varchar(10)
- member_email — varchar(255)
- member_role — varchar(255)
- address_num — Integer — NOT NULL