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 — =