test

Tables (4)

Company_Info (Untitled2)

  • company_info_id (PK) — Primary key — NOT NULL
  • member_id (FK) — Foreign key → Member.member_id — NOT NULL
  • representative_name (Field)
  • business_number (Field2)
  • company_address (Field3)
  • business_type (Field4)
  • industry_type (Field5)
  • phone (Field6)
  • fax (Field7)
  • site_url1 (Field8)
  • site_url2 (Field9)
  • site_url3 (Field10)
  • business_certificate (Field11)
  • tax_certificate (Field12)
  • mail_order_certificate (Field13)

MANAGER_INFO (Untitled4)

  • manager_info_id (PK) — Primary key — NOT NULL
  • member_id (FK) — Foreign key → Member.member_id — NOT NULL
  • manager_name (Field)
  • manager_phone (Field2)
  • manager_email (Field3)

Member (Untitled)

  • member_id (PK) — Primary key — NOT NULL
  • user_id (Field)
  • password (Field2)
  • type (Field3)
  • grade (Field4)
  • Field5

REPRESENTATIVE_INFO (Untitled3)

  • representative_info_id (PK) — Primary key — NOT NULL
  • member_id (FK) — Foreign key → Member.member_id — NOT NULL
  • representative_phone (Field2)
  • representative_email (Field3)