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