asdsa
Tables (6)
addr
- mem_addr — VARCHAR(15) — Primary key — NOT NULL
- mem_code — INT — Primary key — NOT NULL
- mem_num — INT — NOT NULL
company
- com_name — VARCHAR(20) — Primary key — NOT NULL
- com_location — VARCHAR(20) — Primary key — NOT NULL
mem_card
- card_num — VARCHAR(25) — Primary key — NOT NULL
- card_period — VARCHAR(10) — Primary key — NOT NULL
- mem_num — INT — NOT NULL
member
- mem_num — INT — Primary key — NOT NULL
- mem_id — VARCHAR(13) — NOT NULL
- mem_pw — VARCHAR(10) — NOT NULL
- mem_email — VARCHAR(30) — NOT NULL
- mem_phone — VARCHAR(15) — NOT NULL
pd_order
- order_num — INT — Primary key — NOT NULL
- mem_num — INT — NOT NULL
- card_num — VARCHAR(25) — NOT NULL
- card_period — VARCHAR(10) — NOT NULL
- mem_addr — VARCHAR(15) — NOT NULL
- mem_code — INT — NOT NULL
- pd_num — INT — NOT NULL
- pd_name — VARCHAR(20) — NOT NULL
- pd_discount — VARCHAR(10)
- pd_type — VARCHAR(10) — NOT NULL
- pd_price — VARCHAR(25) — NOT NULL
- pd_date — DATE — NOT NULL
- pd_count — VARCHAR(10) — NOT NULL
product
- pd_num — INT — Primary key — NOT NULL
- pd_name — VARCHAR(20) — Primary key — NOT NULL
- pd_discount — VARCHAR(10) — Primary key — NOT NULL
- pd_type — VARCHAR(10) — Primary key — NOT NULL
- pd_price — VARCHAR(25) — Primary key — NOT NULL
- com_name — VARCHAR(20) — NOT NULL
- com_location — VARCHAR(20) — NOT NULL