sql

type DEFINITIONS struct {
	sq.TableStruct
	ID       sq.UUIDField   `ddl:"primarykey"`
	VALUE    sq.StringField `ddl:"notnull"`
	SENSE_ID sq.UUIDField   `ddl:"references=senses.id"`
	GROUP_ID sq.UUIDField   `ddl:"references=groups.id"`
}

type DICTIONARIES struct {
	sq.TableStruct
	ID   sq.UUIDField   `ddl:"primarykey"`
	NAME sq.StringField `ddl:"notnull"`
}

type ENTRIES struct {
	sq.TableStruct
	ID            sq.UUIDField `ddl:"primarykey"`
	CREATED_AT    sq.TimeField `ddl:"default=CURRENT_TIMESTAMP"`
	UPDATED_AT    sq.TimeField
	TERM          sq.StringField `ddl:"notnull"`
	DICTIONARY_ID sq.UUIDField   `ddl:"references=dictionaries.id"`
}

type ETYMOLOGIES struct {
	sq.TableStruct
	ID          sq.UUIDField `ddl:"primarykey"`
	DESCRIPTION sq.StringField
	ENTRY_ID    sq.UUIDField `ddl:"notnull references=entries.id"`
}

type EXAMPLES struct {
	sq.TableStruct
	ID            sq.StringField `ddl:"primarykey"`
	TEXT          sq.StringField `ddl:"notnull"`
	DEFINITION_ID sq.UUIDField   `ddl:"references=definitions.id"`
	NOTE_ID       sq.UUIDField   `ddl:"references=notes.id"`
}

type GROUPS struct {
	sq.TableStruct
	ID          sq.UUIDField `ddl:"primarykey"`
	DESCRIPTION sq.StringField
	SENSE_ID    sq.UUIDField `ddl:"notnull references=senses.id"`
}

type NOTES struct {
	sq.TableStruct
	ID            sq.UUIDField `ddl:"primarykey"`
	VALUE         sq.StringField
	DEFINITION_ID sq.UUIDField `ddl:"notnull references=definitions.id"`
}

type SENSES struct {
	sq.TableStruct
	ID           sq.UUIDField `ddl:"primarykey"`
	POS          sq.EnumField `ddl:"default='unknown'"`
	ETYMOLOGY_ID sq.UUIDField `ddl:"notnull references=etymologies.id"`
}

type SQLBuilder struct {
	// contains filtered or unexported fields
}

type SQLDialect = string