credit_card

48 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 null
transactions.card_id fk_transactions_card_id R
guest_id int4 10 null
guest.id fk_credit_card_guest_id C
card_number text 2147483647 null
card_type text 2147483647 null
expire_month int2 5 null
expire_year int2 5 null
encrypted text 2147483647 null

Indexes

Constraint Name Type Sort Column(s)
credit_card_pkey Primary key Asc id
idx_credit_card_guest_id Performance Asc guest_id

Relationships