Enum TableConstraint 

pub enum TableConstraint {
    Unique(UniqueConstraint),
    PrimaryKey(PrimaryKeyConstraint),
    ForeignKey(ForeignKeyConstraint),
    Check(CheckConstraint),
    Index(IndexConstraint),
    FulltextOrSpatial(FullTextOrSpatialConstraint),
    PrimaryKeyUsingIndex(ConstraintUsingIndex),
    UniqueUsingIndex(ConstraintUsingIndex),
}

A table-level constraint, specified in a CREATE TABLE or an ALTER TABLE ADD <constraint> statement.

Variants

Unique(UniqueConstraint)

MySQL definition for UNIQUE constraints statements:\

• [CONSTRAINT [<name>]] UNIQUE <index_type_display> [<index_name>] [index_type] (<columns>) <index_options>

where:

• index_type is USING {BTREE | HASH}
• index_options is {index_type | COMMENT 'string' | ... %currently unsupported stmts% } ...
• index_type_display is [INDEX | KEY]

PrimaryKey(PrimaryKeyConstraint)

MySQL definition for PRIMARY KEY constraints statements:\

• [CONSTRAINT [<name>]] PRIMARY KEY [index_name] [index_type] (<columns>) <index_options>

Actually the specification have no [index_name] but the next query will complete successfully:

CREATE TABLE unspec_table (
  xid INT NOT NULL,
  CONSTRAINT p_name PRIMARY KEY index_name USING BTREE (xid)
);

where:

• index_type is USING {BTREE | HASH}
• index_options is {index_type | COMMENT 'string' | ... %currently unsupported stmts% } ...

ForeignKey(ForeignKeyConstraint)

A referential integrity constraint ([ CONSTRAINT <name> ] FOREIGN KEY (<columns>) REFERENCES <foreign_table> (<referred_columns>) { [ON DELETE <referential_action>] [ON UPDATE <referential_action>] | [ON UPDATE <referential_action>] [ON DELETE <referential_action>] }).

Check(CheckConstraint)

[ CONSTRAINT <name> ] CHECK (<expr>) [[NOT] ENFORCED]

Index(IndexConstraint)

MySQLs index definition for index creation. Not present on ANSI so, for now, the usage is restricted to MySQL, as no other dialects that support this syntax were found.

{INDEX | KEY} [index_name] [index_type] (key_part,...) [index_option]...

FulltextOrSpatial(FullTextOrSpatialConstraint)

MySQLs fulltext definition. Since the SPATIAL definition is exactly the same, and MySQL displays both the same way, it is part of this definition as well.

Supported syntax:

{FULLTEXT | SPATIAL} [INDEX | KEY] [index_name] (key_part,...)

key_part: col_name

PrimaryKeyUsingIndex(ConstraintUsingIndex)

PostgreSQL definition for promoting an existing unique index to a PRIMARY KEY constraint:

[ CONSTRAINT constraint_name ] PRIMARY KEY USING INDEX index_name [ DEFERRABLE | NOT DEFERRABLE ] [ INITIALLY DEFERRED | INITIALLY IMMEDIATE ]

UniqueUsingIndex(ConstraintUsingIndex)

PostgreSQL definition for promoting an existing unique index to a UNIQUE constraint:

[ CONSTRAINT constraint_name ] UNIQUE USING INDEX index_name [ DEFERRABLE | NOT DEFERRABLE ] [ INITIALLY DEFERRED | INITIALLY IMMEDIATE ]

Trait Implementations

impl Clone for TableConstraint

fn clone(&self) -> TableConstraint

Returns a duplicate of the value.

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source.

impl Debug for TableConstraint

fn fmt(&self, f: &mut Formatter<'_>) -> Result<(), Error>

Formats the value using the given formatter.

impl Display for TableConstraint

fn fmt(&self, f: &mut Formatter<'_>) -> Result<(), Error>

Formats the value using the given formatter.

impl Eq for TableConstraint

impl From<CheckConstraint> for TableConstraint

fn from(constraint: CheckConstraint) -> TableConstraint

Converts to this type from the input type.

impl From<ForeignKeyConstraint> for TableConstraint

fn from(constraint: ForeignKeyConstraint) -> TableConstraint

Converts to this type from the input type.

impl From<FullTextOrSpatialConstraint> for TableConstraint

fn from(constraint: FullTextOrSpatialConstraint) -> TableConstraint

Converts to this type from the input type.

impl From<IndexConstraint> for TableConstraint

fn from(constraint: IndexConstraint) -> TableConstraint

Converts to this type from the input type.

impl From<PrimaryKeyConstraint> for TableConstraint

fn from(constraint: PrimaryKeyConstraint) -> TableConstraint

Converts to this type from the input type.

impl From<UniqueConstraint> for TableConstraint

fn from(constraint: UniqueConstraint) -> TableConstraint

Converts to this type from the input type.

impl Hash for TableConstraint

fn hash<__H>(&self, state: &mut __H)

where __H: Hasher,

Feeds this value into the given Hasher.

fn hash_slice<H>(data: &[Self], state: &mut H)

where H: Hasher, Self: Sized,

Feeds a slice of this type into the given Hasher.

impl Ord for TableConstraint

fn cmp(&self, other: &TableConstraint) -> Ordering

This method returns an Ordering between self and other.

fn max(self, other: Self) -> Self

where Self: Sized,

Compares and returns the maximum of two values.

fn min(self, other: Self) -> Self

where Self: Sized,

Compares and returns the minimum of two values.

fn clamp(self, min: Self, max: Self) -> Self

where Self: Sized,

Restrict a value to a certain interval.

impl PartialEq for TableConstraint

fn eq(&self, other: &TableConstraint) -> bool

Tests for self and other values to be equal, and is used by ==.

fn ne(&self, other: &Rhs) -> bool

Tests for !=. The default implementation is almost always sufficient, and should not be overridden without very good reason.

impl PartialOrd for TableConstraint

fn partial_cmp(&self, other: &TableConstraint) -> Option<Ordering>

This method returns an ordering between self and other values if one exists.

fn lt(&self, other: &Rhs) -> bool

Tests less than (for self and other) and is used by the < operator.

fn le(&self, other: &Rhs) -> bool

Tests less than or equal to (for self and other) and is used by the <= operator.

fn gt(&self, other: &Rhs) -> bool

Tests greater than (for self and other) and is used by the > operator.

fn ge(&self, other: &Rhs) -> bool

Tests greater than or equal to (for self and other) and is used by the >= operator.

impl Spanned for TableConstraint

fn span(&self) -> Span

Return the Span (the minimum and maximum Location) for this AST node, by recursively combining the spans of its children.

impl StructuralPartialEq for TableConstraint

impl Visit for TableConstraint

fn visit<V>(&self, visitor: &mut V) -> ControlFlow<<V as Visitor>::Break>

where V: Visitor,

Visit this node with the provided Visitor.

impl VisitMut for TableConstraint

fn visit<V>(&mut self, visitor: &mut V) -> ControlFlow<<V as VisitorMut>::Break>

where V: VisitorMut,

Mutably visit this node with the provided VisitorMut.