ERD

Tables (3)

business_documents

  • document_id — BIGINT — Primary key — NOT NULL
  • business_info_id — BIGINT — Foreign key → business_member.business_info_id — NOT NULL
  • 문서유형 (document_type) — VARCHAR(50)
  • 파일경로 (file_path) — VARCHAR(255)
  • 업로드일시 (upload_date) — TIMESTAMP
  • 검증상태 (verification_status) — VARCHAR(20)

business_member

  • business_info_id — BIGINT — Primary key — NOT NULL
  • 기업회원ID (business_id) — VARCHAR(50)
  • 비밀번호 (password) — VARCHAR(255)
  • 회사명 (company_name) — VARCHAR(100) — NOT NULL
  • 사업자번호 (business_number) — VARCHAR(20) — NOT NULL
  • 대표자명 (representative_name) — VARCHAR(50) — NOT NULL
  • 회사전화 (business_phone) — VARCHAR(20)
  • 회사주소 (business_address) — TEXT
  • 회사팩스 (business_fax) — VARCHAR(20)
  • 담당자명 (manager_name) — VARCHAR(50)
  • 담당부서 (department) — VARCHAR(50)
  • 담당연락처 (manager_phone) — VARCHAR(255)
  • 회사팩스 (company_fax) — VARCHAR(20)
  • 담당이메일 (manager_email) — VARCHAR(255)
  • 생성일시 (created_at) — TIMESTAMP
  • 수정일시 (updated_at) — TIMESTAMP
  • 비밀번호수정시간 (password_at) — TIMESTAMP
  • 마지막로그인시간 (last_login_at) — TIMESTAMP
  • 권한 (role) — ENUM
  • 상태 (state) — ENUM

individual_member

  • normal_info_id — BIGINT — Primary key — NOT NULL
  • 개인회원ID (individual_id) — VARCHAR(50)
  • 담당자명 (department) — VARCHAR(50)
  • 담당부서 (address) — VARCHAR(50)
  • 연락처 (phone) — VARCHAR(255)
  • 이메일 (email) — VARCHAR(255)
  • 비밀번호 (password) — VARCHAR(255)
  • 생성일시 (created_at) — TIMESTAMP
  • 수정일시 (updated_at) — TIMESTAMP
  • 비밀번호수정시간 (password_at) — TIMESTAMP
  • 마지막로그인시간 (last_login_at) — TIMESTAMP
  • 권한 (role) — ENUM
  • 상태 (state) — ENUM