from sqlalchemy import Column, BigInteger, Float, Text
from sqlalchemy.ext.declarative import declarative_base

TokenBase = declarative_base()
ContractBase = declarative_base()
ContinuosContractBase = declarative_base()
SystemBase = declarative_base()
LatestCacheBase = declarative_base()

class ActiveTable(TokenBase):
    __tablename__ = "activeTable"

    id = Column('id', BigInteger, primary_key=True)
    address = Column('address', Text)
    parentid = Column('parentid', BigInteger)
    consumedpid = Column('consumedpid', Text)
    transferBalance = Column('transferBalance', Float)
    addressBalance = Column('addressBalance', Float)
    orphaned_parentid = Column('orphaned_parentid', BigInteger)
    blockNumber = Column('blockNumber', BigInteger)


class ConsumedTable(TokenBase):
    __tablename__ = "consumedTable"

    primaryKey = Column('primaryKey', BigInteger, primary_key=True)
    id = Column('id', BigInteger)
    address = Column('address', Text)
    parentid = Column('parentid', BigInteger)
    consumedpid = Column('consumedpid', Text)
    transferBalance = Column('transferBalance', Float)
    addressBalance = Column('addressBalance', Float)
    orphaned_parentid = Column('orphaned_parentid', BigInteger)
    blockNumber = Column('blockNumber', BigInteger)


class TransferLogs(TokenBase):
    __tablename__ = "transferlogs"

    primary_key = Column('id', BigInteger, primary_key=True)
    sourceFloAddress = Column('sourceFloAddress', Text)
    destFloAddress = Column('destFloAddress', Text)
    transferAmount = Column('transferAmount', Float)
    sourceId = Column('sourceId', BigInteger)
    destinationId = Column('destinationId', BigInteger)
    blockNumber = Column('blockNumber', BigInteger)
    time = Column('time', BigInteger)
    transactionHash = Column('transactionHash', Text)


class TransactionHistory(TokenBase):
    __tablename__ = "transactionHistory"

    primary_key = Column('id', BigInteger, primary_key=True)
    sourceFloAddress = Column('sourceFloAddress', Text)
    destFloAddress = Column('destFloAddress', Text)
    transferAmount = Column('transferAmount', Float)
    blockNumber = Column('blockNumber', BigInteger)
    blockHash = Column('blockHash', Text)
    time = Column('time', BigInteger)
    transactionHash = Column('transactionHash', Text)
    blockchainReference = Column('blockchainReference', Text)
    jsonData = Column('jsonData', Text)
    transactionType = Column('transactionType', Text)
    parsedFloData = Column('parsedFloData', Text)


class TokenContractAssociation(TokenBase):
    __tablename__ = "tokenContractAssociation"

    primary_key = Column('id', BigInteger, primary_key=True)
    tokenIdentification = Column('tokenIdentification', Text)
    contractName = Column('contractName', Text)
    contractAddress = Column('contractAddress', Text)
    blockNumber = Column('blockNumber', BigInteger)
    blockHash = Column('blockHash', Text)
    time = Column('time', BigInteger)
    transactionHash = Column('transactionHash', Text)
    blockchainReference = Column('blockchainReference', Text)
    jsonData = Column('jsonData', Text)
    transactionType = Column('transactionType', Text)
    parsedFloData = Column('parsedFloData', Text)


class ContractStructure(ContractBase):
    __tablename__ = "contractstructure"

    id = Column('id', BigInteger, primary_key=True)
    attribute = Column('attribute', Text)
    index = Column('index', BigInteger)
    value = Column('value', Text)


class ContractParticipants(ContractBase):
    __tablename__ = "contractparticipants"

    id = Column('id', BigInteger, primary_key=True)
    participantAddress = Column('participantAddress', Text)
    tokenAmount = Column('tokenAmount', Float)
    userChoice = Column('userChoice', Text)
    transactionHash = Column('transactionHash', Text)
    blockNumber = Column('blockNumber', BigInteger)
    blockHash = Column('blockHash', Text)
    winningAmount = Column('winningAmount', Float)


class ContractTransactionHistory(ContractBase):
    __tablename__ = "contractTransactionHistory"

    primary_key = Column('id', BigInteger, primary_key=True)
    transactionType = Column('transactionType', Text)
    transactionSubType = Column('transactionSubType', Text)
    sourceFloAddress = Column('sourceFloAddress', Text)
    destFloAddress = Column('destFloAddress', Text)
    transferAmount = Column('transferAmount', Float)
    blockNumber = Column('blockNumber', BigInteger)
    blockHash = Column('blockHash', Text)
    time = Column('time', BigInteger)
    transactionHash = Column('transactionHash', Text)
    blockchainReference = Column('blockchainReference', Text)
    jsonData = Column('jsonData', Text)
    parsedFloData = Column('parsedFloData', Text)


