# 물리 ERD

이 그림은 28절의 40개 표, 29절의 audit_events, 31절의 staff, 32절의 login_locks 와 login_ip_allows, 그리고 화살표다. 4절 그림을 대체하지 않는다. 부분 유니크는 그리지 않는다.

```mermaid
erDiagram
  customers ||--o{ orders : customer_id
  customers ||--o{ services : customer_id
  customers ||--o{ payments : customer_id
  customers ||--o{ payment_methods : customer_id
  customers ||--o{ customer_balance_entries : customer_id
  customers ||--o{ refunds : customer_id
  customers ||--o| customer_tax_profiles : customer_id
  customers ||--o{ tax_documents : customer_id
  customers ||--o{ payment_notice_mails : customer_id
  customers ||--o{ contacts : customer_id
  customers |o--o{ audit_events : actor_customer_id
  staff |o--o{ audit_events : actor_staff_id
  customers |o--o| login_locks : customer_id
  staff |o--o| login_locks : staff_id
  customers |o--o{ login_ip_allows : customer_id
  staff |o--o{ login_ip_allows : staff_id
  customers ||--o{ order_items : to_customer_id

  tlds ||--o{ products : tld_id
  tlds ||--o{ domains : tld_id
  products ||--o{ prices : product_id
  products ||--o{ services : product_id
  products ||--o{ order_items : product_id
  products ||--o{ order_items : from_product_id

  orders ||--|{ order_items : order_id
  order_items ||--o{ order_items : parent_order_item_id
  order_items }o--o| services : service_id
  order_items }o--o| services : from_service_id
  order_items }o--o| prices : price_id
  order_items }o--o| service_usage : usage_id
  services ||--o{ services : parent_service_id
  services ||--o{ service_usage : service_id

  payments ||--o{ payment_allocations : payment_id
  payments }o--o| payment_methods : payment_method_id
  order_items ||--o{ payment_allocations : order_item_id
  refunds }o--o| payments : payment_id
  refunds ||--|{ refund_lines : refund_id
  order_items ||--o{ refund_lines : order_item_id
  customer_balance_entries }o--o| payments : payment_id
  customer_balance_entries }o--o| order_items : order_item_id
  customer_balance_entries }o--o| refunds : refund_id

  domains }o--o| domains : predecessor_domain_id
  domain_services }o--|| services : "service_id, kind"
  domain_services }o--|| domains : domain_id
  order_items ||--o{ domain_reservations : order_item_id
  domain_contacts }o--|| domains : domain_id
  domain_contacts }o--|| contacts : contact_id
  domain_nameservers }o--|| domains : domain_id
  domain_ds_records }o--|| domains : domain_id

  hosting_accounts }o--|| hosting_servers : server_id
  hosting_services }o--|| services : "service_id, kind"
  hosting_services }o--|| hosting_accounts : hosting_account_id
  ssl_services }o--|| services : "service_id, kind"
  ssl_services }o--|| certificates : certificate_id
  mail_services }o--|| services : "service_id, kind"
  mail_services }o--o| dns_zones : zone_id
  server_services }o--|| services : "service_id, kind"
  dbms_services }o--|| services : "service_id, kind"
  security_services }o--|| services : "service_id, kind"

  dns_zones }o--o| domains : domain_id
  dns_zones }o--o| services : service_id
  dns_zones }o--o| dns_zones : parent_zone_id
  dns_records }o--|| dns_zones : zone_id
  zone_publish |o--|| dns_zones : zone_id

  order_items ||--o{ provisioning_jobs : order_item_id
  registry_events }o--o| domains : domain_id
  tax_documents ||--|{ tax_document_lines : tax_document_id
  tax_documents }o--o| tax_documents : adjusts_document_id
  tax_document_lines }o--|| order_items : order_item_id
  payment_notice_mails }o--|| services : service_id
  payment_notice_mails }o--o| payment_notice_mails : resend_of_id

  our_nameservers {
    text host_name PK
  }
```