db

type AreaUnit string

type Base struct {
	ID uint `gorm:"primaryKey"`
}

type DataBasePostgreSQL struct {
	*DatabaseGen
}

type Database struct {
	Engine *gorm.DB
}

type DatabaseGen struct {
	DriverName   string
	Username     string
	Password     string
	Host         string
	Port         int
	DatabaseName string
	Engine       *gorm.DB
}

type DensityUnit string

type Document struct {
}

type FileSystem struct{}

type Item struct {
	gorm.Model
	ID       uint   `gorm:"primaryKey"`
	ItemName string `gorm:"size:100"`
	// number          int
	Project         string
	Path            string
	Name            string
	Description     string
	FullDescription string
}

type Model struct {
}

type OwnerStates struct {
}

type PdmDocument struct {
	Base
	DocumentNumber          int    // Or string?
	DocumentName            string `gorm:"type:varchar(32)"`
	DocumentDescription     string `gorm:"type:varchar(32)"`
	DocumentFullDescription string
	DocumentFilename        string `gorm:"type:varchar(253);not null"`
	DocumentExt             string `gorm:"type:varchar(253);not null"`

	UserID uint    `gorm:"foreignKey:UserID"`
	User   PdmUser `gorm:"foreignKey:UserID"`
	ItemID uint    `gorm:"foreignKey:ItemID"`
	Item   PdmItem `gorm:"foreignKey:ItemID"`
}

type PdmHistory struct {
	Base
	HistoryDateCreated    *time.Time
	HistoryCreatedBy      string
	HistoryDateLastEdit   *time.Time
	HistoryLastEditBy     string
	HistoryCheckedOutBy   string
	HistoryRevisionState  string // Enum can be defined later
	HistoryRevisionNumber int
	HistoryStoredNumber   int
}

type PdmItem struct {
	Base
	ItemNumber            string `gorm:"type:varchar(16)"`
	ItemName              string `gorm:"type:varchar(32)"`
	ItemDescription       string `gorm:"type:varchar(32)"`
	ItemFullDescription   string
	ItemNumberLinkedFiles int
	ItemPath              string `gorm:"not null"`
	ItemPreview           []byte // For LargeBinary

	UserID    uint          `gorm:"foreignKey:UserID"`
	User      PdmUser       `gorm:"foreignKey:UserID"`
	ProjectID uint          `gorm:"foreignKey:ProjectID"`
	Models    []PdmModel    `gorm:"foreignKey:ItemID"`
	Documents []PdmDocument `gorm:"foreignKey:ItemID"`
}

type PdmManufacturer struct {
	Base
	ManufacturerName string      `gorm:"type:varchar(32)"`
	PurchasingID     uint        `gorm:"foreignKey:PurchasingID"`
	Purchasing       PdmPurchase `gorm:"foreignKey:PurchasingID"`
}

type PdmMaterial struct {
	Base
	MaterialName            string `gorm:"type:varchar(32)"`
	MaterialFinish          string `gorm:"type:varchar(32)"`
	MaterialDensity         float64
	MaterialDensityUnit     string // Enum can be defined later
	MaterialVolume          float64
	MaterialVolumeUnit      string // Enum can be defined later
	MaterialWeight          float64
	MaterialWeightUnit      string // Enum can be defined later
	MaterialSurfaceArea     float64
	MaterialSurfaceAreaUnit string // Enum can be defined later

	// ModelID uint     `gorm:"foreignKey:ModelID"`
	// Model   PdmModel `gorm:"foreignKey:ModelID"`
	ItemID uint    `gorm:"foreignKey:ItemID"`
	Item   PdmItem `gorm:"foreignKey:ItemID"`
}

