[MySQL] 명령어들

create table lifejacket(
    SN VARCHAR(5) not null,
    EmergencyOn int,
    warningOn int,
    primary key(SN)
);

create table Record(
    RecordNo int AUTO_INCREMENT,
    SN varchar(5),
    lat double, longt double,
    GPStime timestamp default CURRENT_TIMESTAMP on UPdate CURRENT_TIMESTAMP,
    PRIMARY KEY(RecordNo), FOREIGN KEY (SN) REFERENCES lifejacket(SN) on delete cascade
);

create table rent(
    RentNo int AUTO_INCREMENT,
    SN varchar(5),
    hp varchar(13),
    user varchar(10),
    renttime timestamp default CURRENT_TIMESTAMP on UPdate CURRENT_TIMESTAMP,
    wearer varchar(10),
    WearerAge int,

    PRIMARY KEY(RentNo),
    FOREIGN KEY (SN) REFERENCES lifejacket(SN) on delete cascade
);