主键
CREATE TABLE user_info (
ID CHAR (36) PRIMARY KEY,
user_name VARCHAR (30) NOT NULL,
PASSWORD VARCHAR (30) NOT NULL
);
外键
CREATE TABLE address (
ID CHAR (36) PRIMARY KEY,
user_info_id CHAR (36),
real_name VARCHAR (8) NOT NULL,
mobile CHAR (11) NOT NULL,
address VARCHAR (150) NOT NULL,
CONSTRAINT address_user_info_id_fk FOREIGN KEY (user_info_id) REFERENCES user_info (ID)
);