gistfile1.py

class Posts(Base):

    __tablename__ = 'posts'
    post_id = Column(Integer, primary_key=True)
    #user_id = Column(Integer, ForeignKey('users.user_id'))
    client_id = Column(Integer, ForeignKey('clients.client_id'))
    assignment_id = Column(Integer, ForeignKey('assignments.assignment_id'))
    #title = Column(Text)
    post_datetime = Column(DateTime)
    language_id = Column(Integer, ForeignKey('languages.language_id'))
    deleted = Column(Boolean)
    lat = Column(Float)
    lng = Column(Float)

class Assignments(Base):

    __tablename__ = 'assignments'
    assignment_id = Column(Integer, primary_key=True)
    user_id = Column(Integer, ForeignKey('users.user_id'))
    publish_datetime = Column(DateTime)
    expire_datetime = Column(DateTime)
    name = Column(Text)
    #assignment_unique_id = Column(Text)
    top_left_lat = Column(Float)
    top_left_lng = Column(Float)
    bottom_right_lat = Column(Float)
    bottom_right_lng = Column(Float)
    use_fence = Column(Boolean)
    collection_id = Column(Integer, ForeignKey('collections.collection_id'), nullable=True)

class MediaObjects(Base):

    __tablename__ = 'mediaobjects'
    media_object_id = Column(Integer, primary_key=True)
    #user_id = Column(Integer, ForeignKey('users.user_id'))
    client_id = Column(Integer, ForeignKey('clients.client_id'))
    media_type_id = Column(Integer, ForeignKey('mediatypes.media_type_id'))
    media_id = Column(Text)
    file_name = Column(Text)
    caption = Column(Text)
    media_text = Column(Text)

class Clients(Base):

    __tablename__ = 'clients'
    client_id = Column(Integer, primary_key=True)
    cuid = Column(Text)
    first_name = Column(Text, nullable=True)
    last_name = Column(Text, nullable=True)
    email = Column(Text, nullable=True)
    passhash = Column(Text, nullable=True)
    passsalt = Column(Text, nullable=True)
    verified = Column(Boolean)
    verified_datetime = Column(DateTime, nullable=True)
    creation_datetime = Column(DateTime)
    last_check_in_datetime = Column(DateTime)
    home_zipcode_id = Column(Integer, ForeignKey('zipcodes.zipcode_id'))
    last_lat = Column(Float)
    last_lng = Column(Float)
    post_view_count = Column(Integer)
    post_used_count = Column(Integer)

class Languages(Base):

    __tablename__ = 'languages'
    language_id = Column(Integer, primary_key=True)
    language_code = Column(Text)
    name = Column(Text)