GENE

Tables (301)

APPROVALLINE

  • TitleCode — varchar(5) — Primary key — NOT NULL
  • TitleName — nvarchar(200)
  • TitleSeq — int
  • CodeUsable — varchar(2)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

ASSET

  • AssetCode — varchar(5) — Primary key — NOT NULL
  • AssetName — nvarchar(200)
  • AccountCode — varchar(4)
  • InvestCode — varchar(12)
  • PurchaseDate — varchar(10)
  • CustomerNo — varchar(10)
  • CustomerName — nvarchar(200)
  • DepartmentCode — varchar(10)
  • DepartmentName — nvarchar(200)
  • LocationCode — varchar(10)
  • DepreciationCode — varchar(3)
  • AccountingDuration — int
  • TaxDuration — int
  • DepreciationAccount — varchar(4)
  • Unit — nvarchar(50)
  • Quantity — decimal(28, 4)
  • UnitPrice — decimal(28, 4)
  • Amount — decimal(28, 4)
  • ValueAtEnd — decimal(28, 4)
  • Summary — nvarchar(400)
  • AccountingDepreciation — decimal(28, 4)
  • AccountBookValue — decimal(28, 4)
  • TaxDepreciation — decimal(28, 4)
  • TaxBookValue — decimal(28, 4)
  • DisposalAmount — decimal(28, 4)
  • DisposalMargin — decimal(28, 4)
  • HistoryCode — varchar(3)
  • Bookkeeping — varchar(2)
  • DocumentNo — varchar(20)
  • CollectionType — varchar(2)
  • RecordDate — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

ASSETHISTORY

  • HistoryId — bigint — Primary key — NOT NULL
  • AssetCode — varchar(50)
  • HistoryCode — varchar(3)
  • HistoryDate — varchar(50)
  • Reason — text
  • Bookkeeping — varchar(2)
  • RecordDate — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

ASSETHISTORYCODE

  • CodeId — int — Primary key — NOT NULL
  • HistoryCode — varchar(3)
  • HistoryName — nvarchar(200)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

ASSETLOCATION

  • LocationCode — varchar(3) — Primary key — NOT NULL
  • LocationName — nvarchar(200)
  • IsUsable — varchar(2)
  • RecordDate — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

AUTOACCOUNT

  • Idx — int — Primary key — NOT NULL
  • JobCode — varchar(3)
  • JobDescription — nvarchar(500)
  • DrCr — varchar(2)
  • AccountCode — varchar(4)
  • AccountName — nvarchar(200)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

AUTOACCOUNTTYPE

  • Idx — bigint — Primary key — NOT NULL
  • AutoCode — varchar(4)
  • AutoDescription — nvarchar(1000)
  • AccountCode — varchar(4)
  • AccountName — nvarchar(200)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

AUTOCREATECODE

  • CodeType — varchar(3) — Primary key — NOT NULL
  • Apply — varchar(2)
  • Code — varchar(25)
  • Number — decimal(28, 4)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

BANK

  • BankCode — varchar(5) — Primary key — NOT NULL
  • BankName — nvarchar(200)
  • CodeUsable — varchar(2)
  • RecordDate — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

BANKACCOUNTMANAGEMENT

  • BankingaccountId — varchar(5) — Primary key — NOT NULL
  • BkCode — varchar(5)
  • BkName — nvarchar(200)
  • BkAcctNo — varchar(70)
  • BkAcctPwd — varchar(100)
  • InetId — varchar(100)
  • InetPwd — nvarchar(100)
  • BusinessId — varchar(50)
  • RegisterDate — datetime
  • Message — nvarchar(200)
  • InstantlyTime — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

BANKDAUSERINF

  • BKUSERID — varchar(100) — Primary key — NOT NULL
  • BKUSERPWD — varchar(100)
  • SynBkCode — varchar(100)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

BANKDEPOSIT

  • Idx — bigint — Primary key — NOT NULL
  • BankingaccountId — varchar(5)
  • BankCode — varchar(5)
  • TransDate — varchar(10)
  • Sequence — bigint
  • Summary — nvarchar(300)
  • CashIn — decimal(28, 4)
  • CashOut — decimal(28, 4)
  • Balance — decimal(28, 4)
  • Content — nvarchar(300)
  • BranchName — nvarchar(300)
  • Clearance — varchar(2)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

