DB
Tables (3)
Cart
- order_seq_num — Foreign key → Order.order_seq_num — NOT NULL
- member_id — Foreign key → Order.member_id — NOT NULL
- name
- price
- cnt
Member (member)
- member_id — Primary key — NOT NULL
- member_pw
- member_name
- member_gender
- member_birth_y
- member_birth_m
- member_birth_d
- member_birth_gn
- tel1
- tel2
- tel3
Order
- order_seq_num — Primary key — NOT NULL
- member_id — Foreign key → Member.member_id — NOT NULL
- order_id
- receiver