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