SSS测试数据库设计

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));

FIBERFIBER_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));

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

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