db

type AccountStatus string

type AreaUnit string

type Base struct {
	ID        uint `gorm:"primaryKey"`
	CreatedAt time.Time
	UpdatedAt time.Time
	DeletedAt gorm.DeletedAt `gorm:"index"`
}

type Claims struct {
	Role string `json:"role"`
	jwt.StandardClaims
}

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
	User   PdmUser

	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
}

type PdmModel struct {
	Base
	ModelNumber          int
	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

	UserID uint
	User   PdmUser

	ItemID uint
	Item   PdmItem

	MaterialID uint
	Material   PdmMaterial `gorm:"foreignKey:MaterialID;references:ID"`
}

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 PdmUser struct {
	Base

	LoginName          string         `gorm:"column:login_name;type:varchar(30);not null;uniqueIndex"`
	FullName           string         `gorm:"type:varchar(61)"`
	PasswordHash       string         `gorm:"type:varchar(60);not null"`
	MustChangePassword bool           `gorm:"default:true"`
	FirstName          string         `gorm:"type:varchar(30)"`
	LastName           string         `gorm:"type:varchar(30)"`
	DateOfBirth        time.Time      `gorm:"type:date"`
	Sex                string         `gorm:"type:varchar(10)"` // "male", "female", or "x"
	EmailAddress       string         `gorm:"type:varchar(255);not null;uniqueIndex"`
	PhoneNumber        string         `gorm:"type:varchar(20)"`
	Department         string         `gorm:"type:varchar(30)"`
	PhotoPath          string         `gorm:"type:varchar(255)"`
	AccountStatus      string         `gorm:"type:varchar(20);default:'active'"`
	Roles              pq.StringArray `gorm:"type:text[]"`
}

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 Project struct {
	gorm.Model
	ID          uint   `gorm:"primaryKey"`
	ProjectName string `gorm:"size:100"`
	// contains filtered or unexported fields
}

type ProjectState string

type RBAC string

type ReleaseStates struct {
}

type RevisionState string

type Role string

type RoleList []Role

type Search struct {
}

type SearchItem struct {
}

type SearchProject struct {
}

type SearchUser struct {
}

type Session struct {
	Username   string
	Expiration time.Time
}

type TracebilityState string

type UserRepo struct {
	DB *gorm.DB
}

type VolumeUnit string

type WeightUnit string