from api import db

# DB model for relation (id, screen_name). One-to-One mapping of unique ids with screen_name
class Screen(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(50), unique=True)

# DB model for relation (id, number_of_seats, aisle_seats, reserved_seats)
# This relation stores the details of each row of a screen.
# id is a unique id made of "screen_id + row_alphabet"
class Row(db.Model):
    id = db.Column(db.String(10), primary_key=True)
    number_of_seats = db.Column(db.Integer)
    aisle_seats = db.Column(db.String)
    reserved_seats = db.Column(db.String)