# Donus schema ERD

Table and field reference for the Fivetran Donus connector.

## Table & Field Reference

### payment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| grantee_name | Unknown | FK |
| member_id | Unknown | FK |
| promise_id | Unknown | FK |
| bank_account_code | Unknown |  |
| code | Unknown |  |
| deposit_date | Unknown |  |
| income_status | Unknown |  |
| name | Unknown |  |
| pay_date | Unknown |  |
| pay_method_code | Unknown |  |
| pay_method_type | Unknown |  |
| pay_price | Unknown |  |
| product_code | Unknown |  |
| purpose_code | Unknown |  |

### member_group

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| member_id | Unknown | PK, FK |
| group_id | Unknown |  |

### grants_report

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| grantee_name | Unknown | FK |
| apply_price | Unknown |  |
| approve_date | Unknown |  |
| image_description | Unknown |  |
| image_url | Unknown |  |
| operating_cost | Unknown |  |
| performance_summary | Unknown |  |
| program_category_1 | Unknown |  |
| program_category_2 | Unknown |  |
| program_end_date | Unknown |  |
| program_name | Unknown |  |
| program_start_date | Unknown |  |
| program_unit_1 | Unknown |  |
| program_unit_2 | Unknown |  |
| program_unit_3 | Unknown |  |
| program_unit_detail | Unknown |  |
| project_cost | Unknown |  |
| quantitative_performance_1 | Unknown |  |
| quantitative_performance_2 | Unknown |  |

### grants

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| apply_code | Unknown |  |
| apply_price | Unknown |  |
| bank_account | Unknown |  |
| bank_account_owner | Unknown |  |
| bank_code | Unknown |  |
| business_no | Unknown |  |
| business_type | Unknown |  |
| expense_status | Unknown |  |
| fund_account_count | Unknown |  |
| fund_account_first_donor | Unknown |  |
| grantee_code | Unknown |  |
| grantee_email | Unknown |  |
| grantee_id | Unknown |  |
| grantee_name | Unknown |  |
| grantee_type | Unknown |  |
| pay_date | Unknown |  |
| paymethod_type | Unknown |  |
| person_birthday | Unknown |  |
| president_name | Unknown |  |
| program_name | Unknown |  |
| staff_cellphone | Unknown |  |

### promise

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| product_code | Unknown | PK, FK |
| member_id | Unknown | FK |
| code | Unknown |  |
| comment | Unknown |  |
| last_pay_date | Unknown |  |
| memo | Unknown |  |
| status | Unknown |  |
| total_pay_price | Unknown |  |

### member

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| active_date | Unknown |  |
| agree_email | Unknown |  |
| agree_post | Unknown |  |
| agree_tel | Unknown |  |
| agree_text | Unknown |  |
| cellphone | Unknown |  |
| code | Unknown |  |
| email | Unknown |  |
| lapse_date | Unknown |  |
| last_pay_date | Unknown |  |
| lifecycle | Unknown |  |
| name | Unknown |  |
| total_pay_count | Unknown |  |
| total_price | Unknown |  |

## Relationships

- payment(member_id) → member(id)
- payment(promise_id) → promise(id)
- payment(grantee_name) → grants(grantee_name)
- member_group(member_id) → member(id)
- grants_report(grantee_name) → grants(grantee_name)
- promise(member_id) → member(id)
- promise(product_code) → payment(product_code)