⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 table.ddl

📁 j2ee源码
💻 DDL
📖 第 1 页 / 共 5 页
字号:


-- Generated by Relational Schema Center on Fri Oct 17 09:05:41 CST 2008

   
CREATE DATABASE HMTEST1;

CREATE TABLE WKEXS.AGENT
  (COMPANY_ID VARCHAR2(20) NOT NULL,
   AGENT_ID NUMBER(8, 0) NOT NULL,
   FULL_NAME VARCHAR2(400) NULL,
   SHORT_NAME VARCHAR2(120) NULL,
   CONTACT VARCHAR2(200) NULL,
   TELEPHONE VARCHAR2(200) NULL,
   FAX VARCHAR2(200) NULL,
   ADDRESS VARCHAR2(800) NULL,
   EMAIL VARCHAR2(200) NULL,
   CREATE_DTTM DATE NULL,
   CREATE_BY VARCHAR2(15) NULL,
   LAST_MODIFY_DTTM DATE NULL,
   LAST_MODIFY_BY VARCHAR2(15) NULL);

ALTER TABLE WKEXS.AGENT
  ADD CONSTRAINT AGENT_PK PRIMARY KEY (COMPANY_ID, AGENT_ID);

CREATE TABLE WKEXS.BANK
  (COMPANY_ID VARCHAR2(20) NOT NULL,
   BANK_ID VARCHAR2(50) NOT NULL,
   NAME VARCHAR2(800) NULL,
   ADDRESS VARCHAR2(3200) NULL,
   ACCOUNT_NO VARCHAR2(50) NULL,
   SWIFT_CD VARCHAR2(60) NULL,
   CREATE_DTTM DATE NULL,
   CREATE_BY VARCHAR2(15) NULL,
   LAST_MODIFY_DTTM DATE NULL,
   LAST_MODIFY_BY VARCHAR2(15) NULL);

ALTER TABLE WKEXS.BANK
  ADD CONSTRAINT BANK_PK PRIMARY KEY (COMPANY_ID, BANK_ID);

CREATE TABLE WKEXS.BILLS_RECV_DTL
  (COMPANY_ID VARCHAR2(20) NOT NULL,
   BR_TXN_NO VARCHAR2(20) NOT NULL,
   SHIPMENT_NO VARCHAR2(20) NOT NULL,
   SC_TXN_NO VARCHAR2(17) NOT NULL,
   SC_NO VARCHAR2(17) NULL,
   BR_NO VARCHAR2(30) NULL,
   SHIPPED_QTY NUMBER(12, 0) NULL,
   SHIPPED_WT NUMBER(12, 3) NULL,
   SHIPPED_AMT NUMBER(12, 2) NULL,
   INVOICE_NO VARCHAR2(20) NULL);

ALTER TABLE WKEXS.BILLS_RECV_DTL
  ADD CONSTRAINT BILLS_RECV_DTL_PK PRIMARY KEY (COMPANY_ID, BR_TXN_NO, SHIPMENT_NO, SC_TXN_NO);

CREATE TABLE WKEXS.BILLS_RECV_HDR
  (COMPANY_ID VARCHAR2(20) NOT NULL,
   BR_TXN_NO VARCHAR2(20) NOT NULL,
   BR_NO VARCHAR2(30) NULL,
   LC_SC_NO VARCHAR2(30) NULL,
   CUSTOMER_ID NUMBER(8, 0) NULL,
   CURRENCY_ID VARCHAR2(3) NULL,
   ISSUE_DATE DATE NULL,
   BR_DATE DATE NULL,
   DUE_DATE DATE NULL,
   PRESENT_DATE DATE NULL,
   BANK_ACCEPT_DATE DATE NULL,
   COLLECTION_DATE DATE NULL,
   BANK_ID VARCHAR2(50) NULL,
   BANK_CHARGES NUMBER(12, 2) NULL,
   EXCHANGE_RATE NUMBER(13, 7) NULL,
   CHARGES_CURRENCY_ID VARCHAR2(3) NULL,
   STATUS VARCHAR2(1) NULL,
   TTL_AMT NUMBER(12, 2) NULL,
   TTL_QTY NUMBER(12, 0) NULL,
   TTL_WT NUMBER(12, 3) NULL,
   RECV_CURRENCY_ID VARCHAR2(3) NULL,
   PAY_TERMS_ID VARCHAR2(8) NULL,
   PAY_DTL_ID VARCHAR2(8) NULL,
   CREATE_DTTM DATE NULL,
   CREATE_BY VARCHAR2(15) NULL,
   LAST_MODIFY_DTTM DATE NULL,
   LAST_MODIFY_BY VARCHAR2(15) NULL,
   VOID_DTTM DATE NULL,
   VOID_BY VARCHAR2(15) NULL);

ALTER TABLE WKEXS.BILLS_RECV_HDR
  ADD CONSTRAINT BILLS_RECV_HDR_PK PRIMARY KEY (COMPANY_ID, BR_TXN_NO);

CREATE TABLE WKEXS.CERT_DTL
  (COMPANY_ID VARCHAR2(20) NOT NULL,
   CERT_ID VARCHAR2(12) NOT NULL,
   ROW_ID VARCHAR2(5) NOT NULL,
   DESC_TITLE VARCHAR2(800) NULL,
   DESC_CONTENT VARCHAR2(4000) NULL);

ALTER TABLE WKEXS.CERT_DTL
  ADD CONSTRAINT CERT_DTL_PK PRIMARY KEY (COMPANY_ID, CERT_ID, ROW_ID);

CREATE TABLE WKEXS.CERT_HDR
  (COMPANY_ID VARCHAR2(20) NOT NULL,
   CERT_ID VARCHAR2(12) NOT NULL,
   CERT_NAME VARCHAR2(1280) NULL,
   CERT_DATE DATE NULL,
   SHIPMENT_NO VARCHAR2(20) NULL,
   CUSTOMER VARCHAR2(4000) NULL,
   HEADER_REMARK VARCHAR2(4000) NULL,
   FOOTER_REMARK VARCHAR2(4000) NULL,
   COMP_SIGN VARCHAR2(4000) NULL,
   SIGN_PERSON VARCHAR2(4000) NULL,
   CREATE_DTTM DATE NULL,
   CREATE_BY VARCHAR2(15) NULL,
   LAST_MODIFY_DTTM DATE NULL,
   LAST_MODIFY_BY VARCHAR2(15) NULL);

ALTER TABLE WKEXS.CERT_HDR
  ADD CONSTRAINT CERT_HDR_PK PRIMARY KEY (COMPANY_ID, CERT_ID);

CREATE TABLE WKEXS.CITY
  (COMPANY_ID VARCHAR2(20) NOT NULL,
   COUNTRY_ID VARCHAR2(5) NOT NULL,
   CITY_ID VARCHAR2(5) NOT NULL,
   DESCRIPTION VARCHAR2(800) NULL,
   DESCRIPTION_CHT VARCHAR2(800) NULL,
   DESCRIPTION_CHS VARCHAR2(800) NULL,
   CREATE_DTTM DATE NULL,
   CREATE_BY VARCHAR2(15) NULL,
   LAST_MODIFY_DTTM DATE NULL,
   LAST_MODIFY_BY VARCHAR2(15) NULL);

ALTER TABLE WKEXS.CITY
  ADD CONSTRAINT CITY_PK PRIMARY KEY (COMPANY_ID, COUNTRY_ID, CITY_ID);

CREATE TABLE WKEXS.COMPANY
  (COMPANY_ID VARCHAR2(20) NOT NULL,
   COMPANY_NAME_CHT VARCHAR2(280) NULL,
   COMPANY_NAME_CHS VARCHAR2(280) NULL,
   COMPANY_NAME_ENG VARCHAR2(280) NULL,
   COMPANY_CHOP_NAME_CHT VARCHAR2(280) NULL,
   COMPANY_CHOP_NAME_CHS VARCHAR2(280) NULL,
   COMPANY_CHOP_NAME_ENG VARCHAR2(280) NULL,
   COMPANY_ADDRESS_CHT VARCHAR2(800) NULL,
   COMPANY_ADDRESS_CHS VARCHAR2(800) NULL,
   COMPANY_ADDRESS_ENG VARCHAR2(800) NULL,
   BASE_CURRENCY VARCHAR2(3) NULL,
   POSTAL_CD VARCHAR2(20) NULL,
   TELEPHONE VARCHAR2(120) NULL,
   FAX VARCHAR2(120) NULL,
   EMAIL VARCHAR2(200) NULL,
   ACTIVE VARCHAR2(1) NULL,
   CREATE_DTTM DATE NULL,
   CREATE_BY VARCHAR2(15) NULL,
   LAST_MODIFY_DTTM DATE NULL,
   LAST_MODIFY_BY VARCHAR2(15) NULL,
   COMPANY_PREFIX_CD VARCHAR2(2) NULL,
   LAST_MTH_END DATE NULL,
   BANK_ID VARCHAR2(50) NULL,
   COMPANY_DESC_ENG VARCHAR2(120) NULL,
   COMPANY_DESC_CHT VARCHAR2(120) NULL,
   COMPANY_DESC_CHS VARCHAR2(120) NULL,
   CUSTOMER_PREFIX_CD VARCHAR2(1) NULL);

ALTER TABLE WKEXS.COMPANY
  ADD CONSTRAINT COMPANY_PK PRIMARY KEY (COMPANY_ID);

CREATE TABLE WKEXS.COUNTRY
  (COMPANY_ID VARCHAR2(20) NOT NULL,
   COUNTRY_ID VARCHAR2(5) NOT NULL,
   DESCRIPTION VARCHAR2(800) NULL,
   DESCRIPTION_CHT VARCHAR2(800) NULL,
   DESCRIPTION_CHS VARCHAR2(800) NULL,
   CREATE_DTTM DATE NULL,
   CREATE_BY VARCHAR2(15) NULL,
   LAST_MODIFY_DTTM DATE NULL,
   LAST_MODIFY_BY VARCHAR2(15) NULL,
   PACKING_DESCRIPTION VARCHAR2(800) NULL,
   PACKING_DESCRIPTION_CHT VARCHAR2(800) NULL,
   PACKING_DESCRIPTION_CHS VARCHAR2(800) NULL);

ALTER TABLE WKEXS.COUNTRY
  ADD CONSTRAINT COUNTRY_PK PRIMARY KEY (COMPANY_ID, COUNTRY_ID);

CREATE TABLE WKEXS.CREDIT_NOTE_DTL
  (COMPANY_ID VARCHAR2(20) NOT NULL,
   CREDIT_NOTE_NO VARCHAR2(17) NOT NULL,
   SHIPMENT_NO VARCHAR2(20) NOT NULL,
   SC_TXN_NO VARCHAR2(17) NOT NULL,
   PAPER_TYPE_ID VARCHAR2(15) NOT NULL,
   REASON_CODE VARCHAR2(10) NOT NULL,
   PARTICULARS VARCHAR2(2000) NULL,
   SC_NO VARCHAR2(17) NULL,
   AMT NUMBER(12, 2) NULL,
   CUSTOMER_PO_NO VARCHAR2(70) NULL);

ALTER TABLE WKEXS.CREDIT_NOTE_DTL
  ADD CONSTRAINT CREDIT_NOTE_DTL_PK PRIMARY KEY (COMPANY_ID, CREDIT_NOTE_NO, SHIPMENT_NO, SC_TXN_NO, PAPER_TYPE_ID, REASON_CODE);

CREATE TABLE WKEXS.CREDIT_NOTE_HDR
  (COMPANY_ID VARCHAR2(20) NOT NULL,
   CREDIT_NOTE_NO VARCHAR2(17) NOT NULL,
   CUSTOMER_ID NUMBER(8, 0) NULL,
   CREDIT_NOTE_DATE DATE NULL,
   CURRENCY_ID VARCHAR2(3) NULL,
   STATUS VARCHAR2(5) NULL,
   TTL_AMT NUMBER(12, 2) NULL,
   REMARKS VARCHAR2(4000) NULL,
   CREATE_DTTM DATE NULL,
   CREATE_BY VARCHAR2(15) NULL,
   LAST_MODIFY_DTTM DATE NULL,
   LAST_MODIFY_BY VARCHAR2(15) NULL,
   VOID_DTTM DATE NULL,
   VOID_BY VARCHAR2(15) NULL,
   POST_DTTM DATE NULL,
   POST_BY VARCHAR2(15) NULL);

ALTER TABLE WKEXS.CREDIT_NOTE_HDR
  ADD CONSTRAINT CREDIT_NOTE_HDR_PK PRIMARY KEY (COMPANY_ID, CREDIT_NOTE_NO);

CREATE TABLE WKEXS.CURRENCY_DTL
  (COMPANY_ID VARCHAR2(20) NOT NULL,
   CURRENCY_ID VARCHAR2(3) NOT NULL,
   FM_CURRENCY_ID VARCHAR2(3) NOT NULL,
   EFF_DATE DATE NOT NULL,
   EXCHG_RATE NUMBER(13, 7) NULL);

ALTER TABLE WKEXS.CURRENCY_DTL
  ADD CONSTRAINT CURRENCY_DTL_PK PRIMARY KEY (COMPANY_ID, CURRENCY_ID, FM_CURRENCY_ID, EFF_DATE);

CREATE TABLE WKEXS.CURRENCY_HDR
  (COMPANY_ID VARCHAR2(20) NOT NULL,
   CURRENCY_ID VARCHAR2(3) NOT NULL,
   DESCRIPTION VARCHAR2(200) NULL,
   CREATE_DTTM DATE NULL,
   CREATE_BY VARCHAR2(15) NULL,
   LAST_MODIFY_DTTM DATE NULL,
   LAST_MODIFY_BY VARCHAR2(15) NULL);

ALTER TABLE WKEXS.CURRENCY_HDR
  ADD CONSTRAINT CURRENCY_HDR_PK PRIMARY KEY (COMPANY_ID, CURRENCY_ID);

CREATE TABLE WKEXS.CUSTOMER_DTL
  (COMPANY_ID VARCHAR2(20) NOT NULL,
   CUSTOMER_ID NUMBER(8, 0) NOT NULL,
   DELIVERY_ADDR_ID VARCHAR2(5) NOT NULL,
   DELIVERY_ADDR VARCHAR2(800) NULL);

ALTER TABLE WKEXS.CUSTOMER_DTL
  ADD CONSTRAINT CUSTOMER_DTL_PK PRIMARY KEY (COMPANY_ID, CUSTOMER_ID, DELIVERY_ADDR_ID);

CREATE TABLE WKEXS.CUSTOMER_HDR
  (COMPANY_ID VARCHAR2(20) NOT NULL,
   CUSTOMER_ID NUMBER(8, 0) NOT NULL,
   FULL_NAME VARCHAR2(400) NULL,
   SHORT_NAME VARCHAR2(120) NULL,
   CONTACT VARCHAR2(200) NULL,
   TELEPHONE VARCHAR2(200) NULL,
   FAX VARCHAR2(200) NULL,
   MAIL_ADDRESS VARCHAR2(800) NULL,
   EMAIL VARCHAR2(200) NULL,
   PAY_TERMS_ID VARCHAR2(8) NULL,
   PAY_DTL_ID VARCHAR2(8) NULL,
   CREDIT_LIMIT NUMBER(12, 2) NULL,
   CREATE_DTTM DATE NULL,
   CREATE_BY VARCHAR2(15) NULL,
   LAST_MODIFY_DTTM DATE NULL,
   LAST_MODIFY_BY VARCHAR2(15) NULL,
   CURRENCY_ID VARCHAR2(3) NULL,
   SALESPERSON_ID VARCHAR2(15) NULL,
   COUNTRY_ID VARCHAR2(5) NULL,
   CITY_ID VARCHAR2(5) NULL,
   BPCS_CUSTOMER_ID NUMBER(8, 0) NULL,
   ACTIVE VARCHAR2(1) NULL);

ALTER TABLE WKEXS.CUSTOMER_HDR
  ADD CONSTRAINT CUSTOMER_HDR_PK PRIMARY KEY (COMPANY_ID, CUSTOMER_ID);

CREATE TABLE WKEXS.DEBIT_NOTE_DTL
  (COMPANY_ID VARCHAR2(20) NOT NULL,
   DEBIT_NOTE_NO VARCHAR2(17) NOT NULL,
   SHIPMENT_NO VARCHAR2(20) NOT NULL,
   SC_TXN_NO VARCHAR2(17) NOT NULL,
   PAPER_TYPE_ID VARCHAR2(15) NOT NULL,
   REASON_CODE VARCHAR2(10) NOT NULL,
   PARTICULARS VARCHAR2(2000) NULL,
   SC_NO VARCHAR2(17) NULL,
   AMT NUMBER(12, 2) NULL,
   CUSTOMER_PO_NO VARCHAR2(70) NULL);

ALTER TABLE WKEXS.DEBIT_NOTE_DTL
  ADD CONSTRAINT DEBIT_NOTE_DTL_PK PRIMARY KEY (COMPANY_ID, DEBIT_NOTE_NO, SHIPMENT_NO, SC_TXN_NO, PAPER_TYPE_ID, REASON_CODE);

CREATE TABLE WKEXS.DEBIT_NOTE_HDR
  (COMPANY_ID VARCHAR2(20) NOT NULL,
   DEBIT_NOTE_NO VARCHAR2(17) NOT NULL,
   CUSTOMER_ID NUMBER(8, 0) NULL,
   DEBIT_NOTE_DATE DATE NULL,
   CURRENCY_ID VARCHAR2(3) NULL,
   STATUS VARCHAR2(5) NULL,
   TTL_AMT NUMBER(12, 2) NULL,
   REMARKS VARCHAR2(4000) NULL,
   CREATE_DTTM DATE NULL,
   CREATE_BY VARCHAR2(15) NULL,
   LAST_MODIFY_DTTM DATE NULL,
   LAST_MODIFY_BY VARCHAR2(15) NULL,
   VOID_DTTM DATE NULL,
   VOID_BY VARCHAR2(15) NULL,
   POST_DTTM DATE NULL,
   POST_BY VARCHAR2(15) NULL);

ALTER TABLE WKEXS.DEBIT_NOTE_HDR
  ADD CONSTRAINT DEBIT_NOTE_HDR_PK PRIMARY KEY (COMPANY_ID, DEBIT_NOTE_NO);

CREATE TABLE WKEXS.DEPOSIT_DTL
  (COMPANY_ID VARCHAR2(20) NOT NULL,
   DEPOSIT_NO VARCHAR2(17) NOT NULL,
   SC_TXN_NO VARCHAR2(17) NOT NULL,
   SC_NO VARCHAR2(17) NULL,
   AMT NUMBER(12, 2) NULL);

ALTER TABLE WKEXS.DEPOSIT_DTL
  ADD CONSTRAINT DEPOSIT_DTL_PK PRIMARY KEY (COMPANY_ID, DEPOSIT_NO, SC_TXN_NO);

CREATE TABLE WKEXS.DEPOSIT_HDR
  (COMPANY_ID VARCHAR2(20) NOT NULL,
   DEPOSIT_NO VARCHAR2(17) NOT NULL,
   BANK_ID VARCHAR2(50) NULL,
   CUSTOMER_ID NUMBER(8, 0) NULL,
   DEPOSIT_DATE DATE NULL,
   CURRENCY_ID VARCHAR2(3) NULL,
   STATUS VARCHAR2(5) NULL,
   TTL_AMT NUMBER(12, 2) NULL,
   BANK_IN_DATE DATE NULL,
   REMARKS VARCHAR2(4000) NULL,
   CREATE_DTTM DATE NULL,
   CREATE_BY VARCHAR2(15) NULL,
   LAST_MODIFY_DTTM DATE NULL,
   LAST_MODIFY_BY VARCHAR2(15) NULL,
   VOID_DTTM DATE NULL,
   VOID_BY VARCHAR2(15) NULL,
   LATEST_SHIP_DATE DATE NULL);

ALTER TABLE WKEXS.DEPOSIT_HDR
  ADD CONSTRAINT DEPOSIT_HDR_PK PRIMARY KEY (COMPANY_ID, DEPOSIT_NO);

CREATE TABLE WKEXS.DISTRICT_DTL
  (COMPANY_ID VARCHAR2(20) NOT NULL,
   DISTRICT_ID VARCHAR2(5) NOT NULL,
   CONTAINER_SIZE VARCHAR2(20) NOT NULL,
   TON_PER_CONTAINER NUMBER(12, 3) NULL);

ALTER TABLE WKEXS.DISTRICT_DTL
  ADD CONSTRAINT DISTRICT_DTL_PK PRIMARY KEY (COMPANY_ID, DISTRICT_ID, CONTAINER_SIZE);

CREATE TABLE WKEXS.DISTRICT_HDR
  (COMPANY_ID VARCHAR2(20) NOT NULL,
   DISTRICT_ID VARCHAR2(5) NOT NULL,
   DESCRIPTION VARCHAR2(800) NULL,
   CREATE_DTTM DATE NULL,
   CREATE_BY VARCHAR2(15) NULL,
   LAST_MODIFY_DTTM DATE NULL,
   LAST_MODIFY_BY VARCHAR2(15) NULL);

ALTER TABLE WKEXS.DISTRICT_HDR
  ADD CONSTRAINT DISTRICT_HDR_PK PRIMARY KEY (COMPANY_ID, DISTRICT_ID);

CREATE TABLE WKEXS.FREIGHT_COST
  (COMPANY_ID VARCHAR2(20) NOT NULL,
   SHIP_LINE_ID VARCHAR2(20) NOT NULL,
   LOADING_PORT_ID VARCHAR2(10) NOT NULL,
   DISCHARGE_PORT_ID VARCHAR2(10) NOT NULL,
   VALIDITY_DATE_FROM DATE NOT NULL,
   VALIDITY_DATE_TO DATE NOT NULL,
   CONTAINER_SIZE VARCHAR2(20) NOT NULL,
   CURRENCY_ID VARCHAR2(3) NULL,
   OCEAN_FREIGHT NUMBER(13, 5) NULL,
   BAF NUMBER(13, 5) NULL,
   CAF NUMBER(13, 5) NULL,
   FAF NUMBER(13, 5) NULL,
   GRI NUMBER(13, 5) NULL,
   PSS NUMBER(13, 5) NULL,
   WRS NUMBER(13, 5) NULL,
   ISPS NUMBER(13, 5) NULL,
   F_OTHER_CHARGE NUMBER(13, 5) NULL,
   CREATE_DTTM DATE NULL,
   CREATE_BY VARCHAR2(15) NULL,
   LAST_MODIFY_DTTM DATE NULL,
   LAST_MODIFY_BY VARCHAR2(15) NULL);

ALTER TABLE WKEXS.FREIGHT_COST
  ADD CONSTRAINT FREIGHT_COST_PK PRIMARY KEY (COMPANY_ID, SHIP_LINE_ID, LOADING_PORT_ID, DISCHARGE_PORT_ID, VALIDITY_DATE_FROM, VALIDITY_DATE_TO, CONTAINER_SIZE);

CREATE TABLE WKEXS.FREIGHT_COST_IMPORT_TMP
  (COMPANY_ID VARCHAR2(20) NOT NULL,
   ITEM_ID VARCHAR2(20) NOT NULL,
   SHIP_LINE_ID VARCHAR2(20) NOT NULL,
   LOADING_PORT_ID VARCHAR2(10) NOT NULL,
   DISCHARGE_PORT_ID VARCHAR2(10) NOT NULL,
   VALIDITY_DATE_FROM DATE NOT NULL,
   VALIDITY_DATE_TO DATE NOT NULL,
   CONTAINER_SIZE VARCHAR2(20) NOT NULL,
   CURRENCY_ID VARCHAR2(3) NOT NULL,
   OCEAN_FREIGHT NUMBER(13, 5) NULL,
   BAF NUMBER(13, 5) NULL,
   CAF NUMBER(13, 5) NULL,
   FAF NUMBER(13, 5) NULL,
   GRI NUMBER(13, 5) NULL,
   PSS NUMBER(13, 5) NULL,
   WRS NUMBER(13, 5) NULL,
   ISPS NUMBER(13, 5) NULL,
   F_OTHER_CHARGE NUMBER(13, 5) NULL,
   ERR_DB_COMPANY_ID_EXIST VARCHAR2(1) NULL,
   ERR_DB_SHIP_LINE_EXIST VARCHAR2(1) NULL,
   ERR_DB_LOADING_PORT_ID_EXIST VARCHAR2(1) NULL,
   ERR_DB_DISCHARGE_PORT_ID_EXIST VARCHAR2(1) NULL,
   ERR_DB_CURRENCY_ID_EXIST VARCHAR2(1) NULL,
   ERR_DB_CONTAINER_SIZE_EXIST VARCHAR2(1) NULL,
   ERR_DB_SINGLE_CURRENCY VARCHAR2(1) NULL,
   ERR_DB_KEY VARCHAR2(1) NULL,
   ERR_TYPE VARCHAR2(1) NULL);

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -