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)