class ContractDeposits(ContractBase):
    __tablename__ = "contractdeposits"

    id = Column('id', BigInteger, primary_key=True)
    depositorAddress = Column('depositorAddress', Text)
    depositAmount = Column('depositAmount', Float)
    depositBalance = Column('depositBalance', Float)
    expiryTime = Column('expiryTime', Text)
    unix_expiryTime = Column('unix_expiryTime', BigInteger)
    status = Column('status', Text)
    transactionHash = Column('transactionHash', Text)
    blockNumber = Column('blockNumber', BigInteger)
    blockHash = Column('blockHash', Text)


class ConsumedInfo(ContractBase):
    __tablename__ = "consumedinfo"

    id = Column('id', BigInteger, primary_key=True)
    id_deposittable = Column('id_deposittable', BigInteger)
    transactionHash = Column('transactionHash', Text)
    blockNumber = Column('blockNumber', BigInteger)


class ContractWinners(ContractBase):
    __tablename__ = "contractwinners"

    id = Column('id', BigInteger, primary_key=True)
    participantAddress = Column('participantAddress', Text)
    winningAmount = Column('winningAmount', Float)
    userChoice = Column('userChoice', Text)
    transactionHash = Column('transactionHash', Text)
    blockNumber = Column('blockNumber', BigInteger)
    blockHash = Column('blockHash', Text)
    referenceTxHash = Column('referenceTxHash', Text)

class ContractStructure2(ContinuosContractBase):
    __tablename__ = "contractstructure"

    id = Column('id', BigInteger, primary_key=True)
    attribute = Column('attribute', Text)
    index = Column('index', BigInteger)
    value = Column('value', Text)


class ContractParticipants2(ContinuosContractBase):
    __tablename__ = "contractparticipants"

    id = Column('id', BigInteger, primary_key=True)
    participantAddress = Column('participantAddress', Text)
    tokenAmount = Column('tokenAmount', Float)
    transactionHash = Column('transactionHash', Text)
    blockNumber = Column('blockNumber', BigInteger)
    blockHash = Column('blockHash', Text)


class ContractDeposits2(ContinuosContractBase):
    __tablename__ = "contractdeposits"

    id = Column('id', BigInteger, primary_key=True)
    depositorAddress = Column('depositorAddress', Text)
    depositAmount = Column('depositAmount', Float)
    expiryTime = Column('expiryTime', Text)
    status = Column('status', Text)
    transactionHash = Column('transactionHash', Text)
    blockNumber = Column('blockNumber', BigInteger)
    blockHash = Column('blockHash', Text)


class ContractTransactionHistory2(ContinuosContractBase):
    __tablename__ = "contractTransactionHistory"

    primary_key = Column('id', BigInteger, primary_key=True)
    transactionType = Column('transactionType', Text)
    transactionSubType = Column('transactionSubType', Text)
    sourceFloAddress = Column('sourceFloAddress', Text)
    destFloAddress = Column('destFloAddress', Text)
    transferAmount = Column('transferAmount', Float)
    blockNumber = Column('blockNumber', BigInteger)
    blockHash = Column('blockHash', Text)
    time = Column('time', BigInteger)
    transactionHash = Column('transactionHash', Text)
    blockchainReference = Column('blockchainReference', Text)
    jsonData = Column('jsonData', Text)
    parsedFloData = Column('parsedFloData', Text)


class ActiveContracts(SystemBase):
    __tablename__ = "activecontracts"

    id = Column('id', BigInteger, primary_key=True)
    contractName = Column('contractName', Text)
    contractAddress = Column('contractAddress', Text)
    status = Column('status', Text)
    tokenIdentification = Column('tokenIdentification', Text)
    contractType = Column('contractType', Text)
    transactionHash = Column('transactionHash', Text)
    blockNumber = Column('blockNumber', BigInteger)
    blockHash = Column('blockHash', Text)
    incorporationDate = Column('incorporationDate', Text)
    expiryDate = Column('expiryDate', Text)
    closeDate = Column('closeDate', Text)


class SystemData(SystemBase):
    __tablename__ = "systemData"

    id = Column('id', BigInteger, primary_key=True)
    attribute = Column('attribute', Text)
    value = Column('value', Text)

