使用plsql编程为会员会员号等级号姓名性别年龄工作单位电话号码地址积分数量生日主键：会员号 外键：等级号订单订单号商品号会员号地址订单数量价格订单日期主键：订单号 外键：商品号会员号商品商品号商品名称类别单价数量主键：商品号 积分信息积分号会员号积分数量主键：积分号 外键：会员号积分兑换兑换号会员号商品号剩余积分主键：兑换号 外键：商品号会员号会员等级等级号等级名称等级条件享受折扣优惠时间主键

创建会员表：

CREATE TABLE member ( member_id NUMBER PRIMARY KEY, level_id NUMBER REFERENCES member_level(level_id), name VARCHAR2(50), gender VARCHAR2(10), age NUMBER, employer VARCHAR2(50), phone_number VARCHAR2(20), address VARCHAR2(100), points NUMBER, birthday DATE );

创建订单表：

CREATE TABLE orders ( order_id NUMBER PRIMARY KEY, product_id NUMBER REFERENCES product(product_id), member_id NUMBER REFERENCES member(member_id), address VARCHAR2(100), order_quantity NUMBER, price NUMBER, order_date DATE );

创建商品表：

CREATE TABLE product ( product_id NUMBER PRIMARY KEY, product_name VARCHAR2(50), category VARCHAR2(50), unit_price NUMBER, quantity NUMBER );

创建积分信息表：

CREATE TABLE points_info ( points_id NUMBER PRIMARY KEY, member_id NUMBER REFERENCES member(member_id), points NUMBER );

创建积分兑换表：

CREATE TABLE points_exchange ( exchange_id NUMBER PRIMARY KEY, member_id NUMBER REFERENCES member(member_id), product_id NUMBER REFERENCES product(product_id), remaining_points NUMBER );

创建会员等级表：

CREATE TABLE member_level ( level_id NUMBER PRIMARY KEY, level_name VARCHAR2(50), level_condition VARCHAR2(100), discount NUMBER, promotion_date DATE )