BANKINGACCOUNT

  • BankingaccountId — varchar(5) — Primary key — NOT NULL
  • BankingaccountNumber — varchar(50)
  • AccountCode — varchar(5)
  • AccountName — nvarchar(200)
  • BankingaccountName — nvarchar(200)
  • BankingaccountCurrencyType — varchar(3)
  • BankingaccountMemo — ntext
  • IdUsable — varchar(2)
  • RecordDate — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

BEGINBALANCE

  • BalanceIdx — bigint — Primary key — NOT NULL
  • ApplyYear — varchar(4)
  • EntryDate — varchar(10)
  • Summary — nvarchar(500)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

BEGINBALANCEDETAIL

  • DetailIdx — bigint — Primary key — NOT NULL
  • BalanceIdx — bigint
  • AccountCode — varchar(4)
  • DrCr — varchar(2)
  • Amount — decimal(28, 4)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

BUDGET

  • BudIdx — bigint — Primary key — NOT NULL
  • RegistDate — varchar(10)
  • BudYear — varchar(4)
  • DepartmentCode — varchar(5)
  • DepartmentName — nvarchar(200)
  • Opinion — text
  • Approval — varchar(2)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

BUDGETADJUST

  • DocNo — varchar(15) — Primary key — NOT NULL
  • RequestDate — varchar(50)
  • RequestType — varchar(6)
  • DepartmentCode — varchar(10)
  • DepartmentName — nvarchar(200)
  • Memo — ntext
  • Opinion — ntext
  • Approval — varchar(2)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

BUDGETADJUSTDETAIL

  • Idx — bigint — Primary key — NOT NULL
  • DocNo — varchar(15)
  • AdjustType — varchar(6)
  • FromDepartmentCode — varchar(5)
  • FromAccountCode — varchar(4)
  • FromYear — varchar(4)
  • FromMonth — varchar(2)
  • ToDepartmentCode — varchar(5)
  • ToAccountCode — varchar(4)
  • ToYear — varchar(4)
  • ToMonth — varchar(2)
  • Amount — decimal(28, 4)
  • Reason — ntext
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

BUDGETDETAIL

  • Idx — bigint — Primary key — NOT NULL
  • BudIdx — bigint
  • BudYear — varchar(4)
  • DepartmentCode — varchar(5)
  • AccountCode — varchar(4)
  • Control — varchar(2)
  • Forward — varchar(2)
  • Retroactivity — varchar(2)
  • Transfer — varchar(2)
  • Addition — varchar(2)
  • Approval — varchar(2)
  • Basic01 — decimal(28, 4)
  • Basic02 — decimal(28, 4)
  • Basic03 — decimal(28, 4)
  • Basic04 — decimal(28, 4)
  • Basic05 — decimal(28, 4)
  • Basic06 — decimal(28, 4)
  • Basic07 — decimal(28, 4)
  • Basic08 — decimal(28, 4)
  • Basic09 — decimal(28, 4)
  • Basic10 — decimal(28, 4)
  • Basic11 — decimal(28, 4)
  • Basic12 — decimal(28, 4)
  • Adjust01 — decimal(28, 4)
  • Adjust02 — decimal(28, 4)
  • Adjust03 — decimal(28, 4)
  • Adjust04 — decimal(28, 4)
  • Adjust05 — decimal(28, 4)
  • Adjust06 — decimal(28, 4)
  • Adjust07 — decimal(28, 4)
  • Adjust08 — decimal(28, 4)
  • Adjust09 — decimal(28, 4)
  • Adjust10 — decimal(28, 4)
  • Adjust11 — decimal(28, 4)
  • Adjust12 — decimal(28, 4)
  • Saving01 — decimal(28, 4)
  • Saving02 — decimal(28, 4)
  • Saving03 — decimal(28, 4)
  • Saving04 — decimal(28, 4)
  • Saving05 — decimal(28, 4)
  • Saving06 — decimal(28, 4)
  • Saving07 — decimal(28, 4)
  • Saving08 — decimal(28, 4)
  • Saving09 — decimal(28, 4)
  • Saving10 — decimal(28, 4)
  • Saving11 — decimal(28, 4)
  • Saving12 — decimal(28, 4)
  • Addition01 — decimal(28, 4)
  • Addition02 — decimal(28, 4)
  • Addition03 — decimal(28, 4)
  • Addition04 — decimal(28, 4)
  • Addition05 — decimal(28, 4)
  • Addition06 — decimal(28, 4)
  • Addition07 — decimal(28, 4)
  • Addition08 — decimal(28, 4)
  • Addition09 — decimal(28, 4)
  • Addition10 — decimal(28, 4)
  • Addition11 — decimal(28, 4)
  • Addition12 — decimal(28, 4)
  • Actual01 — decimal(28, 4)
  • … +15

