API tools faq
paste
Advertisement
Guest User

arken

a guest
Sep 30th, 2016
113
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 20.69 KB | None | 0 0
raw download clone embed print report
  1. DROP TABLE aliases CASCADE CONSTRAINTS;
  2. DROP TABLE criminals CASCADE CONSTRAINTS;
  3. DROP TABLE crimes CASCADE CONSTRAINTS;
  4. DROP TABLE appeals CASCADE CONSTRAINTS;
  5. DROP TABLE officers CASCADE CONSTRAINTS;
  6. DROP TABLE crime_officers CASCADE CONSTRAINTS;
  7. DROP TABLE crime_charges CASCADE CONSTRAINTS;
  8. DROP TABLE crime_codes CASCADE CONSTRAINTS;
  9. DROP TABLE prob_officers CASCADE CONSTRAINTS;
  10. DROP TABLE sentences CASCADE CONSTRAINTS;
  11. DROP sequence appeals_id_seq;
  12. DROP table prob_contact CASCADE CONSTRAINTS;
  13. CREATE TABLE aliases
  14. (alias_id NUMBER(6),
  15. criminal_id NUMBER(6),
  16. alias VARCHAR2(10));
  17. CREATE TABLE criminals
  18. (criminal_id NUMBER(6),
  19. last VARCHAR2(15),
  20. first VARCHAR2(10),
  21. street VARCHAR2(30),
  22. city VARCHAR2(20),
  23. state CHAR(2),
  24. zip CHAR(5),
  25. phone CHAR(10),
  26. v_status CHAR(1) DEFAULT 'N',
  27. p_status CHAR(1) DEFAULT 'N' );
  28. CREATE TABLE crimes
  29. (crime_id NUMBER(9),
  30. criminal_id NUMBER(6),
  31. classification CHAR(1),
  32. date_charged DATE,
  33. status CHAR(2),
  34. hearing_date DATE,
  35. appeal_cut_date DATE);
  36. CREATE TABLE sentences
  37. (sentence_id NUMBER(6),
  38. criminal_id NUMBER(9),
  39. type CHAR(1),
  40. prob_id NUMBER(5),
  41. start_date DATE,
  42. end_date DATE,
  43. violations NUMBER(3));
  44. CREATE TABLE prob_officers
  45. (prob_id NUMBER(5),
  46. last VARCHAR2(15),
  47. first VARCHAR2(10),
  48. street VARCHAR2(30),
  49. city VARCHAR2(20),
  50. state CHAR(2),
  51. zip CHAR(5),
  52. phone CHAR(10),
  53. email VARCHAR2(30),
  54. status CHAR(1) DEFAULT 'A',
  55. mgr_id NUMBER(5) );
  56. CREATE TABLE officers
  57. (officer_id NUMBER(8),
  58. last VARCHAR2(15),
  59. first VARCHAR2(10),
  60. precinct CHAR(4),
  61. badge VARCHAR2(14),
  62. phone CHAR(10),
  63. status CHAR(1) DEFAULT 'A' );
  64. CREATE TABLE crime_codes
  65. (crime_code NUMBER(3),
  66. code_description VARCHAR2(30));
  67. ALTER TABLE crimes
  68. MODIFY (classification DEFAULT 'U');
  69. ALTER TABLE crimes
  70. ADD (date_recorded DATE DEFAULT SYSDATE);
  71. ALTER TABLE prob_officers
  72. ADD (pager# CHAR(10));
  73. ALTER TABLE aliases
  74. MODIFY (alias VARCHAR2(20));
  75. ALTER TABLE criminals
  76. ADD CONSTRAINT criminals_id_pk PRIMARY KEY (criminal_id);
  77. ALTER TABLE criminals
  78. ADD CONSTRAINT criminals_vstatus_ck CHECK (v_status IN('Y','N'));
  79. ALTER TABLE criminals
  80. ADD CONSTRAINT criminals_pstatus_ck CHECK (p_status IN('Y','N'));
  81. ALTER TABLE aliases
  82. ADD CONSTRAINT aliases_id_pk PRIMARY KEY (alias_id);
  83. ALTER TABLE aliases
  84. ADD CONSTRAINT appeals_criminalid_fk FOREIGN KEY (criminal_id)
  85. REFERENCES criminals(criminal_id);
  86. ALTER TABLE aliases
  87. MODIFY (criminal_id NOT NULL);
  88. ALTER TABLE crimes
  89. ADD CONSTRAINT crimes_id_pk PRIMARY KEY (crime_id);
  90. ALTER TABLE crimes
  91. ADD CONSTRAINT crimes_class_ck CHECK (classification IN('F','M','O','U'));
  92. ALTER TABLE crimes
  93. ADD CONSTRAINT crimes_status_ck CHECK (status IN('CL','CA','IA'));
  94. ALTER TABLE crimes
  95. ADD CONSTRAINT crimes_criminalid_fk FOREIGN KEY (criminal_id)
  96. REFERENCES criminals(criminal_id);
  97. ALTER TABLE crimes
  98. MODIFY (criminal_id NOT NULL);
  99. ALTER TABLE prob_officers
  100. ADD CONSTRAINT probofficers_id_pk PRIMARY KEY (prob_id);
  101. ALTER TABLE prob_officers
  102. ADD CONSTRAINT probofficers_status_ck CHECK (status IN('A','I'));
  103. ALTER TABLE sentences
  104. ADD CONSTRAINT sentences_id_pk PRIMARY KEY (sentence_id);
  105. ALTER TABLE sentences
  106. ADD CONSTRAINT sentences_crimeid_fk FOREIGN KEY (criminal_id)
  107. REFERENCES criminals(criminal_id);
  108. ALTER TABLE sentences
  109. MODIFY (criminal_id NOT NULL);
  110. ALTER TABLE sentences
  111. ADD CONSTRAINT sentences_probid_fk FOREIGN KEY (prob_id)
  112. REFERENCES prob_officers(prob_id);
  113. ALTER TABLE sentences
  114. ADD CONSTRAINT sentences_type_ck CHECK (type IN('J','H','P'));
  115. ALTER TABLE officers
  116. ADD CONSTRAINT officers_id_pk PRIMARY KEY (officer_id);
  117. ALTER TABLE officers
  118. ADD CONSTRAINT officers_status_ck CHECK (status IN('A','I'));
  119. ALTER TABLE crime_codes
  120. ADD CONSTRAINT crimecodes_code_pk PRIMARY KEY (crime_code);
  121.  
  122. CREATE TABLE appeals
  123. (appeal_id NUMBER(5),
  124. crime_id NUMBER(9) NOT NULL,
  125. filing_date DATE,
  126. hearing_date DATE,
  127. status CHAR(1) DEFAULT 'P',
  128. CONSTRAINT appeals_id_pk PRIMARY KEY (appeal_id),
  129. CONSTRAINT appeals_crimeid_fk FOREIGN KEY (crime_id)
  130. REFERENCES crimes(crime_id),
  131. CONSTRAINT appeals_status_ck CHECK (status IN('P','A','D')) );
  132. CREATE TABLE crime_officers
  133. (crime_id NUMBER(9),
  134. officer_id NUMBER(8),
  135. CONSTRAINT crimeofficers_cid_oid_pk PRIMARY KEY (crime_id,officer_id),
  136. CONSTRAINT crimeofficers_crimeid_fk FOREIGN KEY (crime_id)
  137. REFERENCES crimes(crime_id),
  138. CONSTRAINT crimeofficers_officerid_fk FOREIGN KEY (officer_id)
  139. REFERENCES officers(officer_id) );
  140. CREATE TABLE crime_charges
  141. (charge_id NUMBER(10),
  142. crime_id NUMBER(9) NOT NULL,
  143. crime_code NUMBER(3) NOT NULL,
  144. charge_status CHAR(2),
  145. fine_amount NUMBER(7,2),
  146. court_fee NUMBER(7,2),
  147. amount_paid NUMBER(7,2),
  148. pay_due_date DATE,
  149. CONSTRAINT crimecharges_id_pk PRIMARY KEY (charge_id),
  150. CONSTRAINT crimecharges_crimeid_fk FOREIGN KEY (crime_id)
  151. REFERENCES crimes(crime_id),
  152. CONSTRAINT crimecharges_code_fk FOREIGN KEY (crime_code)
  153. REFERENCES crime_codes(crime_code),
  154. CONSTRAINT crimecharges_status_ck CHECK (charge_status IN('PD','GL','NG')) );
  155.  
  156. INSERT INTO crime_codes
  157. VALUES (301,'Agg Assault');
  158. INSERT INTO crime_codes
  159. VALUES (302,'Auto Theft');
  160. INSERT INTO crime_codes
  161. VALUES (303,'Burglary-Business');
  162. INSERT INTO crime_codes
  163. VALUES (304,'Criminal Mischief');
  164. INSERT INTO crime_codes
  165. VALUES (305,'Drug Offense');
  166. INSERT INTO crime_codes
  167. VALUES (306,'Bomb Threat');
  168. INSERT INTO prob_officers (prob_id, last, first, city, status, mgr_id)
  169. VALUES (100, 'Peek', 'Susan', 'Virginia Beach', 'A', NULL);
  170. INSERT INTO prob_officers (prob_id, last, first, city, status, mgr_id)
  171. VALUES (102, 'Speckle', 'Jeff', 'Virginia Beach', 'A', 100);
  172. INSERT INTO prob_officers (prob_id, last, first, city, status, mgr_id)
  173. VALUES (104, 'Boyle', 'Chris', 'Virginia Beach', 'A', 100);
  174. INSERT INTO prob_officers (prob_id, last, first, city, status, mgr_id)
  175. VALUES (106, 'Taps', 'George', 'Chesapeake', 'A', NULL);
  176. INSERT INTO prob_officers (prob_id, last, first, city, status, mgr_id)
  177. VALUES (108, 'Ponds', 'Terry', 'Chesapeake', 'A', 106);
  178. INSERT INTO prob_officers (prob_id, last, first, city, status, mgr_id)
  179. VALUES (110, 'Hawk', 'Fred', 'Chesapeake', 'I', 106);
  180. INSERT INTO officers (officer_id, last, first, precinct, badge, phone, status)
  181. VALUES (111112, 'Shocks', 'Pam', 'OCVW', 'E5546A33', '7574446767', 'A');
  182. INSERT INTO officers (officer_id, last, first, precinct, badge, phone, status)
  183. VALUES (111113, 'Busey', 'Gerry', 'GHNT', 'E5577D48', '7574446767', 'A');
  184. INSERT INTO officers (officer_id, last, first, precinct, badge, phone, status)
  185. VALUES (111114, 'Gants', 'Dale', 'SBCH', 'E5536N02', '7574446767', 'A');
  186. INSERT INTO officers (officer_id, last, first, precinct, badge, phone, status)
  187. VALUES (111115, 'Hart', 'Leigh', 'WAVE', 'E5511J40', '7574446767', 'A');
  188. INSERT INTO officers (officer_id, last, first, precinct, badge, phone, status)
  189. VALUES (111116, 'Sands', 'Ben', 'OCVW', 'E5588R00', '7574446767', 'I');
  190. COMMIT;
  191. INSERT INTO criminals (criminal_id, last, first, street, city, state, zip, phone, v_status, p_status)
  192. VALUES (1020, 'Phelps','Sam','1105 Tree Lane', 'Virginia Beach', 'VA', '23510',
  193. 7576778484, 'Y', 'N');
  194. INSERT INTO crimes (crime_id, criminal_id, classification, date_charged, status,
  195. hearing_date, appeal_cut_date)
  196. VALUES (10085, 1020, 'F', '03-SEP-08', 'CA', '15-SEP-08', '15-DEC-08');
  197. INSERT INTO crime_charges(charge_id, crime_id, crime_code, charge_status,
  198. fine_amount, court_fee, amount_paid, pay_due_date)
  199. VALUES (5000, 10085, 301, 'GL', 3000, 200, 40, '15-OCT-08');
  200. INSERT INTO crime_charges(charge_id, crime_id, crime_code, charge_status,
  201. fine_amount, court_fee, amount_paid, pay_due_date)
  202. VALUES (5001, 10085, 305, 'GL', 1000, 100, NULL, '15-OCT-08');
  203. INSERT INTO sentences (sentence_id, criminal_id, type, prob_id, start_date,
  204. end_date, violations)
  205. VALUES (1000, 1020, 'J', NULL, '15-SEP-08', '15-SEP-10', 0);
  206. INSERT INTO aliases (alias_id, criminal_id, alias)
  207. VALUES (100, 1020, 'Bat');
  208. INSERT INTO crime_officers (crime_id, officer_id)
  209. VALUES (10085, 111112);
  210. INSERT INTO criminals (criminal_id, last, first, street, city, state, zip, phone, v_status, p_status)
  211. VALUES (1021, 'Sums','Tammy','22 E. Ave', 'Virginia Beach', 'VA', '23510',
  212. 7575453390, 'N', 'Y');
  213. INSERT INTO crimes (crime_id, criminal_id, classification, date_charged, status,
  214. hearing_date, appeal_cut_date)
  215. VALUES (10086, 1021, 'M', '20-OCT-08', 'CL', '05-DEC-08', NULL);
  216. INSERT INTO crime_charges(charge_id, crime_id, crime_code, charge_status,
  217. fine_amount, court_fee, amount_paid, pay_due_date)
  218. VALUES (5002, 10086, 304, 'GL', 200, 100, 25, '15-FEB-09');
  219. INSERT INTO sentences (sentence_id, criminal_id, type, prob_id, start_date,
  220. end_date, violations)
  221. VALUES (1001, 1021, 'P', 102, '05-DEC-08', '05-JUN-09', 0);
  222. INSERT INTO crime_officers (crime_id, officer_id)
  223. VALUES (10086, 111114);
  224.  
  225. INSERT INTO criminals (criminal_id, last, first, street, city, state, zip, phone, v_status, p_status)
  226. VALUES (1022, 'Caulk','Dave', '8112 Chester Lane', 'Chesapeake', 'VA', '23320',
  227. 7578403690, 'N', 'Y');
  228. INSERT INTO crimes (crime_id, criminal_id, classification, date_charged, status,
  229. hearing_date, appeal_cut_date)
  230. VALUES (10087, 1022, 'M', '30-OCT-08', 'IA', '05-DEC-08', '15-MAR-09');
  231. INSERT INTO crime_charges(charge_id, crime_id, crime_code, charge_status,
  232. fine_amount, court_fee, amount_paid, pay_due_date)
  233. VALUES (5003, 10087, 305, 'GL', 100, 50, 150, '15-MAR-09');
  234. INSERT INTO sentences (sentence_id, criminal_id, type, prob_id, start_date,
  235. end_date, violations)
  236. VALUES (1002, 1022, 'P', 108, '20-MAR-09', '20-AUG-09', 0);
  237. INSERT INTO crime_officers (crime_id, officer_id)
  238. VALUES (10087, 111115);
  239. INSERT INTO aliases (alias_id, criminal_id, alias)
  240. VALUES (101, 1022, 'Cabby');
  241. INSERT INTO appeals (appeal_id, crime_id, filing_date, hearing_date, status)
  242. VALUES (7500, 10087, '10-DEC-08', '20-DEC-08', 'A');
  243. INSERT INTO appeals (appeal_id, crime_id, filing_date, hearing_date, status)
  244. VALUES (7501, 10086, '15-DEC-08', '20-DEC-08', 'A');
  245. INSERT INTO appeals (appeal_id, crime_id, filing_date, hearing_date, status)
  246. VALUES (7502, 10085, '20-SEP-08', '28-OCT-08', 'A');
  247. INSERT INTO criminals (criminal_id, last, first, street, city, state, zip, phone, v_status, p_status)
  248. VALUES (1023, 'Dabber','Pat', NULL, 'Chesapeake', 'VA', '23320',
  249. NULL, 'N', 'N');
  250. INSERT INTO crimes (crime_id, criminal_id, classification, date_charged, status,
  251. hearing_date, appeal_cut_date)
  252. VALUES (10088, 1023, 'O', '05-NOV-08', 'CA', NULL, NULL);
  253. INSERT INTO crime_charges(charge_id, crime_id, crime_code, charge_status,
  254. fine_amount, court_fee, amount_paid, pay_due_date)
  255. VALUES (5004, 10088, 306, 'PD', NULL, NULL, NULL, NULL);
  256. INSERT INTO crime_officers (crime_id, officer_id)
  257. VALUES (10088, 111115);
  258.  
  259. INSERT INTO criminals (criminal_id, last, first, street, city, state, zip, phone, v_status, p_status)
  260. VALUES (1025, 'Cat','Tommy', NULL, 'Norfolk', 'VA', '26503',
  261. NULL, 'N', 'Y');
  262. INSERT INTO crimes (crime_id, criminal_id, classification, date_charged, status,
  263. hearing_date, appeal_cut_date)
  264. VALUES (10089, 1025, 'M', '22-OCT-08', 'CA', '25-NOV-08', '15-FEB-09');
  265. INSERT INTO crime_charges(charge_id, crime_id, crime_code, charge_status,
  266. fine_amount, court_fee, amount_paid, pay_due_date)
  267. VALUES (5005, 10089, 305, 'GL', 100, 50, NULL, '15-FEB-09');
  268. INSERT INTO sentences (sentence_id, criminal_id, type, prob_id, start_date,
  269. end_date, violations)
  270. VALUES (1004, 1025, 'P', 106, '20-DEC-08', '20-MAR-09', 0);
  271. INSERT INTO crime_officers (crime_id, officer_id)
  272. VALUES (10089, 111115);
  273. INSERT INTO crime_officers (crime_id, officer_id)
  274. VALUES (10089, 111116);
  275.  
  276. INSERT INTO criminals (criminal_id, last, first, street, city, state, zip, phone, v_status, p_status)
  277. VALUES (1026, 'Simon','Tim', NULL, 'Norfolk', 'VA', '26503',
  278. NULL, 'N', 'Y');
  279. INSERT INTO crimes (crime_id, criminal_id, classification, date_charged, status,
  280. hearing_date, appeal_cut_date)
  281. VALUES (10090, 1026, 'M', '22-OCT-08', 'CA', '25-NOV-08', '15-FEB-09');
  282. INSERT INTO crime_charges(charge_id, crime_id, crime_code, charge_status,
  283. fine_amount, court_fee, amount_paid, pay_due_date)
  284. VALUES (5006, 10090, 305, 'GL', 100, 50, NULL, '15-FEB-09');
  285. INSERT INTO sentences (sentence_id, criminal_id, type, prob_id, start_date,
  286. end_date, violations)
  287. VALUES (1005, 1026, 'P', 106, '20-DEC-08', '20-MAR-09', 0);
  288. INSERT INTO crime_officers (crime_id, officer_id)
  289. VALUES (10090, 111115);
  290.  
  291. INSERT INTO criminals (criminal_id, last, first, street, city, state, zip, phone, v_status, p_status)
  292. VALUES (1027, 'Pints','Reed', NULL, 'Norfolk', 'VA', '26505',
  293. NULL, 'N', 'Y');
  294. INSERT INTO crimes (crime_id, criminal_id, classification, date_charged, status,
  295. hearing_date, appeal_cut_date)
  296. VALUES (10091, 1027, 'M', '24-OCT-08', 'CA', '28-NOV-08', '15-FEB-09');
  297. INSERT INTO crime_charges(charge_id, crime_id, crime_code, charge_status,
  298. fine_amount, court_fee, amount_paid, pay_due_date)
  299. VALUES (5007, 10091, 305, 'GL', 100, 50, 20, '15-FEB-09');
  300. INSERT INTO sentences (sentence_id, criminal_id, type, prob_id, start_date,
  301. end_date, violations)
  302. VALUES (1006, 1027, 'P', 106, '20-DEC-08', '20-MAR-09', 0);
  303. INSERT INTO crime_officers (crime_id, officer_id)
  304. VALUES (10091, 111115);
  305.  
  306. INSERT INTO criminals (criminal_id, last, first, street, city, state, zip, phone, v_status, p_status)
  307. VALUES (1028, 'Mansville','Nancy', NULL, 'Norfolk', 'VA', '26505',
  308. NULL, 'N', 'Y');
  309. INSERT INTO crimes (crime_id, criminal_id, classification, date_charged, status,
  310. hearing_date, appeal_cut_date)
  311. VALUES (10092, 1028, 'M', '24-OCT-08', 'CA', '28-NOV-08', '15-FEB-09');
  312. INSERT INTO crime_charges(charge_id, crime_id, crime_code, charge_status,
  313. fine_amount, court_fee, amount_paid, pay_due_date)
  314. VALUES (5008, 10092, 305, 'GL', 100, 50, 25, '15-FEB-09');
  315. INSERT INTO sentences (sentence_id, criminal_id, type, prob_id, start_date,
  316. end_date, violations)
  317. VALUES (1007, 1028, 'P', 106, '20-DEC-08', '20-MAR-09', 0);
  318. INSERT INTO crime_officers (crime_id, officer_id)
  319. VALUES (10092, 111115);
  320.  
  321. INSERT INTO criminals (criminal_id, last, first, street, city, state, zip, phone, v_status, p_status)
  322. VALUES (1024, 'Perry','Cart', NULL, 'Norfolk', 'VA', '26501',
  323. NULL, 'N', 'Y');
  324. INSERT INTO crimes (crime_id, criminal_id, classification, date_charged, status,
  325. hearing_date, appeal_cut_date)
  326. VALUES (10093, 1024, 'M', '22-OCT-08', 'CA', '25-NOV-08', '15-FEB-09');
  327. INSERT INTO crime_charges(charge_id, crime_id, crime_code, charge_status,
  328. fine_amount, court_fee, amount_paid, pay_due_date)
  329. VALUES (5009, 10093, 305, 'GL', 100, 50, NULL, '15-FEB-09');
  330. INSERT INTO sentences (sentence_id, criminal_id, type, prob_id, start_date,
  331. end_date, violations)
  332. VALUES (1003, 1024, 'P', 106, '20-DEC-08', '20-MAR-09', 1);
  333. INSERT INTO crime_officers (crime_id, officer_id)
  334. VALUES (10093, 111115);
  335.  
  336. INSERT INTO criminals (criminal_id, last, first, street, city, state, zip, phone, v_status, p_status)
  337. VALUES (1029, 'Statin','Penny', NULL, 'Norfolk', 'VA', '26505',
  338. NULL, 'N', 'Y');
  339. INSERT INTO crimes (crime_id, criminal_id, classification, date_charged, status,
  340. hearing_date, appeal_cut_date)
  341. VALUES (10094, 1029, 'M', '26-OCT-08', 'CA', '26-NOV-08', '17-FEB-09');
  342. INSERT INTO crime_charges(charge_id, crime_id, crime_code, charge_status,
  343. fine_amount, court_fee, amount_paid, pay_due_date)
  344. VALUES (5010, 10094, 305, 'GL', 50, 50, NULL, '17-FEB-09');
  345. INSERT INTO sentences (sentence_id, criminal_id, type, prob_id, start_date,
  346. end_date, violations)
  347. VALUES (1008, 1029, 'P', 106, '20-DEC-08', '05-FEB-09', 1);
  348. INSERT INTO crime_officers (crime_id, officer_id)
  349. VALUES (10094, 111115);
  350.  
  351. INSERT INTO criminals (criminal_id, last, first, street, city, state, zip, phone, v_status, p_status)
  352. VALUES (1030, 'Panner','Lee', NULL, 'Norfolk', 'VA', '26505',
  353. NULL, 'N', 'Y');
  354. INSERT INTO crimes (crime_id, criminal_id, classification, date_charged, status,
  355. hearing_date, appeal_cut_date)
  356. VALUES (25344031, 1030, 'M', '26-OCT-08', 'CA', '26-NOV-08', '17-FEB-09');
  357. INSERT INTO crime_charges(charge_id, crime_id, crime_code, charge_status,
  358. fine_amount, court_fee, amount_paid, pay_due_date)
  359. VALUES (5011, 25344031, 305, 'GL', 50, 50, NULL, '17-FEB-09');
  360. INSERT INTO sentences (sentence_id, criminal_id, type, prob_id, start_date,
  361. end_date, violations)
  362. VALUES (1009, 1030, 'P', 106, '20-DEC-08', '05-FEB-09', 1);
  363. INSERT INTO crime_officers (crime_id, officer_id)
  364. VALUES (25344031, 111115);
  365.  
  366. INSERT INTO crimes (crime_id, criminal_id, classification, date_charged, status,
  367. hearing_date, appeal_cut_date)
  368. VALUES (25344060, 1030, 'M', '18-NOV-08', 'CL', '26-NOV-08', NULL);
  369. INSERT INTO crime_charges(charge_id, crime_id, crime_code, charge_status,
  370. fine_amount, court_fee, amount_paid, pay_due_date)
  371. VALUES (5012, 25344060, 305, 'GL', 50, 50, 100, '17-FEB-09');
  372. INSERT INTO sentences (sentence_id, criminal_id, type, prob_id, start_date,
  373. end_date, violations)
  374. VALUES (1010, 1030, 'P', 106, '06-FEB-09', '06-JUL-09', 0);
  375. INSERT INTO crime_officers (crime_id, officer_id)
  376. VALUES (25344060, 111116);
  377. COMMIT;
  378.  
  379. CREATE SEQUENCE appeals_id_seq
  380. START WITH 7505
  381. NOCACHE
  382. NOCYCLE;
  383.  
  384. CREATE TABLE prob_contact
  385. (prob_cat number(2),
  386. low_amt number(5),
  387. high_amt number(5),
  388. con_freq VARCHAR2(20) );
  389. INSERT INTO prob_contact
  390. VALUES(10, 1, 80, 'Weekly');
  391. INSERT INTO prob_contact
  392. VALUES(20, 81, 160, 'Every 2 weeks');
  393. INSERT INTO prob_contact
  394. VALUES(30, 161, 500, 'Monthly');
  395. COMMIT;
  396.  
  397. CREATE TABLE criminals_dw
  398. (criminal_id NUMBER(6),
  399. last VARCHAR2(15),
  400. first VARCHAR2(10),
  401. street VARCHAR2(30),
  402. city VARCHAR2(20),
  403. state CHAR(2),
  404. zip CHAR(5),
  405. phone CHAR(10),
  406. v_status CHAR(1),
  407. p_status CHAR(1) );
  408. INSERT INTO criminals_dw (criminal_id, last, first, street, city, state, zip, phone, v_status, p_status)
  409. VALUES (1020, 'Phelps','Sam','1105 Tree Lane', 'Virginia Beach', 'VA', '23510',
  410. 7576778484, 'Y', 'N');
  411. INSERT INTO criminals_dw (criminal_id, last, first, street, city, state, zip, phone, v_status, p_status)
  412. VALUES (1021, 'Sums','Tammy','22 E. Ave', 'Virginia Beach', 'VA', '23510',
  413. 7575453390, 'N', 'Y');
  414. INSERT INTO criminals_dw (criminal_id, last, first, street, city, state, zip, phone, v_status, p_status)
  415. VALUES (1022, 'Caulk','Dave', '8112 Chester Lane', 'Chesapeake', 'VA', '23320',
  416. 7578403690, 'N', 'Y');
  417. INSERT INTO criminals_dw (criminal_id, last, first, street, city, state, zip, phone, v_status, p_status)
  418. VALUES (1023, 'Dabber','Pat', NULL, 'Chesapeake', 'VA', '23320',
  419. NULL, 'N', 'N');
  420. INSERT INTO criminals_dw (criminal_id, last, first, street, city, state, zip, phone, v_status, p_status)
  421. VALUES (1024, 'Perry','Cart', '11 New St.', 'Surry', 'VA', '54501',
  422. NULL, 'N', 'Y');
  423. INSERT INTO criminals_dw (criminal_id, last, first, street, city, state, zip, phone, v_status, p_status)
  424. VALUES (1025, 'Cat','Tommy', NULL, 'Norfolk', 'VA', '26503',
  425. 7578889393, 'N', 'Y');
  426. COMMIT;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!