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

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


评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值