BUDGETEVENT

  • EventCode — varchar(5) — Primary key — NOT NULL
  • EventName — varchar(300)
  • RegistDate — varchar(10)
  • DepartmentCode — varchar(5)
  • DepartmentName — varchar(200)
  • EmployeeId — varchar(5)
  • EmployeeName — varchar(200)
  • FromDate — varchar(10)
  • ToDate — varchar(10)
  • Memo — text
  • Amount — decimal(28, 4)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

BUDGETEVENTDETAIL

  • Idx — bigint — Primary key — NOT NULL
  • EventCode — varchar(5)
  • AccountCode — varchar(4)
  • Amount — decimal(28, 4)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

BUDGETEXPENSE

  • DocNo — varchar(100) — Primary key — NOT NULL
  • EntryDate — varchar(10)
  • DepartmentCode — varchar(5)
  • DepartmentName — nvarchar(200)
  • Memo — ntext
  • Bookkeeping — varchar(2)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

BUDGETEXPENSEDETAIL

  • Idx — bigint — Primary key — NOT NULL
  • EntryDate — varchar(10)
  • DocNo — varchar(100)
  • VatType — varchar(4)
  • AccountCode — varchar(5)
  • EventCode — varchar(5)
  • DepartmentCode — varchar(5)
  • CustomerNo — varchar(5)
  • CustomerName — nvarchar(200)
  • SupplyAmount — decimal(28, 4)
  • SupplyVat — decimal(28, 4)
  • TotalAmount — decimal(28, 4)
  • PaidAmount — decimal(28, 4)
  • RemainAmount — decimal(28, 4)
  • CreditcardId — varchar(5)
  • Summary — text
  • PayDate — varchar(10)
  • AccDocNo — varchar(50)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

BUSINESSDIVISION

  • BusinessCode — varchar(4) — Primary key — NOT NULL
  • BusinessName — nvarchar(200)
  • CodeUsable — varchar(2)
  • RecordDate — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

BUYAUTOENTRY

  • idx — int — Primary key — NOT NULL
  • AccountCode — varchar(4)
  • AccountName — nvarchar(100)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

BUYAUTOTAXACCOUNT

  • idx — int — Primary key — NOT NULL
  • AccountCode — varchar(4)
  • AccountName — nvarchar(100)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

BUYTYPE

  • Idx — int — Primary key — NOT NULL
  • BuyCode — varchar(2)
  • BuyDescription — nvarchar(50)
  • BuyAccount — varchar(5)
  • VatAccount — varchar(5)
  • OppositeAccount — varchar(5)
  • CodeUsable — varchar(2)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

CHARTOFACCOUNT

  • AccountCode — varchar(4) — Primary key — NOT NULL
  • NameInKorean — nvarchar(200)
  • NameInEnglish — nvarchar(200)
  • DebitCredit — varchar(2)
  • UpperCode — varchar(4)
  • EntryAllowable — varchar(2)
  • Valuation — varchar(2)
  • TargetValuationCode — varchar(4)
  • TargetValuationName — nvarchar(200)
  • ExpressionInKorean — nvarchar(200)
  • ExpressionInEnglish — nvarchar(200)
  • ForeignCurrency — varchar(2)
  • Period — varchar(2)
  • Reference — varchar(2)
  • SuspenseAccount — varchar(2)
  • ExpressionOrder — varchar(5)
  • IsUpperCode — varchar(2)
  • CodeUsable — varchar(2)
  • CodeAuthority — varchar(3)
  • RecordDate — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

COLLECTION

  • CollectionDocNo — varchar(15) — Primary key — NOT NULL
  • CollectionDate — varchar(10)
  • CollectionCode — varchar(3)
  • DebitCredit — varchar(2)
  • SalesDocNo — varchar(15)
  • SalesLCNo — varchar(100)
  • DepartmentCode — varchar(5)
  • DepartmentName — nvarchar(200)
  • BLNo — varchar(500)
  • BankingaccountId — varchar(5)
  • NoteNo — varchar(100)
  • NoteDueDate — varchar(10)
  • CustomerNo — varchar(5)
  • CustomerName — nvarchar(200)
  • Memo — ntext
  • Amount — decimal(28, 4)
  • CurrencyCode — varchar(3)
  • ExchangeRate — decimal(28, 4)
  • AmountInForeign — decimal(28, 4)
  • Bookkeeping — varchar(2)
  • RecordDate — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

