데이터 정규화
테이블 (7)
Admin
- Admin_id — INT — 기본 키 — NOT NULL
- name — VARCHAR(100)
Certification
- Seq_Certify_Mark — INT — 기본 키 — NOT NULL
- Seq_idx — VARCHAR(255) — 외래 키 → Music.Seq_idx — NOT NULL
- Service_Code — VARCHAR(20) — 외래 키 → Service_Type.Service_Code — NOT NULL
- Certify_Grade — VARCHAR(10) — 외래 키 → Certification_Grade.Certify_Grade — NOT NULL
- Certify_Admin_id — INT — 외래 키 → Admin.Admin_id — NOT NULL
- Certify_Date — DATETIME
- created_at — DATETIME
- updated_at — DATETIME
- is_deleted — BOOLEAN
Certification_Grade
- Certify_Grade — VARCHAR(10) — 기본 키 — NOT NULL
- Grade_Name — VARCHAR(50)
- Min_Value — INT
- Service_Type — VARCHAR(20)
Delete
- delete_id — INT — 기본 키 — NOT NULL
- Seq_Certify_Mark — INT — NOT NULL
- deleted_Admin — INT — NOT NULL
- delete_reason — TEXT
- deleted_at — DATETIME
Deletion_History
- delete_id — INT — 기본 키 — NOT NULL
- Seq_Certify_Mark — INT — 외래 키 → Certification.Seq_Certify_Mark — NOT NULL
- delete_admin_id — INT — 외래 키 → Admin.Admin_id — NOT NULL
- delete_reason — TEXT
- deleted_at — DATETIME
- is_recovered — BOOLEAN
- recovery_admin_id — INT — 외래 키 → Admin.Admin_id
- recovered_at — DATETIME
Music
- Seq_idx — VARCHAR(255) — 기본 키 — NOT NULL
- name — VARCHAR(255)
- Service_Code — VARCHAR(20) — 외래 키 → Service_Type.Service_Code — NOT NULL
Service_Type
- Service_Code — VARCHAR(20) — 기본 키 — NOT NULL
- Service_Name — VARCHAR(50)
- Service_Description — TEXT