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