学步园

OBVOBJECT(SDSS DR1)
OBJ_ID                  NUMBER(10)
OBJ_RA                  NUMBER(8,5)
OBJ_DE                  NUMBER(8,5)
OBJ_MAG               NUMBER(4,2)
OBJ_PRI                 NUMBER(2)
OBJ_STATUS          NUMBER(2)

create table OBVOBJCET(OBJ_ID NUMERIC(10),OBJ_RA NUMERIC(8,5),OBJ_DE NUMERIC(8,5),OBJ_MAG NUMERIC(4,2),OBJ_PRI NUMERIC(2),OBJ_STATUS NUMERIC(2));

create index OBJ_ID on OBVOBJECT(OBJ_ID);

create index OBJ_RA_DE on OBVOBJECT(OBJ_RA,OBJ_DE);

SKYLIGHT(USNO2.0)
SL_ID                   NUMBER(10)
SL_RA                   NUMBER(8,5)
SL_DE                   NUMBER(8,5)

create table SKYLIGHT(SL_ID NUMERIC(10),SL_RA NUMERIC(8,5),SL_DE NUMERIC(8,5));

FLUXSTANDARD(TYCHO2)
FS_ID                  NUMBER(10)
FS_RA                  NUMBER(8,5)
FS_DE                  NUMBER(8,5)
FS_MAG               NUMBER(4,2)

create table FLUXSTANDARD(FS_ID NUMERIC(10),FS_RA NUMERIC(8,5),FS_DE NUMERIC(8,5),FS_MAG NUMERIC(4,2));

FIBER
FIBER_ID                 NUMBER(4)
FIBER_X                  NUMBER(8,5)
FIBER_Y                  NUMBER(8,5)
FIBER_R                  NUMBER(8,5)
FIBER_CCD             NUMBER(2)

create table FIBER(FIBER_ID NUMERIC(10),FIBER_X NUMERIC(8,5),FIBER_Y NUMERIC(8,5),FIBER_R NUMERIC(8,5),FIBER_CCD NUMERIC(2));