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)