CS Project

Tables (5)

CultureData (컬쳐코드)

  • _cultureDataNo (Key) — int — Primary key — NOT NULL
  • _cultureCode (Field) — varchar(30)

ImageUrls (tiny 에디터 내 첨부되는 이미지)

  • _imageUrlsNo (Key) — int — Primary key — NOT NULL
  • _ownerType (Field5) — varchar
  • _ownerId (Field2) — int
  • _url (Field4) — varchar
  • _sortOrder (Field) — int

Maintenance (점검)

  • _maintenanceNo (Key) — int — Primary key — NOT NULL
  • _useType (Field) — bool
  • _maintenanceType (Field2) — bool
  • _startDate (Field3) — datetime2
  • _endDate (Field4) — datetime2
  • _adminTitle (Field5) — varchar
  • _adminDescription (Field6) — varchar
  • _tinyEditorContent (Field7) — text

ProductGroup (프로덕트 그룹)

  • _productGroupNo (Key) — int — Primary key — NOT NULL
  • _useType (Field) — tinyint
  • _adminTitle (Field2) — varchar(30)
  • _adminDescription (Field3) — varchar(255)
  • _orderNo (Field4) — int

ProductGroupName18n (프로덕트 그룹 이름 국제화)

  • productGroupName18nNo (Key) — int — Primary key — NOT NULL
  • _productGroupNo (Key2) — int — Foreign key → ProductGroup._productGroupNo — NOT NULL
  • _cultureDataNo (Key3) — int — Foreign key → CultureData._cultureDataNo — NOT NULL
  • _productGroupName (Field2) — varchar(255)
  • _displayType (Field) — tinyInt