COLLECTIONDETAIL

  • Idx — bigint — Primary key — NOT NULL
  • CollectionDocNo — varchar(15)
  • SalesDocNo — varchar(15)
  • Amount — decimal(28, 4)
  • CurrencyCode — varchar(3)
  • ExchangeRate — decimal(28, 4)
  • AmountInForeign — decimal(28, 4)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

COMPANYINFO

  • CompanyId — varchar(200) — Primary key — NOT NULL
  • CompanyName — nvarchar(200)
  • CEO — nvarchar(100)
  • StartDate — varchar(10)
  • TaxId — varchar(50)
  • BusinessId — varchar(50)
  • BusinessType — nvarchar(200)
  • BusinessItem — nvarchar(200)
  • PhoneNumber — varchar(50)
  • FaxNumber — varchar(50)
  • Email — varchar(300)
  • CellPhone — varchar(50)
  • HomePage — varchar(200)
  • Address — ntext
  • EnglishCompanyName — nvarchar(500)
  • EnglishAddress — ntext
  • FileLogo — nvarchar(1000)
  • FileSign — nvarchar(1000)
  • EnglishCEO — nvarchar(100)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

COM_AttachFiles

  • tableName — varchar(50) — Primary key — NOT NULL
  • pIdx — varchar(50) — Primary key — NOT NULL
  • num — smallint — Primary key — NOT NULL
  • idx — int — NOT NULL
  • fileGubun — nvarchar(50) — NOT NULL
  • fileNm — nvarchar(200)
  • fileNmOrg — nvarchar(200)
  • url — nvarchar(100)
  • fileSize — int
  • writeTime — datetime
  • path — nvarchar(500)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

COM_FileDownLog

  • idx — int — Primary key — NOT NULL
  • pempno — varchar(50)
  • downDate — varchar(10)
  • downDateTime — datetime
  • ip — varchar(50)
  • PTableName — varchar(50)
  • downLoadIdx — varchar(50)
  • fileName — varchar(100)
  • orgFileName — varchar(100)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

COM_PageViewLog

  • idx — int — Primary key — NOT NULL
  • UserId — varchar(50)
  • PageCode — nchar(10)
  • WriteNo — bigint
  • ViewDate — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

COM_PersistGrid

  • UserId — nvarchar(20) — Primary key — NOT NULL
  • PageCode — nvarchar(5) — Primary key — NOT NULL
  • ControlId — nvarchar(50) — Primary key — NOT NULL
  • ColumnName — nvarchar(50) — Primary key — NOT NULL
  • DisplayIndex — smallint
  • Width — nvarchar(20)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

CONTRACTINCOMEDEDUCT

  • DeductCode — varchar(5) — Primary key — NOT NULL
  • DeductName — nvarchar(200)
  • AccountCode — varchar(4)
  • CalculateTypeA — varchar(2)
  • CalculateTypeB — varchar(2)
  • CodeType — varchar(3)
  • CodeUsable — varchar(2)
  • Sequence — int
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

CONTRACTINCOMEITEM

  • IncomeCode — varchar(5) — Primary key — NOT NULL
  • IncomeName — nvarchar(200)
  • PayRate — decimal(28, 4)
  • CalculateTypeA — varchar(2)
  • CalculateTypeB — varchar(2)
  • Memo — ntext
  • CodeType — varchar(3)
  • CodeUsable — varchar(2)
  • FormulationUse — varchar(2)
  • Formulation — varchar(1000)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

CONTRACTOREMPLOYEE

  • ContractorId — varchar(5) — Primary key — NOT NULL
  • ContractorName — nvarchar(200)
  • SocialNo01 — varchar(200)
  • SocialNo02 — varchar(200)
  • Address — nvarchar(1000)
  • EMail — varchar(300)
  • PhoneNo — varchar(200)
  • BankName — nvarchar(300)
  • BankAccount — varchar(200)
  • JobDescription — nvarchar(1000)
  • DepartmentCode — varchar(5)
  • ProjectCode — varchar(5)
  • PeriodFrom — varchar(10)
  • PeriodTo — varchar(10)
  • ContractStatus — varchar(2)
  • ContractType — varchar(2)
  • PayDay — int
  • PayAmount — decimal(28, 4)
  • PayUnit — varchar(2)
  • UnemployeeJoin — varchar(2)
  • UnemployeeBase — decimal(28, 4)
  • PensionJoin — varchar(2)
  • PensionBase — decimal(28, 4)
  • HealthInsuranceJoin — varchar(2)
  • HealthInsuranceBase — decimal(28, 4)
  • TaxDeduct — varchar(2)
  • FileAttachment — nvarchar(1000)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

