数据库: oracle 10g
1. 物理模型图
2. 建表sql
2.1 省
create table PROVINCE
(
PROVINCE_ID VARCHAR2(36) primary key,
PROVINCE_CODE VARCHAR2(20) not null,
PROVINCE_NAME VARCHAR2(20) not null,
CREATE_TIME DATE not null
);
2.2 城市
create table CITY
(
CITY_ID VARCHAR2(36) primary key,
PROVINCE_ID VARCHAR2(36),
CITY_CODE VARCHAR2(20) not null,
CITY_NAME VARCHAR2(20) not null,
CREATE_TIME DATE
)
alter table CITY
add constraint FK__PROVINCE__CITY foreign key (PROVINCE_ID)
references PROVINCE (PROVINCE_ID);
3. 数据
2个表的数据见附件 data.rar