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 |