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)