DB_RAG

Tables (16)

Untitled (Users)

  • Key (UserID) — INT — Primary key — NOT NULL
  • Field (Name) — VARCHAR(50)
  • Field (Password) — VARCHAR(50)

Untitled (SearchHistory)

  • Key (SearchID) — INT — Primary key — NOT NULL
  • Key (UserID) — INT — Foreign key → Untitled.Key — NOT NULL
  • Field (SearchTerm) — VARCHAR(50)
  • Field (SearchDate) — DATE

Untitled (ResultRecord)

  • Key (ResultID) — INT — Primary key — NOT NULL
  • Key (SearchID) — INT — Foreign key → Untitled.Key — NOT NULL
  • Field (GeneratedResult) — VARCHAR(200)
  • Field (GeneratedDate) — DATE

Untitled (LocalTax)

  • Key (TaxID) — INT — Primary key — NOT NULL
  • Field (TaxName) — VARCHAR(50)
  • Field (Description) — VARCHAR(200)

Untitled (LocalTaxDetail)

  • Key (DetailID) — INT — Primary key — NOT NULL
  • Key (TaxID) — INT — Foreign key → Untitled.Key — NOT NULL
  • Field (TaxBase) — VARCHAR(100)
  • Field (TaxRate) — DECIMAL(5, 2)
  • Field (PaymentTime) — VARCHAR(50)
  • Field (PaymentMethod) — VARCHAR(100)
  • Field (DeptContact) — VARCHAR(50)

Untitled (CivilService)

  • Key (ServiceID) — INT — Primary key — NOT NULL
  • Field (ServiceName) — VARCHAR(50)
  • Field (Description) — VARCHAR(200)

Untitled (CivilServiceDetail)

  • Key (DetailID) — INT — Primary key — NOT NULL
  • Key (ServiceID) — INT — Foreign key → Untitled.Key — NOT NULL
  • Field (ApplicationMethod) — VARCHAR(100)
  • Field (Department) — VARCHAR(50)
  • Field (NecessaryDocument) — VARCHAR(100)
  • Field (Commission) — DECIMAL(10, 2)
  • Field (SuspenseDate) — VARCHAR(50)

Untitled (LocalEvent)

  • Key (EventID) — INT — Primary key — NOT NULL
  • Field (EventName) — VARCHAR(100)
  • Field (Description) — VARCHAR(200)
  • Field (StartDate) — DATE
  • Field (EndDate) — DATE
  • Field (Location) — VARCHAR(100)
  • Field (Department) — VARCHAR(50)

Untitled (LocalNews)

  • Key (NewsID) — INT — Primary key — NOT NULL
  • Field (NewsDate) — DATE
  • Field2 (Title) — VARCHAR(100)
  • Field (Category) — VARCHAR(50)
  • Field (Content) — VARCHAR(200)
  • Field (Link) — VARCHAR(200)

Untitled (PublicFee)

  • Key (FeeID) — INT — Primary key — NOT NULL
  • Field (FeeName) — VARCHAR(100)
  • Field (FeeType) — VARCHAR(50)
  • Field (Unit) — VARCHAR(50)
  • Field (Fee) — DECIMAL(10, 2)

Untitled (PassportService)

  • Key (ServiceID) — INT — Primary key — NOT NULL
  • Field (ServiceName) — VARCHAR(100)
  • Field (Description) — VARCHAR(200)

Untitled (PassportServiceDetail)

  • Key (DetailID) — INT — Primary key — NOT NULL
  • Key (ServiceID) — INT — Foreign key → Untitled.Key — NOT NULL
  • Field (ApplicationMethod) — VARCHAR(50)
  • Field (NecessaryDocument) — VARCHAR(50)
  • Field (Commission) — DECIMAL(10, 2)
  • Field (DeptContact) — VARCHAR(50)

Untitled (PublicFacility)

  • Key (FacilityID) — INT — Primary key — NOT NULL
  • Field (FacilityName) — VARCHAR(50)
  • Field (FacilityType) — VARCHAR(50)

Untitled (PublicFacilityDetail)

  • Key (DetailID) — INT — Primary key — NOT NULL
  • Key (FacilityID) — INT — Foreign key → Untitled.Key — NOT NULL
  • Field (Location) — VARCHAR(100)
  • Field (OpeningTime) — VARCHAR(50)
  • Field (ClosingTime) — VARCHAR(50)
  • Field (Contact) — VARCHAR(50)

Untitled (CityHallDept)

  • Key (DeptID) — INT — Primary key — NOT NULL
  • Field (DeptName) — VARCHAR(50)
  • Field (AffiliatedDept) — VARCHAR(50)

Untitled (CityHallDeptDetail)

  • Key (DeptNumber) — INT — Primary key — NOT NULL
  • Key (DeptID) — INT — Foreign key → Untitled.Key — NOT NULL
  • Field (Task) — VARCHAR(100)
  • Field (OfficeLocation) — VARCHAR(50)
  • Field (DeptContact) — VARCHAR(50)