TEST

Tables (4)

BB100T

  • COMP_NM — nvarchar(40) — Primary key — NOT NULL
  • COMP_ENG_NM — nvarchar(50)
  • CHIEF_NM — nvarchar(20) — NOT NULL
  • CHIEF_ENG_NM — nvarchar(30)
  • CHIEF_RES_NO — nvarchar(13)
  • COMP_NO — nvarchar(10) — NOT NULL
  • COMP_OWN_NO — nvarchar(13)
  • COMP_TYPE — nvarchar(30) — NOT NULL
  • COMP_CLASS — nvarchar(30) — NOT NULL
  • COMP_KIND — nvarchar(1) — NOT NULL
  • ESTA_DATE — nvarchar(8)
  • ZIP_CD — nvarchar(6)
  • ADDR — nvarchar(200)
  • ENG_ADDR — nvarchar(200)
  • TEL_NO — nvarchar(20)
  • FAX_NO — nvarchar(20)
  • HTTP_ADDR — nvarchar(50)
  • E_MAIL — nvarchar(50)
  • COMP_LEN — decimal(18, 0)
  • COMP_LOGO — image
  • COMP_LEN_2 — decimal(18, 0)
  • COMP_LOGO_2 — image
  • COMP_LEN_3 — decimal(18, 0)
  • COMP_LOGO_3 — image
  • SESSION — numeric(4, 0)
  • FN_DATE — nvarchar(8)
  • TO_DATE — nvarchar(8)
  • COMP_SEAL_LEN — decimal(18, 0)
  • COMP_SEAL — image
  • UPDT_MAN — nvarchar(40) — NOT NULL
  • UPDT_DATE — smalldatetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Untitled

  • Key — Primary key — NOT NULL
  • Key2 — Primary key — NOT NULL
  • Key (Key3) — Foreign key → Untitled2.Key — NOT NULL
  • Key2 (Key22) — Foreign key → Untitled2.Key2 — NOT NULL
  • Key3 (Key32) — Foreign key → Untitled2.Key3 — NOT NULL
  • Field
  • Field2

Untitled2

  • Key — Primary key — NOT NULL
  • Key2 — Primary key — NOT NULL
  • Key3 — Primary key — NOT NULL
  • Field
  • Field2
  • Field3

Untitled3

  • Key — Primary key — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4
  • Field5
  • Field6
  • Field7
  • Field8
  • Field9
  • Field10
  • Field11