maintenance
Tables (4)
maintenance
- ID (maNo) — nvarchar(11) — Primary key — NOT NULL
- ID (categoryID) — nvarchar(11)
- ID (contentID) — nvarchar(11)
- date (regDate) — datetime
- ID (regUserID) — nvarchar(20)
- date (chgDate) — datetime
- ID (chgUserID) — nvarchar(20)
- floor — nvarchar(5)
- status — nvarchar(5)
maintenance_accesslog
- seq — int — Primary key — NOT NULL
- ID (userID) — nvarchar(20)
- IP (ip) — nvarchar(50)
- url — nvarchar(256)
- parameter — nvarchar(max)
- date (accessDate) — datetime
maintenance_category
- ID (categoryID) — nvarchar(11) — Primary key — NOT NULL
- name (categoryName) — nvarchar(20)
- flag (useyn) — nvarchar(1)
- date (regDate) — datetime
- ID (regUserID) — nvarchar(20)
- date (chgDate) — datetime
- ID (chgUserID) — nvarchar(20)
maintenance_content
- ID (contentID) — nvarchar(11) — Primary key — NOT NULL
- filed (contentFiled) — nvarchar(100)
- date (regDate) — datetime
- ID (regUserID) — nvarchar(20)
- date (chgDate) — datetime
- ID (chgUserID) — nvarchar(20)