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`