SELECT * FROM `TABLE_CONSTRAINTS`
|
CONSTRAINT_CATALOG | CONSTRAINT_SCHEMA | CONSTRAINT_NAME | TABLE_SCHEMA | TABLE_NAME | CONSTRAINT_TYPE | ENFORCED | |
---|---|---|---|---|---|---|---|
def | Lucas_test | account_name | Lucas_test | AccountType | UNIQUE | YES | |
def | Lucas_test | description | Lucas_test | AccountType | UNIQUE | YES | |
def | Lucas_test | PRIMARY | Lucas_test | Client | PRIMARY KEY | YES | |
def | Lucas_test | PRIMARY | Lucas_test | Currency | PRIMARY KEY | YES | |
def | Lucas_test | DocID | Lucas_test | IdentityDocumentType | UNIQUE | YES | |
def | Lucas_test | PRIMARY | Lucas_test | IdentityDocumentType | PRIMARY KEY | YES | |
def | Lucas_test | type | Lucas_test | IdentityDocumentType | UNIQUE | YES | |
def | Lucas_test | id | Lucas_test | PaymentStatus | UNIQUE | YES | |
def | Lucas_test | PRIMARY | Lucas_test | PaymentStatus | PRIMARY KEY | YES | |
def | Lucas_test | type | Lucas_test | PaymentStatus | UNIQUE | YES | |
def | Lucas_test | PRIMARY | Lucas_test | Product | PRIMARY KEY | YES | |
def | Lucas_test | id | Lucas_test | RepetitionRule | UNIQUE | YES | |
def | Lucas_test | PRIMARY | Lucas_test | RepetitionRule | PRIMARY KEY | YES | |
def | Lucas_test | type | Lucas_test | RepetitionRule | UNIQUE | YES | |
def | Lucas_test | PRIMARY | Lucas_test | StandingOrder | PRIMARY KEY | YES | |
def | Lucas_test | id | Lucas_test | TransactionKind | UNIQUE | YES | |
def | Lucas_test | PRIMARY | Lucas_test | TransactionKind | PRIMARY KEY | YES | |
def | Lucas_test | type | Lucas_test | TransactionKind | UNIQUE | YES | |
def | Lucas_test | id | Lucas_test | TransactionStatus | UNIQUE | YES | |
def | Lucas_test | PRIMARY | Lucas_test | TransactionStatus | PRIMARY KEY | YES | |
def | Lucas_test | type | Lucas_test | TransactionStatus | UNIQUE | YES | |
def | Lucas_test | id | Lucas_test | TransactionType | UNIQUE | YES | |
def | Lucas_test | PRIMARY | Lucas_test | TransactionType | PRIMARY KEY | YES | |
def | Lucas_test | type | Lucas_test | TransactionType | UNIQUE | YES | |
def | StdMdDB | PRIMARY | StdMdDB | course | PRIMARY KEY | YES |
|