Newer
Older
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
CREATE TABLE plates (WELL_CODE VARCHAR NOT NULL, MATERIAL_CODE VARCHAR NOT NULL, ABASE_COMPOUND_ID VARCHAR NOT NULL, ABASE_COMPOUND_BATCH_ID VARCHAR NOT NULL, ABASE_PLATE_CODE VARCHAR NOT NULL);
INSERT INTO plates (well_code, material_code, abase_compound_id, abase_compound_batch_id, abase_plate_code) values ('A001', 'COMPOUND-1', 'ABASE Compound (1)', 'ABASE Batch Compound (1)', 'PLATE1');
INSERT INTO plates (well_code, material_code, abase_compound_id, abase_compound_batch_id, abase_plate_code) values ('A002', 'COMPOUND-2', 'ABASE Compound (1)', 'ABASE Batch Compound (1)', 'PLATE1');
INSERT INTO plates (well_code, material_code, abase_compound_id, abase_compound_batch_id, abase_plate_code) values ('A003', 'COMPOUND-3', 'ABASE Compound (1)', 'ABASE Batch Compound (1)', 'PLATE1');
INSERT INTO plates (well_code, material_code, abase_compound_id, abase_compound_batch_id, abase_plate_code) values ('A004', 'COMPOUND-4', 'ABASE Compound (1)', 'ABASE Batch Compound (1)', 'PLATE1');
INSERT INTO plates (well_code, material_code, abase_compound_id, abase_compound_batch_id, abase_plate_code) values ('A005', 'COMPOUND-5', 'ABASE Compound (1)', 'ABASE Batch Compound (1)', 'PLATE1');
INSERT INTO plates (well_code, material_code, abase_compound_id, abase_compound_batch_id, abase_plate_code) values ('A006', 'COMPOUND-6', 'ABASE Compound (1)', 'ABASE Batch Compound (1)', 'PLATE1');
INSERT INTO plates (well_code, material_code, abase_compound_id, abase_compound_batch_id, abase_plate_code) values ('A007', 'COMPOUND-7', 'ABASE Compound (1)', 'ABASE Batch Compound (1)', 'PLATE1');
INSERT INTO plates (well_code, material_code, abase_compound_id, abase_compound_batch_id, abase_plate_code) values ('A008', 'COMPOUND-8', 'ABASE Compound (1)', 'ABASE Batch Compound (1)', 'PLATE1');
INSERT INTO plates (well_code, material_code, abase_compound_id, abase_compound_batch_id, abase_plate_code) values ('A009', 'COMPOUND-9', 'ABASE Compound (1)', 'ABASE Batch Compound (1)', 'PLATE1');
INSERT INTO plates (well_code, material_code, abase_compound_id, abase_compound_batch_id, abase_plate_code) values ('A010', 'COMPOUND-10', 'ABASE Compound (1)', 'ABASE Batch Compound (1)', 'PLATE1');
INSERT INTO plates (well_code, material_code, abase_compound_id, abase_compound_batch_id, abase_plate_code) values ('A011', 'COMPOUND-11', 'ABASE Compound (1)', 'ABASE Batch Compound (1)', 'PLATE1');
INSERT INTO plates (well_code, material_code, abase_compound_id, abase_compound_batch_id, abase_plate_code) values ('A012', 'COMPOUND-12', 'ABASE Compound (1)', 'ABASE Batch Compound (1)', 'PLATE1');
INSERT INTO plates (well_code, material_code, abase_compound_id, abase_compound_batch_id, abase_plate_code) values ('A013', 'COMPOUND-13', 'ABASE Compound (1)', 'ABASE Batch Compound (1)', 'PLATE1');
INSERT INTO plates (well_code, material_code, abase_compound_id, abase_compound_batch_id, abase_plate_code) values ('A014', 'COMPOUND-14', 'ABASE Compound (1)', 'ABASE Batch Compound (1)', 'PLATE1');
INSERT INTO plates (well_code, material_code, abase_compound_id, abase_compound_batch_id, abase_plate_code) values ('A015', 'COMPOUND-15', 'ABASE Compound (1)', 'ABASE Batch Compound (1)', 'PLATE1');
INSERT INTO plates (well_code, material_code, abase_compound_id, abase_compound_batch_id, abase_plate_code) values ('A016', 'COMPOUND-16', 'ABASE Compound (1)', 'ABASE Batch Compound (1)', 'PLATE1');
INSERT INTO plates (well_code, material_code, abase_compound_id, abase_compound_batch_id, abase_plate_code) values ('A017', 'COMPOUND-17', 'ABASE Compound (1)', 'ABASE Batch Compound (1)', 'PLATE1');
INSERT INTO plates (well_code, material_code, abase_compound_id, abase_compound_batch_id, abase_plate_code) values ('A018', 'COMPOUND-18', 'ABASE Compound (1)', 'ABASE Batch Compound (1)', 'PLATE1');
INSERT INTO plates (well_code, material_code, abase_compound_id, abase_compound_batch_id, abase_plate_code) values ('A019', 'COMPOUND-19', 'ABASE Compound (1)', 'ABASE Batch Compound (1)', 'PLATE1');
INSERT INTO plates (well_code, material_code, abase_compound_id, abase_compound_batch_id, abase_plate_code) values ('A020', 'COMPOUND-20', 'ABASE Compound (1)', 'ABASE Batch Compound (1)', 'PLATE1');
INSERT INTO plates (well_code, material_code, abase_compound_id, abase_compound_batch_id, abase_plate_code) values ('A021', 'COMPOUND-21', 'ABASE Compound (1)', 'ABASE Batch Compound (1)', 'PLATE1');
INSERT INTO plates (well_code, material_code, abase_compound_id, abase_compound_batch_id, abase_plate_code) values ('A022', 'COMPOUND-22', 'ABASE Compound (1)', 'ABASE Batch Compound (1)', 'PLATE1');
INSERT INTO plates (well_code, material_code, abase_compound_id, abase_compound_batch_id, abase_plate_code) values ('A023', 'COMPOUND-23', 'ABASE Compound (1)', 'ABASE Batch Compound (1)', 'PLATE1');
INSERT INTO plates (well_code, material_code, abase_compound_id, abase_compound_batch_id, abase_plate_code) values ('A024', 'COMPOUND-24', 'ABASE Compound (1)', 'ABASE Batch Compound (1)', 'PLATE1');
INSERT INTO plates (well_code, material_code, abase_compound_id, abase_compound_batch_id, abase_plate_code) values ('P001', 'COMPOUND-1', 'ABASE Compound (1)', 'ABASE Batch Compound (1)', 'PLATE1');
INSERT INTO plates (well_code, material_code, abase_compound_id, abase_compound_batch_id, abase_plate_code) values ('P002', 'COMPOUND-2', 'ABASE Compound (1)', 'ABASE Batch Compound (1)', 'PLATE1');
INSERT INTO plates (well_code, material_code, abase_compound_id, abase_compound_batch_id, abase_plate_code) values ('P003', 'COMPOUND-3', 'ABASE Compound (1)', 'ABASE Batch Compound (1)', 'PLATE1');
INSERT INTO plates (well_code, material_code, abase_compound_id, abase_compound_batch_id, abase_plate_code) values ('P004', 'COMPOUND-4', 'ABASE Compound (1)', 'ABASE Batch Compound (1)', 'PLATE1');
INSERT INTO plates (well_code, material_code, abase_compound_id, abase_compound_batch_id, abase_plate_code) values ('P005', 'COMPOUND-5', 'ABASE Compound (1)', 'ABASE Batch Compound (1)', 'PLATE1');
INSERT INTO plates (well_code, material_code, abase_compound_id, abase_compound_batch_id, abase_plate_code) values ('P006', 'COMPOUND-6', 'ABASE Compound (1)', 'ABASE Batch Compound (1)', 'PLATE1');
INSERT INTO plates (well_code, material_code, abase_compound_id, abase_compound_batch_id, abase_plate_code) values ('P007', 'COMPOUND-7', 'ABASE Compound (1)', 'ABASE Batch Compound (1)', 'PLATE1');
INSERT INTO plates (well_code, material_code, abase_compound_id, abase_compound_batch_id, abase_plate_code) values ('P008', 'COMPOUND-8', 'ABASE Compound (1)', 'ABASE Batch Compound (1)', 'PLATE1');
INSERT INTO plates (well_code, material_code, abase_compound_id, abase_compound_batch_id, abase_plate_code) values ('P009', 'COMPOUND-9', 'ABASE Compound (1)', 'ABASE Batch Compound (1)', 'PLATE1');
INSERT INTO plates (well_code, material_code, abase_compound_id, abase_compound_batch_id, abase_plate_code) values ('P010', 'COMPOUND-10', 'ABASE Compound (1)', 'ABASE Batch Compound (1)', 'PLATE1');
INSERT INTO plates (well_code, material_code, abase_compound_id, abase_compound_batch_id, abase_plate_code) values ('P011', 'COMPOUND-11', 'ABASE Compound (1)', 'ABASE Batch Compound (1)', 'PLATE1');
INSERT INTO plates (well_code, material_code, abase_compound_id, abase_compound_batch_id, abase_plate_code) values ('P012', 'COMPOUND-12', 'ABASE Compound (1)', 'ABASE Batch Compound (1)', 'PLATE1');
INSERT INTO plates (well_code, material_code, abase_compound_id, abase_compound_batch_id, abase_plate_code) values ('P013', 'COMPOUND-13', 'ABASE Compound (1)', 'ABASE Batch Compound (1)', 'PLATE1');
INSERT INTO plates (well_code, material_code, abase_compound_id, abase_compound_batch_id, abase_plate_code) values ('P014', 'COMPOUND-14', 'ABASE Compound (1)', 'ABASE Batch Compound (1)', 'PLATE1');
INSERT INTO plates (well_code, material_code, abase_compound_id, abase_compound_batch_id, abase_plate_code) values ('P015', 'COMPOUND-15', 'ABASE Compound (1)', 'ABASE Batch Compound (1)', 'PLATE1');
INSERT INTO plates (well_code, material_code, abase_compound_id, abase_compound_batch_id, abase_plate_code) values ('P016', 'COMPOUND-16', 'ABASE Compound (1)', 'ABASE Batch Compound (1)', 'PLATE1');
INSERT INTO plates (well_code, material_code, abase_compound_id, abase_compound_batch_id, abase_plate_code) values ('P017', 'COMPOUND-17', 'ABASE Compound (1)', 'ABASE Batch Compound (1)', 'PLATE1');
INSERT INTO plates (well_code, material_code, abase_compound_id, abase_compound_batch_id, abase_plate_code) values ('P018', 'COMPOUND-18', 'ABASE Compound (1)', 'ABASE Batch Compound (1)', 'PLATE1');
INSERT INTO plates (well_code, material_code, abase_compound_id, abase_compound_batch_id, abase_plate_code) values ('P019', 'COMPOUND-19', 'ABASE Compound (1)', 'ABASE Batch Compound (1)', 'PLATE1');
INSERT INTO plates (well_code, material_code, abase_compound_id, abase_compound_batch_id, abase_plate_code) values ('P020', 'COMPOUND-20', 'ABASE Compound (1)', 'ABASE Batch Compound (1)', 'PLATE1');
INSERT INTO plates (well_code, material_code, abase_compound_id, abase_compound_batch_id, abase_plate_code) values ('P021', 'COMPOUND-21', 'ABASE Compound (1)', 'ABASE Batch Compound (1)', 'PLATE1');
INSERT INTO plates (well_code, material_code, abase_compound_id, abase_compound_batch_id, abase_plate_code) values ('P022', 'COMPOUND-22', 'ABASE Compound (1)', 'ABASE Batch Compound (1)', 'PLATE1');
INSERT INTO plates (well_code, material_code, abase_compound_id, abase_compound_batch_id, abase_plate_code) values ('P023', 'COMPOUND-23', 'ABASE Compound (1)', 'ABASE Batch Compound (1)', 'PLATE1');
INSERT INTO plates (well_code, material_code, abase_compound_id, abase_compound_batch_id, abase_plate_code) values ('P024', 'COMPOUND-24', 'ABASE Compound (1)', 'ABASE Batch Compound (1)', 'PLATE1');