CONTRACTORPAYCHECK

  • PayIdx — bigint — Primary key — NOT NULL
  • PayDate — varchar(10)
  • ContractType — varchar(2)
  • PayDay — int
  • PayTitle — nvarchar(1000)
  • PayMemo — ntext
  • Bookkeeping — varchar(2)
  • FromDate — varchar(10)
  • ToDate — varchar(10)
  • DepartmentCode — varchar(5)
  • ProjectCode — varchar(5)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

CONTRACTORPAYCHECKDEDUCT

  • DeductIdx — bigint — Primary key — NOT NULL
  • EnterDate — varchar(10)
  • DepartmentCode — varchar(5)
  • DepartmentName — nvarchar(200)
  • FromDate — varchar(10)
  • ToDate — varchar(10)
  • Memo — ntext
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

CONTRACTORPAYCHECKDEDUCTDETAIL

  • Idx — bigint — Primary key — NOT NULL
  • DeductIdx — bigint
  • ContractorId — varchar(5)
  • DeductCode — varchar(5)
  • Amount — decimal(28, 4)
  • WorkIdx — bigint
  • PayIdx — bigint
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

CONTRACTORPAYCHECKDETAIL

  • DetailIdx — bigint — Primary key — NOT NULL
  • PayIdx — bigint
  • ContractorId — varchar(5)
  • Code — varchar(5)
  • Amount — decimal(28, 4)
  • WorkIdx — bigint
  • ProjectCode — varchar(5)
  • PayDate — varchar(10)
  • DeductIdx — bigint
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

CONTRACTWORKRECORD

  • WorkIdx — bigint — Primary key — NOT NULL
  • EnterDate — varchar(10)
  • DepartmentCode — varchar(5)
  • DepartmentName — nvarchar(200)
  • FromDate — varchar(10)
  • ToDate — varchar(10)
  • WorkDay — int
  • Memo — ntext
  • RecordType — varchar(2)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

CONTRACTWORKRECORDDETAIL

  • Idx — bigint — Primary key — NOT NULL
  • WorkIdx — bigint
  • WorkDate — varchar(10)
  • ContractorId — varchar(5)
  • ProjectCode — varchar(5)
  • IncomeCode — varchar(5)
  • WorkHour — decimal(28, 4)
  • PayIdx — bigint
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

CORPORATIONCARD

  • CreditcardId — varchar(5) — Primary key — NOT NULL
  • CreditcardName — nvarchar(200)
  • CardCode — varchar(20)
  • CardName — varchar(20)
  • CardNo — varchar(20)
  • InetId — varchar(100)
  • InetPwd — nvarchar(100)
  • BusinessId — varchar(50)
  • RegisterDate — datetime
  • Message — nvarchar(200)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

CORPORATIONCARDDETAIL

  • Idx — bigint — Primary key — NOT NULL
  • Card_Id — nvarchar(200)
  • EntryDate — datetime
  • CardCode — varchar(20)
  • CardNo — varchar(20)
  • CardName — nvarchar(200)
  • CustomerNo — varchar(20)
  • CustomerName — nvarchar(200)
  • SupplyAmount — decimal(28, 4)
  • VatAmount — decimal(28, 4)
  • AprvType — varchar(20)
  • VatType — varchar(5)
  • DepartmentCode — varchar(10)
  • AccountCode — varchar(10)
  • Summary — nvarchar(200)
  • DocNo — varchar(15)
  • CreateDate — varchar(50)
  • JournalUsable — varchar(2)
  • BudgetUsable — varchar(2)
  • Message — nvarchar(200)
  • TaxType — varchar(100)
  • BusinessId — varchar(100)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

CREDITCARD

  • CreditcardId — varchar(5) — Primary key — NOT NULL
  • CreditcardType — varchar(4)
  • EmployeeId — varchar(5)
  • EmployeeName — nvarchar(200)
  • CreditcardNumber — varchar(100)
  • CreditcardName — nvarchar(200)
  • AccountCode — varchar(4)
  • AccountName — nvarchar(200)
  • CreditcardMemo — ntext
  • IdUsable — varchar(2)
  • RecordDate — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

CRMBoard

  • BoardId — bigint — Primary key — NOT NULL
  • EntryDate — varchar(10)
  • DepartmentCode — varchar(5)
  • DepartmentName — nvarchar(200)
  • UserId — varchar(50)
  • UserName — nvarchar(200)
  • BoardTitle — nvarchar(500)
  • BoardContent — ntext
  • HitCount — bigint
  • CommentCount — bigint
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

