Skip to content

Instantly share code, notes, and snippets.

@j-bennet
Created November 25, 2019 03:52
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
Star You must be signed in to star a gist
Save j-bennet/f3a9311aaceba79616bd0753451d7b1e to your computer and use it in GitHub Desktop.
mysql root@localhost:sakila> describe payment
+--------------+----------------------+------+-----+-------------------+-----------------------------------------------+
| Field | Type | Null | Key | Default | Extra |
+--------------+----------------------+------+-----+-------------------+-----------------------------------------------+
| payment_id | smallint(5) unsigned | NO | PRI | <null> | auto_increment |
| customer_id | smallint(5) unsigned | NO | MUL | <null> | |
| staff_id | tinyint(3) unsigned | NO | MUL | <null> | |
| rental_id | int(11) | YES | MUL | <null> | |
| amount | decimal(5,2) | NO | | <null> | |
| payment_date | datetime | NO | | <null> | |
| last_update | timestamp | YES | | CURRENT_TIMESTAMP | DEFAULT_GENERATED on update CURRENT_TIMESTAMP |
+--------------+----------------------+------+-----+-------------------+-----------------------------------------------+
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment