表结构以及索引如下:
create table test
(
ID INTEGER not null, --id是主键
IS_DELETED NUMBER(1) not null,
CREATOR VARCHAR2(255),
MODIFIOR VARCHAR2(255),
PLATENUMBER VARCHAR2(15),
PLATETYPE VARCHAR2(16),
LANENAME VARCHAR2(40),
PLATECOLOR VARCHAR2(16),
SPEED INTEGER,
PASSTIME DATE,
PICTYPE INTEGER,
FIRSTPICPATH VARCHAR2(128),
SECONDPICPATH VARCHAR2(128),
PLATERECTTOP INTEGER,
PLATERECTLEFT INTEGER,
PLATERECTWIDTH INTEGER,
PLATERECTHEIGHT INTEGER,
SELPICNO NUMBER(6),
STATUS NUMBER(6),
DIRECTION VARCHAR2(32),
PASSPORTNAME VARCHAR2(64),
DATENUMBER NUMBER(14) not null,-