testER

Tables (6)

BANK

  • BANK_ID — NUMBER(3) — Primary key — NOT NULL
  • BANK_CODE — VARCHAR(3)
  • BANK_NAME_TH — VARCHAR(100)
  • BANK_NAME_EN — VARCHAR(100)
  • BANK_NAME_ABBR — VARCHAR(10)
  • BANK_SWIFTCODE — VARCHAR(20)
  • BANK_STATUS — VARCHAR(1)
  • BANK_CREATE_BY — VARCHAR(10)
  • BANK_CREATE_DT — DATE
  • BANK_UPDATE_BY — VARCHAR(10)
  • BANK_UPDATE_DT — DATE

BANK_MANAGER

  • BANK_MGR_ID — NUMBER(10) — Primary key — NOT NULL
  • BANK_ID — NUMBER(3) — NOT NULL
  • HEAD_POSITION — VARCHAR(100)
  • MD_NAME — VARCHAR(100)
  • EFFECTIVE_DT — DATE
  • TMN_DT — DATE
  • EMAIL_BANK_STAFF — VARCHAR(255)
  • EMAIL_TCG_STAFF — VARCHAR(255)
  • BANK_MGR_CREATE_BY — VARCHAR(10)
  • BANK_MGR_CREATE_DT — DATE
  • BANK_MGR_UPDATE_BY — VARCHAR(10)
  • BANK_MGR_UPDATE_DT — DATE

FEE_TYPE

  • FT_ID — NUMBER(5) — Primary key — NOT NULL
  • FEE_DETAIL — VARCHAR(200)
  • EFF_DT — DATE — NOT NULL
  • TMN_DT — DATE — NOT NULL
  • REF — VARCHAR(200)
  • REF_DT — DATE
  • REF_TMN — VARCHAR(200)
  • CREATE_BY — VARCHAR(10)

MEMBER

  • MEMBER_ID — NUMBER — Primary key — NOT NULL
  • PARTNER_ID — NUMBER(3) — NOT NULL
  • MEMBER_CODE — VARCHAR(10)
  • MEMBER_NAME — VARCHAR(100)
  • MEMBER_STATUS — VARCHAR(1)
  • MEMBER_CREATE_BY — VARCHAR(10)
  • MEMBER_CREATE_DT — DATE
  • MEMBER_UPDATE_BY — VARCHAR(10 CHAR)
  • MEMBER_UPDATE_DT — DATE

OPERATION_FEE

  • OPF_ID — NUMBER(6) — Primary key — NOT NULL
  • OPRTF_ID — NUMBER(6) — NOT NULL
  • MIN_GUARANTEE_LIMIT — NUMBER(18) — NOT NULL
  • MAX_GUARANTEE_LIMIT — NUMBER(18) — NOT NULL
  • EFF_DT — DATE
  • TMN_DT — DATE
  • OPERATION_RT — NUMBER(4,2)
  • REF — VARCHAR(200)
  • REF_DT — DATE
  • REF_TMN — VARCHAR(200)
  • CREATE_BY — VARCHAR(10)

OPERATION_TYPE_FEE

  • OPRTF_ID — NUMBER(6) — Primary key — NOT NULL
  • OPERATION_TYPE_CD — VARCHAR(5)
  • OPERATION_TYPE_FEE_DETAIL — VARCHAR(200)
  • CREATE_BY — VARCHAR(10)