Fields
Name |
Engine |
Collation |
Row Count |
Data Length |
Last Inserted Id |
Comment |
Average Row Length |
Row Format |
Created |
Updated |
Table Name |
Name |
Data Type |
Primary Key |
Unique |
Required |
Autoincrement |
Charset |
Collation |
Comment |
payment
|
payment_id
|
smallint(5) unsigned
|
|
|
|
|
NULL
|
NULL
|
|
payment
|
customer_id
|
smallint(5) unsigned
|
|
|
|
|
NULL
|
NULL
|
|
payment
|
staff_id
|
tinyint(3) unsigned
|
|
|
|
|
NULL
|
NULL
|
|
payment
|
rental_id
|
int(11)
|
|
|
|
|
NULL
|
NULL
|
|
payment
|
amount
|
decimal(5,2)
|
|
|
|
|
NULL
|
NULL
|
|
payment
|
payment_date
|
datetime
|
|
|
|
|
NULL
|
NULL
|
|
payment
|
last_update
|
timestamp
|
|
|
|
|
NULL
|
NULL
|
|