CRMBoardComment

  • Idx — bigint — Primary key — NOT NULL
  • BoardId — bigint
  • EntryDate — varchar(10)
  • UserId — varchar(5)
  • UserName — nvarchar(200)
  • Comment — ntext — text NUL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

CRMBusinessCard

  • BusinessCardId — bigint — Primary key — NOT NULL
  • EntryDate — varchar(10)
  • DepartmentCode — varchar(5)
  • DepartmentName — nvarchar(200)
  • UserId — varchar(50)
  • UserName — nvarchar(200)
  • ClientName — nvarchar(300)
  • ClientCompanyName — nvarchar(300)
  • ClientDepartment — nvarchar(200)
  • ClientJobTitle — nvarchar(200)
  • ClientPhone — varchar(100)
  • ClientCellPhone — varchar(100)
  • ClientFax — varchar(100)
  • ClientHomePage — varchar(300)
  • ClientEmail — varchar(200)
  • ClientEmailReceipt — varchar(2)
  • ClientZipCode — varchar(100)
  • ClientAddress — nvarchar(500)
  • ClientMemo — ntext
  • ShareCode — varchar(3)
  • LeadId — bigint
  • LeadName — nvarchar(300)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

CRMCampaignTarget

  • CampaignTargetId — bigint — Primary key — NOT NULL
  • EntryDate — varchar(10)
  • DepartmentCode — varchar(5)
  • DepartmentName — nvarchar(200)
  • UserId — varchar(50)
  • UserName — nvarchar(200)
  • CampaignMethod — varchar(10)
  • CampaignTitle — nvarchar(500)
  • CampaignContent — ntext
  • ShareCode — varchar(5)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

CRMCampaignTargetDetail

  • Idx — bigint — Primary key — NOT NULL
  • CampaignTargetId — bigint
  • CustomerStatus — varchar(3)
  • LeadId — bigint
  • LeadName — nvarchar(300)
  • TransDate — varchar(10)
  • LeadType — varchar(3)
  • LevelCode — varchar(5)
  • CellPhone — varchar(100)
  • Email — varchar(200)
  • EmailReceipt — varchar(2)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

CRMClientMining

  • MiningId — bigint — Primary key — NOT NULL
  • Entrydate — varchar(10)
  • DepartmentCode — varchar(5)
  • DepartmentName — nvarchar(200)
  • UserId — varchar(50)
  • UserName — nvarchar(200)
  • MiningTitle — nvarchar(500)
  • MiningContent — ntext
  • MiningSource — varchar(3)
  • TransFromDate — varchar(10)
  • TransToDate — varchar(10)
  • TransAmount — decimal(28, 4)
  • TransAmountFormula — varchar(5)
  • TransFrequency — decimal(28, 4)
  • TransFrequencyFormula — varchar(5)
  • ShareCode — varchar(3)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

CRMClientMiningDetail

  • Idx — bigint — Primary key — NOT NULL
  • MiningId — bigint
  • CustomerNo — varchar(5)
  • CustomerName — nvarchar(200)
  • TransAmount — decimal(28, 4)
  • TransFrequency — decimal(28, 4)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

CRMEmailCampaign

  • EmailCampaignId — bigint — Primary key — NOT NULL
  • EntryDate — varchar(10)
  • DepartmentCode — varchar(5)
  • DepartmentName — nvarchar(200)
  • UserId — varchar(50)
  • UserName — nvarchar(200)
  • ShareCode — varchar(5)
  • EmailCampaignTitle — nvarchar(500)
  • EmailContent — ntext
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

CRMEmailSend

  • EmailSendId — bigint — Primary key — NOT NULL
  • EntryDate — varchar(10)
  • DepartmentCode — varchar(5)
  • DepartmentName — nvarchar(200)
  • UserId — varchar(50)
  • UserName — nvarchar(200)
  • SendTimeMethod — varchar(5)
  • SendDate — varchar(10)
  • SendHour — varchar(3)
  • SendMinute — varchar(3)
  • EmailCampaignId — bigint
  • SendEmail — varchar(300)
  • ShareCode — varchar(5)
  • SendStatus — varchar(5)
  • EmailCampaignTitle — nvarchar(500)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

CRMEmailSendDetail

  • Idx — bigint — Primary key — NOT NULL
  • EmailSendId — bigint
  • LeadId — bigint
  • LeadName — nvarchar(200)
  • Email — varchar(200)
  • EmailSendStatus — varchar(5)
  • EmailSendTime — datetime
  • CustomerStatus — varchar(2)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

