Donus
Explore the interactive ERD
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 | PKFK |
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 | PKFK |
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 |