데이터 정규화

테이블 (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