create database test;
use test;

create table member (
member_id varchar(10),
name varchar(10),
sex varchar(1),
primary key (member_id)
) ;

create table orders (
Order_id varchar(10),
total_price float,
member_id char(10),
primary key (Order_id)
) ;

alter table orders
add constraint FK_MEMBER_ID
foreign key (member_id)
references member (member_id);