class ContractAddressMapping(SystemBase):
    __tablename__ = "contractAddressMapping"

    id = Column('id', BigInteger, primary_key=True)
    address = Column('address', Text)
    addressType = Column('addressType', Text)
    contractName = Column('contractName', Text)
    contractAddress = Column('contractAddress', Text)
    tokenAmount = Column('tokenAmount', Float)
    transactionHash = Column('transactionHash', Text)
    blockNumber = Column('blockNumber', BigInteger)
    blockHash = Column('blockHash', Text)

class TokenAddressMapping(SystemBase):
    __tablename__ = "tokenAddressMapping"

    id = Column('id', BigInteger, primary_key=True)
    tokenAddress = Column('tokenAddress', Text)
    token = Column('token', Text)
    transactionHash = Column('transactionHash', Text)
    blockNumber = Column('blockNumber', BigInteger)
    blockHash = Column('blockHash', Text)

class DatabaseTypeMapping(SystemBase):
    __tablename__ = "databaseTypeMapping"

    id = Column('id', BigInteger, primary_key=True)
    db_name = Column('db_name', Text)
    db_type = Column('db_type', Text)
    keyword = Column('keyword', Text)
    object_format = Column('object_format', Text)
    blockNumber = Column('blockNumber', BigInteger)


class TimeActions(SystemBase):
    __tablename__ = "time_actions"

    id = Column('id', BigInteger, primary_key=True)
    time = Column('time', Text)
    activity = Column('activity', Text)
    status = Column('status', Text)
    contractName = Column('contractName', Text)
    contractAddress = Column('contractAddress', Text)
    contractType = Column('contractType', Text)
    tokens_db = Column('tokens_db', Text)
    parsed_data = Column('parsed_data', Text)
    transactionHash = Column('transactionHash', Text)
    blockNumber = Column('blockNumber', BigInteger)


class RejectedContractTransactionHistory(SystemBase):
    __tablename__ = "rejectedContractTransactionHistory"

    primary_key = Column('id', BigInteger, primary_key=True)
    transactionType = Column('transactionType', Text)
    transactionSubType = Column('transactionSubType', Text)
    contractName = Column('contractName', Text)
    contractAddress = Column('contractAddress', Text)
    sourceFloAddress = Column('sourceFloAddress', Text)
    destFloAddress = Column('destFloAddress', Text)
    transferAmount = Column('transferAmount', Float)
    blockNumber = Column('blockNumber', BigInteger)
    blockHash = Column('blockHash', Text)
    time = Column('time', BigInteger)
    transactionHash = Column('transactionHash', Text)
    blockchainReference = Column('blockchainReference', Text)
    jsonData = Column('jsonData', Text)
    rejectComment = Column('rejectComment', Text)
    parsedFloData = Column('parsedFloData', Text)


class RejectedTransactionHistory(SystemBase):
    __tablename__ = "rejectedTransactionHistory"

    primary_key = Column('id', BigInteger, primary_key=True)
    tokenIdentification = Column('tokenIdentification', Text)
    sourceFloAddress = Column('sourceFloAddress', Text)
    destFloAddress = Column('destFloAddress', Text)
    transferAmount = Column('transferAmount', Float)
    blockNumber = Column('blockNumber', BigInteger)
    blockHash = Column('blockHash', Text)
    time = Column('time', BigInteger)
    transactionHash = Column('transactionHash', Text)
    blockchainReference = Column('blockchainReference', Text)
    jsonData = Column('jsonData', Text)
    rejectComment = Column('rejectComment', Text)
    transactionType = Column('transactionType', Text)
    parsedFloData = Column('parsedFloData', Text)

class LatestTransactions(LatestCacheBase):
    __tablename__ = "latestTransactions"

    id = Column('id', BigInteger, primary_key=True)
    transactionHash = Column('transactionHash', Text)
    blockNumber = Column('blockNumber', BigInteger)
    jsonData = Column('jsonData', Text)
    transactionType = Column('transactionType', Text)
    parsedFloData = Column('parsedFloData', Text)
    db_reference = Column('db_reference', Text)


class LatestBlocks(LatestCacheBase):
    __tablename__ = "latestBlocks"

    id = Column('id', BigInteger, primary_key=True)
    blockNumber = Column('blockNumber', BigInteger)
    blockHash = Column('blockHash', Text)
    jsonData = Column('jsonData', Text)


class RecentBlocks(LatestCacheBase):
    __tablename__ = "RecentBlocks"

    id = Column(BigInteger, primary_key=True, autoincrement=True)
    blockNumber = Column(BigInteger, unique=True, nullable=False)
    blockHash = Column(Text, nullable=False)