SSS测试数据库设计

最新推荐文章于 2023-08-16 14:41:51 发布

原创最新推荐文章于 2023-08-16 14:41:51 发布 · 2.8k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#数据库 #测试 #table

10.LAMOST 专栏收录该内容

48 篇文章

订阅专栏

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

MINIFIBER
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 MINIFIBER(FIBER_ID NUMERIC(10),FIBER_X NUMERIC(8,5),FIBER_Y NUMERIC(8,5),FIBER_R NUMERIC(8,5),FIBER_CCD NUMERIC(2));