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)