5HnX5wby

1drop table if exists card_payment;
2drop table if exists bank_payment;
3drop table if exists persons;
4
5create table card_payment (
6    payment_id int primary key not null,
7    buyer varchar(255) not null,
8    buyer_email varchar(255) not null,
9    payment_date date not null,
10    amount int not null,
11    outcome varchar(255) not null
12    # 2, 3, 4, 5, 6, 11
13);
14
15create table bank_payment (
16    payment_id int primary key not null,
17    buyer varchar(255) not null,
18    payment_date date not null,
19    amount int not null,
20    notes varchar(255) not null
21);
22
23create table persons (
24    person_id int primary key not null,
25    payment_id_f int not null,
26    lastname varchar(255) not null,
27    name varchar(255) not null,
28    street varchar(255) not null,
29    postcode varchar(255) not null,
30    city varchar(255) not null,
31    state varchar(255) not null,
32    country varchar(255) not null,
33    institution varchar(255) not null,
34    position varchar(255) not null,
35    email varchar(255) not null,
36    phone varchar(255) not null,
37    enrolment_date varchar(255) not null,
38    arrival varchar(255) not null,
39    departure varchar(255) not null,
40    reception boolean not null,
41    dinner boolean not null,
42    accomp_dinner int not null,
43    payment_type enum('card', 'onsite', 'transfer') not null,
44    fees_amount int not null,
45    payment_confirmed boolean not null
46    
47    # 0, 1, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 15, 17 not null,
48    # 18, 19, 20, 22, 24, 25, 26
49    
50    # 15 date, 19 bool, 20 bool, 24 payment data, 26 bool
51);