Labgenie
Tables (20)
Announcement
- AnnouncementId — INT — Primary key — NOT NULL
- UserEmail — VARCHAR(45) — Foreign key → User.Email — NOT NULL
- Key — Foreign key — NOT NULL
- Title — VARCHAR(45) — NOT NULL
- Content — VARCHAR(45) — NOT NULL
- CreatedDate — VARCHAR(45) — NOT NULL
- INDEX — `fk_Announcement_User_idx`
CabinetLocation
- CabinetId — INT — Foreign key → CabinetType.TypeId — NOT NULL
- Position — VARCHAR(10)
CabinetType
- TypeId — INT — Primary key — NOT NULL
- TypeName — VARCHAR(45)
Chemical
- CASNo — VARCHAR(20) — Primary key — NOT NULL
- NameKor — VARCHAR(45)
- NameEng — VARCHAR(45)
- ChemicalSymbol — VARCHAR(45)
- Unit — VARCHAR(45)
- Amount — VARCHAR(45)
- Quantity — VARCHAR(45)
- Purity — VARCHAR(45)
- ExpiryDate — VARCHAR(45)
- Opened — VARCHAR(45)
- Remark — VARCHAR(45)
- CabinetId — INT — Foreign key → CabinetLocation.CabinetId — NOT NULL
- ManufacturerId — INT — Foreign key → ChemicalManufacturer.ManufacturerId — NOT NULL
- GHSId — VARCHAR(45) — Foreign key → GHS.GHSId — NOT NULL
- LabId — INT — Foreign key → Lab.LabId — NOT NULL
- INDEX — `fk_Chemical_CabinetLocation_idx`
- INDEX — `fk_Chemical_Manufacturer_idx`
- INDEX — `fk_Chemical_GHS_idx`
- INDEX — `fk_Chemical_Lab_idx`
ChemicalGrade
- GradeName — VARCHAR(10) — Primary key — NOT NULL
- Content — VARCHAR(45)
ChemicalManufacturer
- ManufacturerId — INT — Primary key — NOT NULL
- Name — VARCHAR(45)
ChemicalOrder
- OrderId — INT — Primary key — NOT NULL
- ResearcherId — INT — Foreign key → User.ResearcherId — NOT NULL
- ManufacturerId — INT — Foreign key → ChemicalManufacturer.ManufacturerId — NOT NULL
- OrderDetails — VARCHAR(45)
- INDEX — `fk_ChemicalOrder_User_idx`
- INDEX — `fk_ChemicalOrder_Manufacturer_idx`
ChemicalReceiving
- OrderId — INT — Foreign key → ChemicalOrder.OrderId — NOT NULL
- Key — Foreign key — NOT NULL
- ReceivingDate — DATE — NOT NULL
- Receiver — VARCHAR(45) — NOT NULL
CompressedGas
- NameKor — VARCHAR(45) — Primary key — NOT NULL
- NameEng — VARCHAR(45)
- ChemicalSymbol — VARCHAR(45)
- Capacity — VARCHAR(45)
- Quantity — VARCHAR(45)
- CategoryId — INT — Foreign key → GasCategory.CategoryId — NOT NULL
- LabId — INT — Foreign key → Lab.LabId — NOT NULL
- INDEX — `fk_CompressedGas_Category_idx`
- INDEX — `fk_CompressedGas_Lab_idx`
Equipment
- EquipmentId — INT — Primary key — NOT NULL
- NameKor — VARCHAR(45)
- NameEng — VARCHAR(45)
- ModelName — VARCHAR(45) — Assigned name by the company
- TypeCode — INT — Foreign key → EquipmentType.TypeCode — NOT NULL
- Description — VARCHAR(45)
- Configuration — VARCHAR(45)
- Specification — VARCHAR(45)
- Image — VARCHAR(45)
- LabId — INT — Foreign key → Lab.LabId — NOT NULL
- INDEX — `fk_Equipment_Type_idx`
- INDEX — `fk_Equipment_Lab_idx`
EquipmentType
- TypeCode — INT — Primary key — NOT NULL
- TypeName — VARCHAR(45)
GHS
- GHSId — VARCHAR(45) — Primary key — NOT NULL
- LabelId — INT — Foreign key → GHSLabel.LabelId — NOT NULL
- WordId — INT — Foreign key → SignalWord.WordId — NOT NULL
- StatementId — VARCHAR(10) — Foreign key → HazardStatement.StatementId — NOT NULL
- INDEX — `fk_GHS_Label_idx`
- INDEX — `fk_GHS_Word_idx`
- INDEX — `fk_GHS_Statement_idx`
GHSLabel
- LabelId — INT — Primary key — NOT NULL
- Image — VARCHAR(45)
GasCategory
- CategoryId — INT — Primary key — NOT NULL
- CategoryName — VARCHAR(45)
HazardStatement
- StatementId — VARCHAR(10) — Primary key — NOT NULL
- Content — VARCHAR(200)
Lab
- LabId — INT — Primary key — NOT NULL
- LabLocation — VARCHAR(45)
Position
- PositionCode — INT — Primary key — NOT NULL
- Key — Primary key — NOT NULL
- PositionName — VARCHAR(10) — NOT NULL
- IsAdmin — VARCHAR(45) — NOT NULL
SignalWord
- WordId — INT — Primary key — NOT NULL
- Content — VARCHAR(10)
UsageHistory
- UsageId — INT — Primary key — NOT NULL
- UserId — VARCHAR(20) — Primary key — NOT NULL
- GasId — INT — Primary key — NOT NULL
- ResearcherId — INT — Foreign key → User.ResearcherId — NOT NULL
- EquipmentId — INT — Foreign key → Equipment.EquipmentId — NOT NULL
- ChemicalCASNo — VARCHAR(20) — Foreign key → Chemical.CASNo — NOT NULL
- UsageTime — VARCHAR(45)
- UsedAmount — VARCHAR(45)
- Content — VARCHAR(45)
- INDEX — `fk_UsageHistory_User_idx`
- INDEX — `fk_UsageHistory_Equipment_idx`
- INDEX — `fk_UsageHistory_Chemical_idx`
User
- Email — VARCHAR(45) — Primary key — NOT NULL
- ResearcherId — INT
- Password — VARCHAR(45)
- Name — VARCHAR(45)
- PhoneNumber — VARCHAR(45)
- PositionCode — INT — Foreign key → Position.PositionCode — NOT NULL
- LabId — INT — Foreign key → Lab.LabId — NOT NULL
- INDEX — `fk_User_Position_idx`
- INDEX — `fk_User_Lab_idx`