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