customerService-erd

Tables (5)

Admin (CS담당자)

  • admin_id (담당자ID) — varchar — Primary key — NOT NULL
  • password (비밀번호) — varchar
  • name (이름) — varchar

Answer (답변)

  • inquiry_id (문의ID) — bigint — Foreign key → Inquiry.inquiry_id — NOT NULL
  • admin_id (담당자ID) — varchar — Foreign key → Admin.admin_id — NOT NULL
  • comment (답변내용) — varchar
  • writer (답변담당자) — varchar
  • created_date (작성일) — datetime

Customer (고객)

  • customer_id (고객ID) — varchar — Primary key — NOT NULL
  • password (비밀번호) — varchar
  • name (이름) — varchar

File (파일)

  • file_id (파일ID) — varchar — Primary key — NOT NULL
  • inquiry_id (문의ID) — bigint — Foreign key → Inquiry.inquiry_id — NOT NULL
  • original_name (원본이름) — varchar
  • upload_name (업로드이름)
  • path (저장경로) — varchar

Inquiry (문의)

  • inquiry_id (문의ID) — bigint — Primary key — NOT NULL
  • customer_id (고객ID) — varchar — Foreign key → Customer.customer_id — NOT NULL
  • classification (분류) — varchar
  • title (제목) — varchar
  • content (내용) — varchar
  • writer (작성자) — varchar
  • created_date (작성일) — datetime
  • answered (답변여부) — boolean