| Previous: cost_struct_pool_rate | Unanet Data Model | Next: criteria_set |
| Column Name | Data Type | Default Value |
References Table |
Foreign Key Name |
||
| 1. | PK | credit_card_key | decimal(15) | |||
| 2. | person_key | decimal(15) | person | fk_credit_card1 | ||
| 3. | name | varchar(128) | ||||
| 4. | vendor | varchar(64) | ||||
| 5. | card_number | varchar(32) | ||||
| 6. | card_type | varchar(32) | ||||
| 7. | exp_date | varchar(10) | ||||
| 8. | display | varchar(32) | ||||
| Column | References | Foreign Key Name | |
| Table | Column | ||
| person_key | person | person_key | fk_credit_card1 |
| Index Name | Unique | Column Name | Asc Or Desc |
| pk_credit_card | true | credit_card_key | Asc |
| idx_credit_card1 | true | person_key | Asc |
| card_number |