省级城市主外键建立的SQL

CREATE TABLE tm_province (
  provice_id number(38) NOT NULL,
  province varchar(200) NOT NULL,
  province_code number(30)NOT NULL
)
CREATE TABLE tm_city (
  city_id number(30) NOT NULL,
  city varchar(200) NOT NULL,
  provice_id number(30) NOT NULL
)
CREATE TABLE tm_area (
  area_id number(38) NOT NULL,
  area varchar(200) NOT NULL,
  city_id  number(11) NOT NULL
)


select * from tm_province;
select * from tm_city;
select * from tm_area

alter table tm_province add primary key(provice_id);
alter table tm_city add primary key(city_id);
alter table tm_area add primary key(area_id);
commit
alter table tm_city add foreign key(provice_id) references tm_province(provice_id);
alter table tm_area add foreign key(city_id) references tm_city(city_id);