TAT7PfSP

1DROP TABLE IF EXISTS soc;
2DROP TABLE IF EXISTS pt;
3DROP TABLE IF EXISTS llt;
4
5CREATE TABLE soc (
6	soc_code BIGINT constraint ix1_soc01 PRIMARY KEY,
7	soc_name varchar(100) constraint ix1_soc02 NOT NULL,
8	soc_abbrev varchar(5) NOT NULL,
9	soc_whoart_code varchar(7),
10	soc_harts_code BIGINT,
11	soc_costart_sym varchar(21),
12	soc_icd9_code varchar(8),
13	soc_icd9cm_code varchar(8),
14	soc_icd10_code varchar(8),
15	soc_jart_code varchar(8),
16	x varchar(1)
17);
18
19CREATE TABLE pt (
20	pt_code BIGINT constraint ix1_pt01 PRIMARY KEY,
21	pt_name varchar(100) constraint ix1_pt02 NOT NULL,
22	null_field varchar(1),
23	pt_soc_code BIGINT,
24	pt_whoart_code varchar(7),
25	pt_harts_code BIGINT,
26	pt_costart_sym varchar(21),
27	pt_icd9_code varchar(8),
28	pt_icd9cm_code varchar(8),
29	pt_icd10_code varchar(8),
30	pt_jart_code varchar(6),
31	x varchar(1)
32);
33
34CREATE TABLE llt (
35	llt_code BIGINT constraint ix1_pt_llt01 PRIMARY KEY,
36	llt_name varchar(100) constraint ix1_pt_llt02 NOT NULL,
37	pt_code BIGINT,
38	llt_whoart_code varchar(7),
39	llt_harts_code BIGINT,
40	llt_costart_sym varchar(21),
41	llt_icd9_code varchar(8),
42	llt_icd9cm_code varchar(8),
43	llt_icd10_code varchar(8),
44	llt_currency varchar(1),
45	llt_jart_code varchar(6),
46	x varchar(1)
47);
48
49COPY soc 
50FROM '/Users/neil/Documents/MMM/MedDRA_15_0_English/MedAscii/soc.asc'
51WITH 
52	DELIMITER AS '$' 
53	NULL AS '';
54
55COPY pt 
56FROM '/Users/neil/Documents/MMM/MedDRA_15_0_English/MedAscii/pt.asc'
57WITH 
58	DELIMITER AS '$' 
59	NULL AS '';
60
61COPY llt 
62FROM '/Users/neil/Documents/MMM/MedDRA_15_0_English/MedAscii/llt.asc'
63WITH 
64	DELIMITER AS '$' 
65	NULL AS '';
66
67ALTER TABLE soc DROP COLUMN x;
68ALTER TABLE pt DROP COLUMN x;
69ALTER TABLE llt DROP COLUMN x;