CRMLead

  • LeadId — bigint — Primary key — NOT NULL
  • LeadName — nvarchar(300)
  • EntryDate — varchar(10)
  • DepartmentCode — varchar(5)
  • DepartmentName — nvarchar(200)
  • UserId — varchar(50)
  • UserName — nvarchar(200)
  • LeadType — varchar(3)
  • InchargerName — nvarchar(200)
  • Phone — varchar(100)
  • CellPhone — varchar(100)
  • Email — varchar(200)
  • EmailReceipt — varchar(2)
  • HomePage — varchar(300)
  • FaxNumber — varchar(100)
  • ZipCode — varchar(100)
  • Address — nvarchar(500)
  • Memo — ntext
  • ShareCode — varchar(3)
  • TransDate — varchar(50)
  • CustomerStatus — varchar(2)
  • CustomerNo — varchar(5)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

CRMLeadLevel

  • Idx — bigint — Primary key — NOT NULL
  • ApplyDate — varchar(10)
  • LeadId — bigint
  • LevelCode — varchar(5)
  • LevelName — nvarchar(200)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

CRMLeadLevelCode

  • LevelCode — varchar(5) — Primary key — NOT NULL
  • LevelName — nvarchar(200)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

CRMLeadType

  • TypeCode — varchar(3) — Primary key — NOT NULL
  • TypeName — nvarchar(100)
  • TypeMemo — ntext
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

CRMNotice

  • NoticeId — bigint — Primary key — NOT NULL
  • EntryDate — varchar(10)
  • UserId — varchar(50)
  • UserName — nvarchar(200)
  • NoticeTitle — nvarchar(500)
  • NoticeContent — ntext
  • HitCount — bigint
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

CRMSMSCampaign

  • SMSCampaignId — bigint — Primary key — NOT NULL
  • EntryDate — varchar(10)
  • DepartmentCode — varchar(5)
  • DepartmentName — nvarchar(200)
  • UserId — varchar(50)
  • UserName — nvarchar(200)
  • MessageType — varchar(5)
  • ShareCode — varchar(5)
  • SMSCampaignTitle — nvarchar(500)
  • SMSContent — nvarchar(500)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

CRMSMSSend

  • SMSSendId — bigint — Primary key — NOT NULL
  • EntryDate — varchar(10)
  • DepartmentCode — varchar(5)
  • DepartmentName — nvarchar(200)
  • UserId — varchar(50)
  • UserName — nvarchar(200)
  • SendTimeMethod — varchar(5)
  • SendDate — varchar(10)
  • SendHour — varchar(3)
  • SendMinute — varchar(3)
  • SMSCampaignId — bigint
  • SendCellPhone — varchar(100)
  • MessageType — varchar(5)
  • ShareCode — varchar(5)
  • SMSContent — nvarchar(500)
  • SendStatus — varchar(5)
  • SMSCampaignTitle — nvarchar(500)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

CRMSMSSendDetail

  • Idx — bigint — Primary key — NOT NULL
  • SMSSendId — bigint
  • LeadId — bigint
  • LeadName — nvarchar(200)
  • SMSCellPhone — varchar(100)
  • SMSSendStatus — varchar(5)
  • SMSSendTime — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

CRMSalesActivity

  • ActivityId — bigint — Primary key — NOT NULL
  • EntryDate — varchar(10)
  • DepartmentCode — varchar(5)
  • DepartmentName — nvarchar(200)
  • UserId — varchar(50)
  • UserName — nvarchar(200)
  • ChanceId — bigint
  • SalesChannelCode — varchar(5)
  • ActivityTitle — nvarchar(500)
  • ActivityContents — ntext
  • ShareCode — varchar(5)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

CRMSalesChance

  • ChanceId — bigint — Primary key — NOT NULL
  • EntryDate — varchar(10)
  • DepartmentCode — varchar(5)
  • DepartmentName — nvarchar(200)
  • UserId — varchar(50)
  • UserName — nvarchar(200)
  • ChanceTitle — nvarchar(500)
  • LeadId — bigint
  • LeadName — nvarchar(300)
  • ContactPhone — varchar(100)
  • InchargerName — nvarchar(200)
  • InchargerDepartment — nvarchar(200)
  • SalesStepCode — varchar(5)
  • ClosingDate — varchar(10)
  • EstimatedSales — decimal(28, 4)
  • SuccessRate — decimal(28, 4)
  • ShareCode — varchar(5)
  • Contents — ntext
  • SalesStatus — varchar(5)
  • Memo01 — nvarchar(300)
  • Memo02 — nvarchar(300)
  • Memo03 — nvarchar(300)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

