Test

Tables (11)

TGHG_APP_APPLICANT

  • AppNo — varchar(20) — Primary key — NOT NULL
  • CompanyName — varchar(100)
  • Address — nvarchar(1000)
  • TelNo — varchar(100)
  • FaxNo — varchar(100)
  • EMail — nvarchar(1000)
  • ManagerName — nvarchar(1000)
  • MobileNo — nvarchar(1000)
  • ManagerEmail — nvarchar(1000)
  • ExistSystemMRV — varchar(1)
  • PROCESSID — varchar(20)
  • PROCESSIP — varchar(20)
  • PROCESSDATE — datetime
  • UPDATEID — varchar(20)
  • UPDATEIP — varchar(20)
  • UPDATEDATE — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

TGHG_APP_BASICINFO

  • AppNo — varchar(20) — Primary key — NOT NULL
  • Seq — int — Primary key — NOT NULL
  • ShipName — varchar(300)
  • ShipType — varchar(5)
  • ShipTypeOther — varchar(500)
  • IMO_ID — varchar(10)
  • MRVCompany — varchar(300)
  • KRClassed — varchar(7)
  • SisterShip — varchar(300)
  • MP_Status — varchar(5)
  • MP_ExpectDate — datetime
  • ER_Status — varchar(5)
  • ER_ExpectDate — datetime
  • DistinctID — varchar(100)
  • Letters — varchar(100)
  • FlagCode — varchar(5)
  • RegPort — varchar(5)
  • GrossTonnage — numeric(8, 2)
  • RegClass — varchar(5)
  • Remark — varchar(200)
  • Cert_Remark — varchar(500)
  • PROCESSID — varchar(20)
  • PROCESSIP — varchar(20)
  • PROCESSDATE — datetime
  • UPDATEID — varchar(20)
  • UPDATEIP — varchar(20)
  • UPDATEDATE — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

TGHG_APP_BASICINFO_CON

  • AppNo — varchar(20) — Primary key — NOT NULL
  • Seq — int — Primary key — NOT NULL
  • ShipName — varchar(300)
  • ShipType — varchar(5)
  • IMO_ID — varchar(10)
  • MRVCompany — varchar(300)
  • KRClassed — varchar(7)
  • SisterShip — varchar(300)
  • MP_Status — varchar(5)
  • MP_ExpectDate — datetime
  • ER_Status — varchar(5)
  • ER_ExpectDate — datetime
  • DistinctID — varchar(100)
  • FlagCode — varchar(5)
  • RegPort — varchar(5)
  • GrossTonnage — numeric(8, 2)
  • RegClass — varchar(5)
  • SSEQ — int
  • REF_SEQ — int
  • PROCESSID — varchar(20)
  • PROCESSIP — varchar(20)
  • PROCESSDATE — datetime
  • UPDATEID — varchar(20)
  • UPDATEIP — varchar(20)
  • UPDATEDATE — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

TGHG_APP_DATA_LOC

  • AppNo — varchar(20) — Primary key — NOT NULL
  • Seq — int — Primary key — NOT NULL
  • LocationName — varchar(100)
  • DataType — varchar(5)
  • ITSysName — varchar(100)
  • AccessedKR — varchar(5)
  • PROCESSID — varchar(20)
  • PROCESSIP — varchar(20)
  • PROCESSDATE — datetime
  • UPDATEID — varchar(20)
  • UPDATEIP — varchar(20)
  • UPDATEDATE — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

TGHG_APP_DATA_LOC_SHIP

  • AppNo — varchar(20) — Primary key — NOT NULL
  • LocSeq — int — Primary key — NOT NULL
  • ShipSeq — int — Primary key — NOT NULL
  • PROCESSID — varchar(20)
  • PROCESSIP — varchar(20)
  • PROCESSDATE — datetime
  • UPDATEID — varchar(20)
  • UPDATEIP — varchar(20)
  • UPDATEDATE — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

TGHG_APP_EVI_DOC

  • AppNo — varchar(20) — Primary key — NOT NULL
  • EviDocType — varchar(5) — Primary key — NOT NULL
  • ResearchNo — int — Primary key — NOT NULL
  • AnswerCode — varchar(5)
  • PROCESSID — varchar(20)
  • PROCESSIP — varchar(20)
  • PROCESSDATE — datetime
  • UPDATEID — varchar(20)
  • UPDATEIP — varchar(20)
  • UPDATEDATE — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

TGHG_APP_INVOICE

  • APPNO — varchar(20) — Primary key — NOT NULL
  • SEQ — int — Primary key — NOT NULL
  • InvoiceType — varchar(5)
  • CompanyName — varchar(300)
  • Address — varchar(300)
  • TelNo — varchar(50)
  • FaxNo — varchar(50)
  • Email — varchar(100)
  • ManagerName — varchar(50)
  • ShipSeq — int
  • PROCESSID — varchar(20)
  • PROCESSIP — varchar(20)
  • PROCESSDATE — datetime
  • UPDATEID — varchar(20)
  • UPDATEIP — varchar(20)
  • UPDATEDATE — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

TGHG_APP_INVOICE_SHIP

  • AppNo — varchar(20) — Primary key — NOT NULL
  • InvSeq — int — Primary key — NOT NULL
  • ShipSeq — int — Primary key — NOT NULL
  • PROCESSID — varchar(20)
  • PROCESSIP — varchar(20)
  • PROCESSDATE — datetime
  • UPDATEID — varchar(20)
  • UPDATEIP — varchar(20)
  • UPDATEDATE — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

TGHG_APP_MST

  • APPNO — varchar(20) — Primary key — NOT NULL
  • USERID — varchar(10) — NOT NULL
  • APPKIND — varchar(5) — NOT NULL
  • APPDATE — datetime
  • APPTYPE — varchar(5)
  • APPSTATUS — varchar(5)
  • DIFFBILYN — varchar(1)
  • DATAVERIFYEAR — varchar(4)
  • PROCESSID — varchar(20)
  • PROCESSIP — varchar(20)
  • PROCESSDATE — datetime
  • UPDATEID — varchar(20)
  • UPDATEIP — varchar(20)
  • UPDATEDATE — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

TGHG_APP_MST_CON

  • APPNO — varchar(20) — Primary key — NOT NULL
  • USERID — varchar(10) — NOT NULL
  • APPKIND — varchar(5) — NOT NULL
  • APPDATE — datetime
  • APPTYPE — varchar(5)
  • APPSTATUS — varchar(5)
  • DIFFBILYN — varchar(1)
  • PROCESSID — varchar(20)
  • PROCESSIP — varchar(20)
  • PROCESSDATE — datetime
  • UPDATEID — varchar(20)
  • UPDATEIP — varchar(20)
  • UPDATEDATE — datetime
  • SEQ — int
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

TGHG_APP_PRC

  • APPNO — varchar(20) — Primary key — NOT NULL
  • SHIPSEQ — int — Primary key — NOT NULL
  • APPTYPE — varchar(5) — Primary key — NOT NULL
  • PRCID — varchar(20) — NOT NULL
  • PROCESSID — varchar(20)
  • PROCESSIP — varchar(20)
  • PROCESSDATE — datetime
  • UPDATEID — varchar(20)
  • UPDATEIP — varchar(20)
  • UPDATEDATE — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =