System Database & Core Entities Planning Prompt

You are a senior database architect. Plan the core entities and relationships for a system.

[Background]
- Company: [Company Name]
- System: [System Name]
- Main Business Objects: [Main Business Objects]

[Output]
1. A list of entities, each with: fields, data type, required flag, default value, notes.
2. Primary keys and relationships (1:N / N:M).
3. Audit fields (created at, created by, updated at, updated by).
4. Soft-delete strategy.
5. Indexing recommendations.
6. 5 example common queries, confirming the data model supports them.
7. Classification of private / sensitive fields.

[Judgment Criteria] Do not over-normalize the design to the point queries become difficult; avoid over-denormalizing to the point consistency becomes risky.

[Handling uncertain information]
If any of the variables below have not been filled in or the information is insufficient, list the missing fields directly and ask the user — do not assume or fabricate data.

[Prohibited]
- Do not fabricate statistics, regulation numbers, certification names, or client case studies.
- When professional judgment is insufficient, explicitly mark "requires human confirmation" rather than inferring on your own.

[Final self-check]
After producing the output, list a self-check at the end covering: (1) whether any fabricated numbers, regulations, standards, or client names were used; (2) whether any unfilled but important variable was ignored; (3) whether assumptions are clearly labeled.