CRMSalesChanceColumn

  • ColumnCode — varchar(10) — Primary key — NOT NULL
  • ColumnName — nvarchar(100)
  • ColumnUsable — varchar(2)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

CRMSalesChannelCode

  • SalesChannelCode — varchar(5) — Primary key — NOT NULL
  • SalesChannelName — nvarchar(200)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

CRMSalesStepCode

  • SalesStepCode — varchar(5) — Primary key — NOT NULL
  • SalesStepName — nvarchar(200)
  • UseStatus — varchar(2)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

CRMSchedule

  • Idx — bigint — NOT NULL
  • UserId — varchar(50)
  • Title — nvarchar(200)
  • StartDate — varchar(100)
  • EndDate — varchar(100)
  • Contents — ntext

CURRENCYTYPE

  • idx — int — Primary key — NOT NULL
  • currencycode — varchar(5)
  • currencyname — nvarchar(100)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

CUSTOMER

  • CustomerNo — varchar(5) — Primary key — NOT NULL
  • Name — nvarchar(200)
  • BusinessId — varchar(12)
  • CEO — nvarchar(100)
  • Address — nvarchar(300)
  • BusinessType — nvarchar(200)
  • BusinessItem — nvarchar(200)
  • PhoneNumber — varchar(50)
  • ContactPoint — nvarchar(50)
  • ContactPointEmail — nvarchar(200)
  • IsHeadOffice — varchar(50)
  • HeadOfficeCode — varchar(5)
  • HeadOfficeName — nvarchar(200)
  • BankCode — varchar(5)
  • BankName — nvarchar(200)
  • BankAccount — varchar(50)
  • BankNameForForeignCurrency — nvarchar(200)
  • BankBranchNameForForeignCurrency — nvarchar(200)
  • BankAddressForForeignCurrency — nvarchar(300)
  • BankABANOForForeignCurrency — nvarchar(50)
  • BankACNOForForeignCurrency — nvarchar(50)
  • IdUsable — varchar(50)
  • RecordDate — datetime
  • FaxNumber — varchar(50)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

CUSTOMERCONTACT

  • ContactId — bigint — Primary key — NOT NULL
  • CustomerNo — varchar(5)
  • ContactDepartment — nvarchar(200)
  • ContactJobTitle — nvarchar(50)
  • ContactName — nvarchar(200) — NOT NULL
  • ContactPhone — varchar(50)
  • ContactEmail — varchar(200)
  • ContactMemo — ntext
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

ContractIncomeCodeFormulation

  • Idx — bigint — Primary key — NOT NULL
  • IncomeCode — varchar(5)
  • Formulation — varchar(50)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

ContractorIncomeProject

  • Idx — bigint — Primary key — NOT NULL
  • ProjectCode — varchar(5)
  • ProjectName — nvarchar(200)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

ContractorProjectSetIncome

  • Idx — bigint — Primary key — NOT NULL
  • ProjectCode — varchar(5)
  • IncomeCode — varchar(5)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

DEL_20160130_SYSMAILSENDLOG

  • Idx — int — Primary key — NOT NULL
  • RecvMail — nvarchar(100) — NOT NULL — 수신인 메일계정
  • SendMail — nvarchar(100) — NOT NULL — 발신인 메일계정
  • Subject — nvarchar(1000) — NOT NULL — 메일 제목
  • Body — nvarchar(max) — NOT NULL — 메일 내용
  • SendYN — nchar(1) — NOT NULL — 발신여부
  • CreateTime — datetime — 데이터 생성일시
  • SendTime — datetime — 메일 발송일시
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

DEPARTMENT

  • DepartmentCode — varchar(5) — Primary key — NOT NULL
  • DepartmentName — nvarchar(200)
  • BusinessCode — varchar(4)
  • BusinessName — nvarchar(200)
  • CodeUsable — varchar(2)
  • RecordDate — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

DEPRECIATION

  • DepreId — bigint — Primary key — NOT NULL
  • DeprePeriod — int
  • DepreYear — varchar(4)
  • DepreFromMonth — varchar(2)
  • DepreToMonth — varchar(2)
  • DepreAccountAmount — decimal(28, 4)
  • DepreTaxAmount — decimal(28, 4)
  • Bookkeeping — varchar(2)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

and 221 more tables