type PdmModel struct {
	Base
	ModelNumber          int    // Or string?
	ModelName            string `gorm:"type:varchar(32)"`
	ModelDescription     string `gorm:"type:varchar(32)"`
	ModelFullDescription string
	ModelFilename        string `gorm:"type:varchar(253);not null"`
	ModelExt             string `gorm:"type:varchar(253);not null"`
	ModelPreview         []byte // For LargeBinary

	UserID   uint        `gorm:"foreignKey:UserID"`
	User     PdmUser     `gorm:"foreignKey:UserID"`
	ItemID   uint        `gorm:"foreignKey:ItemID"`
	Item     PdmItem     `gorm:"foreignKey:ItemID"`
	Material PdmMaterial `gorm:"foreignKey:ModelID"`
}

type PdmProject struct {
	Base
	ProjectNumber     string `gorm:"type:varchar(16);not null"`
	ProjectName       string `gorm:"type:varchar(32)"`
	ProjectStatus     string // Enum type can be defined later
	ProjectDateStart  *time.Time
	ProjectDateFinish *time.Time
	ProjectPath       string

	Users []*PdmUser `gorm:"many2many:user_project_link"`
}

type PdmProjectItemLink struct {
	ProjectID uint `gorm:"primaryKey;autoIncrement:false"`
	ItemID    uint `gorm:"primaryKey;autoIncrement:false"`
}

type PdmPurchase struct {
	Base
	PurchasingSource       bool
	PurchasingTraceability string // Enum can be defined later

	ItemID         uint              `gorm:"foreignKey:ItemID"`
	Item           PdmItem           `gorm:"foreignKey:ItemID"`
	ManufacturerID uint              `gorm:"foreignKey:ManufacturerID"`
	Manufacturers  []PdmManufacturer `gorm:"foreignKey:ManufacturerID"`
	VendorID       uint              `gorm:"foreignKey:VendorID"`
	Vendors        []PdmVendor       `gorm:"foreignKey:VendorID"`
}

type PdmRole struct {
	Base
	RoleName string `gorm:"type:varchar(32)"`

	Users []*PdmUser `gorm:"many2many:user_role_link"`
}

type PdmUser struct {
	Base
	UserName         string `gorm:"type:varchar(30)"`
	UserFirstName    string `gorm:"type:varchar(30)"`
	UserLastName     string `gorm:"type:varchar(30)"`
	UserFullName     string
	UserEmailAddress string `gorm:"not null"`
	UserPhoneNumber  int    // Consider changing to string if phone numbers include characters
	UserDepartment   string // Enum type can be defined later

	Roles     []*PdmRole    `gorm:"many2many:user_role_link"`
	Projects  []*PdmProject `gorm:"many2many:user_project_link"`
	Items     []PdmItem     `gorm:"foreignKey:UserID"`
	Models    []PdmModel    `gorm:"foreignKey:UserID"`
	Documents []PdmDocument `gorm:"foreignKey:UserID"`
}

type PdmUserProjectLink struct {
	UserID    uint `gorm:"primaryKey;autoIncrement:false"`
	ProjectID uint `gorm:"primaryKey;autoIncrement:false"`
}

type PdmUserRoleLink struct {
	UserID uint `gorm:"primaryKey;autoIncrement:false"`
	RoleID uint `gorm:"primaryKey;autoIncrement:false"`
}

type PdmVendor struct {
	Base
	VendorName    string      `gorm:"type:varchar(32)"`
	VPurchasingID uint        `gorm:"foreignKey:VPurchasingID"`
	VPurchasing   PdmPurchase `gorm:"foreignKey:VPurchasingID"`
}

type Permission int

type Project struct {
	gorm.Model
	ID          uint   `gorm:"primaryKey"`
	ProjectName string `gorm:"size:100"`
	// contains filtered or unexported fields
}

type ProjectState string

type ReleaseStates struct {
}

type RevisionState string

type Role struct {
}

type Search struct {
}

type SearchItem struct {
}

type SearchProject struct {
}

type SearchUser struct {
}

type TempRole struct {
}

type TempUser struct {
}

type TracebilityState string

type User struct {
}

type UserAccount struct {
	ID   uint   `gorm:"primaryKey"`
	Name string `gorm:"size:100"`
}

type UserRole struct {
	ID       uint   `gorm:"primaryKey"`
	RoleName string `gorm:"size:100"`
}

type VolumeUnit string

type WeightUnit string