数据库sql语句举例(oracle10g)
来源:互联网 发布:js获取两位数月份 编辑:程序博客网 时间:2024/05/21 08:57
一、第一部分
create table t_accusation (
accusation_id integer primary key,
teacher_accusation_content varchar2(2000),
student_accusation_time date,
teacher_accusation_time date,
i_id integer references t_interact(INTERACT_ID) unique,
student_accusation_content varchar2(2000)
);
create table t_interact(
interact_id integer primary key,
interact_name varchar2(50),--互动标题
interact_detail varchar2(2000),---互动详细内容
department varchar2(50),--学生院系
student_name varchar2(10),--学生名称
teacher_name varchar2(10),--老师名称
flag_answer char(1),--是否回复
answer_content varchar2(2000),--回答内容
flag_estimate char(1),--是否评价
estimate_content varchar2(2000),--评价内容
tuid integer,--老师id
sid integer,--学生id
score number(5,2),--评分
create_date date,--互动创建时间
answer_time date,--回复时间
estimate_time date,--评价时间
teacher_department varchar2(50),--老师院系
flag_teacher_accusation char(1),--老师是否举报
flag_student_accusation char(1)--学生是否举报
);
commit;
create table t_user(user_id integer primary key,
username varchar2(50),
password varchar2(50),
realname varchar2(10),
department varchar2(50),
role varchar2(10) check (role in('student','teacher')));
commit;
二、第二部分
/*==============================================================*//* Table: t_category --day2商品类别表 */
/*==============================================================*/
create table t_category (
id integer not null,
category_name varchar2(50 byte),
create_date date,
last_modify_date date,
c_level integer,
parent_category_id integer,--不是关系属性
constraint pk_t_category primary key (id)
);
alter table t_category
add constraint fk_t_catego_reference_t_catego foreign key (parent_category_id)
references t_category (id);
create sequence t_category_seq;
/*==============================================================*/
/* Table: t_param_group day3\4商品参数组 表 */
/*==============================================================*/
create table t_param_group (
id integer not null,
name varchar2(30),
create_date date,
last_modify_date date,
order_num integer,
t_category_id integer,--该列不是实体属性
constraint pk_t_param_group primary key (id)
);
alter table t_param_group
add constraint fk_t_param__reference_t_catego foreign key (t_category_id)
references t_category (id);
create sequence t_param_group_seq;
/*==============================================================*/
/* Table: t_param_item day3\4商品参数项表 */
/*==============================================================*/
create table t_param_item (
id integer not null,
name varchar2(30),
order_num integer,
create_date date,
last_modify_date date,
t_param_group_id integer,--该列不是实体属性
constraint pk_t_param_item primary key (id)
);
alter table t_param_item
add constraint fk_t_param__reference_t_param_ foreign key (t_param_group_id)
references t_param_group (id);
/*==============================================================*/
/* Table: t_attr_group day5 参数组的属性 */
/*==============================================================*/
create table t_attr_group (
id integer not null,
name varchar2(60 byte),
create_date date,
last_modify_date date,
order_num integer,
property_index integer,
t_category_id integer,--此列不是属性
constraint pk_t_attr_group primary key (id)
);
alter table t_attr_group
add constraint fk_t_attr_g_reference_t_catego foreign key (t_category_id)
references t_category (id);
create sequence t_attr_group_seq;
/*==============================================================*/
/* Table: t_attr_item day5参数项的属性 */
/*==============================================================*/
create table t_attr_item (
id integer not null,
name varchar2(60 byte),
order_num integer,
create_date date,
last_modify_date date,
t_attr_id integer,--此列不是属性
constraint pk_t_attr_item primary key (id)
);
alter table t_attr_item
add constraint fk_t_attr_i_reference_t_attr_g foreign key (t_attr_id)
references t_attr_group (id);
create sequence t_attr_item_seq;
/*=============================================================*/
/* Table: t_specification_group day6规格组 */
/*==============================================================*/
create table t_specification_group (
id integer not null,
name varchar2(50 byte),
type varchar2(30 byte),--图片或文本
create_date date,
last_modify_date date,
order_num char(10), --可以改为number(20)
description varchar2(60 byte), --即备注
constraint pk_t_specification_group primary key (id)
);
alter table t_specification_item
add constraint fk_t_specif_reference_t_specif foreign key (t_specification_group_id)
references t_specification_group (id);
/*==============================================================*/
/* Table: t_specification_item day6规格项 */
/*==============================================================*/
create table t_specification_item (
id integer not null,
name varchar2(50 byte),
order_num integer,
create_date date,
last_modify_date date,
img_url varchar2(60 byte),
t_specification_group_id integer,--不是属性
constraint pk_t_specification_item primary key (id)
);
create sequence t_specification_item_seq;
/*==============================================================*/
/* Table: t_param_value */
/*==============================================================*/
create table t_param_value (
id integer not null,
param_value varchar2(30 byte),
t_product_id integer,
t_param_value_id integer,
constraint pk_t_param_value primary key (id)
);
/*==============================================================*/
/* Table: t_product */
/*==============================================================*/
create table t_product (
id integer not null,
product_no integer,
name varchar2(30 byte),
marker_price number,
sell_price number,
create_date date,
logo_img varchar2(200 byte),
description varchar2(400 byte),
attr_item_0 varchar2(100),
attr_item_2 varchar2(100),
attr_item_1 varchar2(100 byte),
attr_item_3 varchar2(100 byte),
attr_item_4 varchar2(100 byte),
attr_item_5 varchar2(100 byte),
attr_item_6 varchar2(100 byte),
attr_item_7 varchar2(100 byte),
attr_item_8 varchar2(100 byte),
attr_item_9 varchar2(100 byte),
is_sellable varchar2(100 byte),
t_category_id integer,
constraint pk_t_product primary key (id)
);
/*==============================================================*/
/* Table: t_product_image */
/*==============================================================*/
create table t_product_image (
id integer not null,
title varchar2(200 byte),
ordernum integer,
original_image varchar2(200 byte),
middle_image varchar2(200 byte),
small_image varchar2(200 byte),
t_product_id integer,
constraint pk_t_product_image primary key (id)
);
/*=============================================================*/
/* Table: t_product_speci_combo */
/*==============================================================*/
create table t_product_speci_combo (
id integer not null,
t_speci_group_id integer,
t_speci_item_id integer,
t_product_id integer,
t_flag_num integer,
constraint pk_t_product_speci_combo primary key (id)
);
--建立关系的语句
alter table t_param_value
add constraint fk_t_param__reference_t_produc foreign key (t_product_id)
references t_product (id);
alter table t_param_value
add constraint fk_t_param__reference_t_pavam_ foreign key (t_param_value_id)
references t_param_item (id);
alter table t_product
add constraint fk_t_produc_reference_t_catego foreign key (t_category_id)
references t_category (id);
alter table t_product_image
add constraint fk_t_produc_refsence_t_produc foreign key (t_product_id)
references t_product (id);
alter table t_product_speci_combo
add constraint fk_t_produc_reference_t_specif foreign key (t_speci_group_id)
references t_specification_group (id);
alter table t_product_speci_combo
add constraint fk_t_produc_rerence_t_specif foreign key (t_speci_item_id)
references t_specification_item (id);
alter table t_product_speci_combo
add constraint fk_t_produc_reference_t_produc foreign key (t_product_id)
references t_product (id);
- 数据库sql语句举例(oracle10g)
- Oracle10g数据库常用语句
- sql常用语句,举例
- SQL语句举例
- 高级SQL语句简单举例
- Oracle10g数据库体系结构的关键特性(sql命令查看)
- Oracle10g里sql语句的执行计划
- 如何进行oracle10g的sql语句跟踪
- Access数据库字段类型 及修改Alter字段类型的SQL语句举例
- 数据库操作语句(SQL)
- sql查询语句select 应用举例
- SQL Server数据库备份(SQL 语句)!
- jdbc链接数据库(oracle10g)
- 举例详解—标准SQL的9种语句(重点之三)
- Oracle10g获取sql语句的执行计划详解!
- Oracle10g的SQL语句的解析和执行
- Oracle10g 数据库
- Oracle10g数据库
- android实现json数据的解析和把数据转换成json格式的字符串
- shell脚本: linux系统的负载与CPU、内存、硬盘、用户数监控
- 深入剖析ThreadLocal(2)
- Ralink “iwpriv ra0 show stat”输出信息含义
- Andrew Ng机器学习课程12
- 数据库sql语句举例(oracle10g)
- 基于用户的协同过滤推荐算法原理和实现
- 《当幸福来敲门》
- 在Android studio 下 获取SHA1 签名证书
- ListView工作流程
- Android中实现短信验证功能
- hiho1234--Fractal(高精度)
- 知道怎么修改自己程序版本号吗?
- 参数寻优问题详细解析