CREATE DATABASE labhibernate;
USE labhibernate;
-- --------------------------------------------------------------------------------------------------
CREATE TABLE person(
    p_id int AUTO_INCREMENT,
    p_name varchar(256),
    p_surname varchar(256),
    p_email varchar(64),
    CONSTRAINT person_p_id_pk PRIMARY KEY(p_id)
);
-- --------------------------------------------------------------------------------------------------
CREATE TABLE address_info(
    ai_id int AUTO_INCREMENT,
    ai_p_id int,
    street varchar(255),
    house_number varchar(10),
    town varchar(255),
    state varchar(64),
    country varchar(64),
    CONSTRAINT address_ai_id_pk PRIMARY KEY(ai_id),
    CONSTRAINT address_ai_p_id_fk FOREIGN KEY (ai_p_id) REFERENCES person(p_id)
);
-- ------------------------------------------------------------------------------------------------