ER Diagram

erDiagram
    GENDER {
        int id PK
        string gender_type
    }
    COUNTRY {
        int id PK
        string country_name
        string iso_code
    }
    STATE {
        int id PK
        string name
        int country_id FK
    }
    NEWSLETTER_TYPE {
        int id PK
        string newsletter_type
    }
    CUSTOM_CONFIG {
        int id PK
        string key
        string value
        datetime created_at
        datetime updated_at
    }
    PAYMENT_METHOD {
        int id PK
        string method_name
    }
    PAYPAL_SETTINGS {
        int id PK
        string client_id
        string secret_key
        string mode
        string api_base_url
    }
    ORDER_STATUS {
        int id PK
        string status_name
    }
    PRODUCT_STATUS {
        int id PK
        string status_name
    }
    MEASUREMENT_FIELD {
        int id PK
        string name
        boolean is_active
        datetime created_at
    }

    COUNTRY ||--o{ STATE : "has"