Skip to content

Instantly share code, notes, and snippets.

@gmyrianthous

gmyrianthous/create_rental_table.sql

Created September 4, 2022 12:49
Show Gist options
  • Save gmyrianthous/c2bf0d542c3efba84f7d465919245195 to your computer and use it in GitHub Desktop.
Save gmyrianthous/c2bf0d542c3efba84f7d465919245195 to your computer and use it in GitHub Desktop.
Download ZIP
Example rental_table
Raw
create_rental_table.sql
DROP TABLE IF EXISTS rental;
CREATE TABLE rental (
id INTEGER PRIMARY KEY,
customer_id INTEGER NOT NULL,
store_id INTEGER NOT NULL,
amount FLOAT NOT NULL,
status VARCHAR(255) NOT NULL,
notes VARCHAR(255),
rental_date TIMESTAMP,
return_date TIMESTAMP
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment