CREDIT_CARD |
||||
| Column Name | Data Type | Nulls | References Table |
Foreign Key Name |
|---|---|---|---|---|
| credit_card_key | decimal (15,0) | |||
| person_key | decimal (15,0) | PERSON | fk_credit_card1 | |
| name | varchar (128) | YES | ||
| vendor | varchar (64) | YES | ||
| card_no | varchar (32) | |||
| card_type | varchar (32) | |||
| exp_date | varchar (10) | YES | ||
| display | varchar (32) | YES | ||
Indexes on CREDIT_CARD |
|
| Index Name | Column(s) |
|---|---|
| pk_credit_card | credit_card_key |