class Actor(Schema):
__tablename__ = 'actor'
actor_id = Number()
first_name = String(45)
last_name = String(45)
last_update = Timestamp()
class Film(Schema):
film_id = Integer()
title = String(255)
description = String()
release_year = Integer()
language_id = Number(5) # number of digits allowed
rental_duration = Number(2) # number of digits allowed
rental_rate = Number(4, 2) # number of digits allowed
length = Number()
replacement_cost = Number(5, 2)
rating = String()
last_update = Timestamp()
class Customer(Schema):
__tablename__ = 'staff'
customer_id = Integer()
store_id = Number(3)
first_name = String(45)
last_name = String(45)
email = String(50)
address_id = Integer(5)
activebool = Boolean()
create_date = Timestamp()
last_update = Timestamp()
active = Integer(2)
class Staff(Schema):
__tablename__ = 'staff'
staff_id = Integer()
first_name = String(45)
last_name = String(45)
address_id = Integer(5)
email = String(50)
store_id = Number(3)
active = Boolean()
username = String(16)
password = String(50)
last_update = Timestamp()
picture = Bytes()
class Account(Table):
identifier = UUID(default="uuid_generate_v1()", pk=True, required=True)
first_name = String(25)
last_name = String()
class Employee(Schema):
employee_id = Integer(pk=True)
manager_id = Integer(fk="employee.employee_id", use="smallint")
full_name = String()
created_at = Timestamp(tz="GMT+1")
class Chess(Table):
name = String()
class Play(Table):
name = String()
cryptic_name = String()
more_cryptic = String()
class Customers(Table):
identifier = String()
first_name = String()
last_name = String()
class Customer(Table):
name = String()
class cyberweek_sskuformat_competitive_data_raw(Schema):
matched_config_sku = String()
matched_simple_sku = String()
webshop_name = String()
country_code = String()
size_available = String()
size_last_update = String(alias="found")
size_identifier = String(alias="identifier")
size_price_current = Integer(alias="current_price")
current_date = Date(
alias="matching_date", default=datetime.now,
callback=datetime.now) # both will produce the same output
size_price_original = Integer()
product_url = String()
year = String()
month = String()
day = String()
class Play(Table):
age = Integer()
name = String()
cryptic_name = String()
more_cryptic = String()