Untitled

--
-- PostgreSQL database dump
--

SET statement_timeout = 0;
SET lock_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = ON;
SET check_function_bodies = FALSE;
SET client_min_messages = warning;

--
-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner:
--

CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;


--
-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner:
--

COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';


SET search_path = public, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = FALSE;

--
-- Name: assignments; Type: TABLE; Schema: public; Owner: agufranov; Tablespace:
--

CREATE TABLE assignments (
    id INTEGER NOT NULL,
    tasks_flags INTEGER DEFAULT 0 NOT NULL,
    cost_cents INTEGER,
    start_date TIMESTAMP WITHOUT TIME zone,
    planned_end_date TIMESTAMP WITHOUT TIME zone,
    actual_end_date TIMESTAMP WITHOUT TIME zone,
    rating INTEGER,
    vendor_id INTEGER NOT NULL,
    project_id INTEGER NOT NULL
);


ALTER TABLE public.assignments OWNER TO agufranov;

--
-- Name: assignments_id_seq; Type: SEQUENCE; Schema: public; Owner: agufranov
--

CREATE SEQUENCE assignments_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.assignments_id_seq OWNER TO agufranov;

--
-- Name: assignments_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: agufranov
--

ALTER SEQUENCE assignments_id_seq OWNED BY assignments.id;


--
-- Name: clients; Type: TABLE; Schema: public; Owner: agufranov; Tablespace:
--

CREATE TABLE clients (
    id INTEGER NOT NULL,
    name CHARACTER VARYING NOT NULL,
    address text,
    country_id INTEGER
);


ALTER TABLE public.clients OWNER TO agufranov;

--
-- Name: clients_id_seq; Type: SEQUENCE; Schema: public; Owner: agufranov
--

CREATE SEQUENCE clients_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.clients_id_seq OWNER TO agufranov;

--
-- Name: clients_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: agufranov
--

ALTER SEQUENCE clients_id_seq OWNED BY clients.id;


--
-- Name: conditions; Type: TABLE; Schema: public; Owner: agufranov; Tablespace:
--

CREATE TABLE conditions (
    id INTEGER NOT NULL,
    name CHARACTER VARYING NOT NULL
);


ALTER TABLE public.conditions OWNER TO agufranov;

--
-- Name: conditions_id_seq; Type: SEQUENCE; Schema: public; Owner: agufranov
--

CREATE SEQUENCE conditions_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.conditions_id_seq OWNER TO agufranov;

--
-- Name: conditions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: agufranov
--

ALTER SEQUENCE conditions_id_seq OWNED BY conditions.id;


--
-- Name: countries; Type: TABLE; Schema: public; Owner: agufranov; Tablespace:
--

CREATE TABLE countries (
    id INTEGER NOT NULL,
    name CHARACTER VARYING NOT NULL,
    code CHARACTER VARYING
);


ALTER TABLE public.countries OWNER TO agufranov;

--
-- Name: countries_id_seq; Type: SEQUENCE; Schema: public; Owner: agufranov
--

CREATE SEQUENCE countries_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.countries_id_seq OWNER TO agufranov;

--
-- Name: countries_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: agufranov
--

ALTER SEQUENCE countries_id_seq OWNED BY countries.id;


--
-- Name: languages; Type: TABLE; Schema: public; Owner: agufranov; Tablespace:
--

CREATE TABLE languages (
    id INTEGER NOT NULL,
    name CHARACTER VARYING NOT NULL,
    native_name CHARACTER VARYING,
    code CHARACTER VARYING
);


ALTER TABLE public.languages OWNER TO agufranov;

--
-- Name: languages_id_seq; Type: SEQUENCE; Schema: public; Owner: agufranov
--

CREATE SEQUENCE languages_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.languages_id_seq OWNER TO agufranov;

--
-- Name: languages_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: agufranov
--

ALTER SEQUENCE languages_id_seq OWNED BY languages.id;


--
-- Name: professions; Type: TABLE; Schema: public; Owner: agufranov; Tablespace:
--

CREATE TABLE professions (
    id INTEGER NOT NULL,
    title CHARACTER VARYING NOT NULL
);


ALTER TABLE public.professions OWNER TO agufranov;

--
-- Name: professions_id_seq; Type: SEQUENCE; Schema: public; Owner: agufranov
--

CREATE SEQUENCE professions_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.professions_id_seq OWNER TO agufranov;

--
-- Name: professions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: agufranov
--

ALTER SEQUENCE professions_id_seq OWNED BY professions.id;


--
-- Name: project_managers; Type: TABLE; Schema: public; Owner: agufranov; Tablespace:
--

CREATE TABLE project_managers (
    id INTEGER NOT NULL,
    name CHARACTER VARYING NOT NULL,
    email CHARACTER VARYING,
    address CHARACTER VARYING,
    client_id INTEGER NOT NULL
);


ALTER TABLE public.project_managers OWNER TO agufranov;

--
-- Name: project_managers_id_seq; Type: SEQUENCE; Schema: public; Owner: agufranov
--

CREATE SEQUENCE project_managers_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.project_managers_id_seq OWNER TO agufranov;

--
-- Name: project_managers_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: agufranov
--

ALTER SEQUENCE project_managers_id_seq OWNED BY project_managers.id;


--
-- Name: projects; Type: TABLE; Schema: public; Owner: agufranov; Tablespace:
--

CREATE TABLE projects (
    id INTEGER NOT NULL,
    NUMBER CHARACTER VARYING,
    project_id_client CHARACTER VARYING,
    words_count INTEGER,
    budget_cents INTEGER,
    STATUS INTEGER,
    start_date TIMESTAMP WITHOUT TIME zone,
    planned_end_date TIMESTAMP WITHOUT TIME zone,
    actual_end_date TIMESTAMP WITHOUT TIME zone,
    comments text,
    client_id INTEGER,
    project_manager_id INTEGER,
    country_id INTEGER,
    original_language_id INTEGER,
    target_language_id INTEGER,
    condition_id INTEGER,
    speciality_id INTEGER
);


ALTER TABLE public.projects OWNER TO agufranov;

--
-- Name: projects_id_seq; Type: SEQUENCE; Schema: public; Owner: agufranov
--

CREATE SEQUENCE projects_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.projects_id_seq OWNER TO agufranov;

--
-- Name: projects_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: agufranov
--

ALTER SEQUENCE projects_id_seq OWNED BY projects.id;


--
-- Name: schema_migrations; Type: TABLE; Schema: public; Owner: agufranov; Tablespace:
--

CREATE TABLE schema_migrations (
    version CHARACTER VARYING NOT NULL
);


ALTER TABLE public.schema_migrations OWNER TO agufranov;

--
-- Name: specialities; Type: TABLE; Schema: public; Owner: agufranov; Tablespace:
--

CREATE TABLE specialities (
    id INTEGER NOT NULL,
    title CHARACTER VARYING NOT NULL
);


ALTER TABLE public.specialities OWNER TO agufranov;

--
-- Name: specialities_id_seq; Type: SEQUENCE; Schema: public; Owner: agufranov
--

CREATE SEQUENCE specialities_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.specialities_id_seq OWNER TO agufranov;

--
-- Name: specialities_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: agufranov
--

ALTER SEQUENCE specialities_id_seq OWNED BY specialities.id;


--
-- Name: vendor_countries; Type: TABLE; Schema: public; Owner: agufranov; Tablespace:
--

CREATE TABLE vendor_countries (
    id INTEGER NOT NULL,
    vendor_id INTEGER NOT NULL,
    country_id INTEGER NOT NULL
);


ALTER TABLE public.vendor_countries OWNER TO agufranov;

--
-- Name: vendor_countries_id_seq; Type: SEQUENCE; Schema: public; Owner: agufranov
--

CREATE SEQUENCE vendor_countries_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.vendor_countries_id_seq OWNER TO agufranov;

--
-- Name: vendor_countries_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: agufranov
--

ALTER SEQUENCE vendor_countries_id_seq OWNED BY vendor_countries.id;


--
-- Name: vendor_languages; Type: TABLE; Schema: public; Owner: agufranov; Tablespace:
--

CREATE TABLE vendor_languages (
    id INTEGER NOT NULL,
    vendor_id INTEGER NOT NULL,
    language_id INTEGER NOT NULL,
    proficiency INTEGER
);


ALTER TABLE public.vendor_languages OWNER TO agufranov;

--
-- Name: vendor_languages_id_seq; Type: SEQUENCE; Schema: public; Owner: agufranov
--

CREATE SEQUENCE vendor_languages_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.vendor_languages_id_seq OWNER TO agufranov;

--
-- Name: vendor_languages_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: agufranov
--

ALTER SEQUENCE vendor_languages_id_seq OWNED BY vendor_languages.id;


--
-- Name: vendors; Type: TABLE; Schema: public; Owner: agufranov; Tablespace:
--

CREATE TABLE vendors (
    id INTEGER NOT NULL,
    name CHARACTER VARYING NOT NULL,
    mapi_code CHARACTER VARYING,
    tasks_flags INTEGER DEFAULT 0 NOT NULL,
    rate_hour_cents INTEGER,
    rate_interview_cents INTEGER,
    rate_word_cents INTEGER,
    comments text,
    profession_id INTEGER,
    condition_id INTEGER,
    speciality_id INTEGER
);


ALTER TABLE public.vendors OWNER TO agufranov;

--
-- Name: vendors_id_seq; Type: SEQUENCE; Schema: public; Owner: agufranov
--

CREATE SEQUENCE vendors_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.vendors_id_seq OWNER TO agufranov;

--
-- Name: vendors_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: agufranov
--

ALTER SEQUENCE vendors_id_seq OWNED BY vendors.id;


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: agufranov
--

ALTER TABLE ONLY assignments ALTER COLUMN id SET DEFAULT NEXTVAL('assignments_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: agufranov
--

ALTER TABLE ONLY clients ALTER COLUMN id SET DEFAULT NEXTVAL('clients_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: agufranov
--

ALTER TABLE ONLY conditions ALTER COLUMN id SET DEFAULT NEXTVAL('conditions_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: agufranov
--

ALTER TABLE ONLY countries ALTER COLUMN id SET DEFAULT NEXTVAL('countries_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: agufranov
--

ALTER TABLE ONLY languages ALTER COLUMN id SET DEFAULT NEXTVAL('languages_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: agufranov
--

ALTER TABLE ONLY professions ALTER COLUMN id SET DEFAULT NEXTVAL('professions_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: agufranov
--

ALTER TABLE ONLY project_managers ALTER COLUMN id SET DEFAULT NEXTVAL('project_managers_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: agufranov
--

ALTER TABLE ONLY projects ALTER COLUMN id SET DEFAULT NEXTVAL('projects_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: agufranov
--

ALTER TABLE ONLY specialities ALTER COLUMN id SET DEFAULT NEXTVAL('specialities_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: agufranov
--

ALTER TABLE ONLY vendor_countries ALTER COLUMN id SET DEFAULT NEXTVAL('vendor_countries_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: agufranov
--

ALTER TABLE ONLY vendor_languages ALTER COLUMN id SET DEFAULT NEXTVAL('vendor_languages_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: agufranov
--

ALTER TABLE ONLY vendors ALTER COLUMN id SET DEFAULT NEXTVAL('vendors_id_seq'::regclass);


--
-- Data for Name: assignments; Type: TABLE DATA; Schema: public; Owner: agufranov
--
--
-- Name: assignments_id_seq; Type: SEQUENCE SET; Schema: public; Owner: agufranov
--

SELECT pg_catalog.SETVAL('assignments_id_seq', 395, TRUE);


--
-- Data for Name: clients; Type: TABLE DATA; Schema: public; Owner: agufranov
--

COPY clients (id, name, address, country_id) FROM stdin;
458 Feest-Waelchi   Darenmouth, 464 Champlin Manor  10252
459 Ferry Inc   North Barneyfurt, 942 Charles Shoals    10370
460 Ankunding, Swaniawski AND Osinski   South Cleora, 721 Heller Square 10309
461 Herzog Inc  West Tristianport, 375 Garry Tunnel 10359
462 Lynch-Renner    Florianland, 87776 Tromp Plain  10430
463 Champlin AND Sons   Lake Joyceberg, 1212 Savion Wells   10318
464 Luettgen LLC    Bertramfort, 932 Antone Gateway 10293
465 Labadie-Koss    Morissettemouth, 5530 Mossie Plains 10284
466 Becker AND Sons Feestview, 5909 Roy Plaza   10251
467 Kilback-Flatley Lake Delphineshire, 2617 Lenny Mission  10443
468 Kshlerin, Nicolas AND Trantow   Kieratown, 904 VonRueden Flats  10398
469 Marquardt AND Sons  Ulicesfurt, 4099 Fadel Coves    10289
470 Smith-Streich   North Deannaland, 179 Cartwright Road   10403
471 Ziemann GROUP   South Gianni, 9613 Hamill Orchard   10271
472 Hayes-Ledner    NEW Clarkmouth, 3768 Muller Bypass  10273
473 Von-Runte   South Jonstad, 22121 Cade Plaza 10353
474 Beer, Larkin AND Bradtke    Freddyville, 8127 Rowena Fork   10272
475 Mann-Mosciski   Fadelland, 635 Harber Garden    10434
476 Zboncak-Durgan  Mosciskichester, 87561 Shanna Locks 10436
477 Kshlerin, O'Keefe and Spinka    South Kiara, 708 Misael Roads   10399
\.


--
-- Name: clients_id_seq; Type: SEQUENCE SET; Schema: public; Owner: agufranov
--

SELECT pg_catalog.setval('clients_id_seq', 477, true);


--
-- Data for Name: conditions; Type: TABLE DATA; Schema: public; Owner: agufranov
--

COPY conditions (id, name) FROM stdin;
81  Condition 1
82  Condition 2
\.


--
-- Name: conditions_id_seq; Type: SEQUENCE SET; Schema: public; Owner: agufranov
--

SELECT pg_catalog.setval('conditions_id_seq', 82, true);


--
-- Data for Name: countries; Type: TABLE DATA; Schema: public; Owner: agufranov
--

COPY countries (id, name, code) FROM stdin;
10207   Afghanistan AF
10208   Åland Islands  AX
10209   Albania AL
10210   Algeria DZ
10211   American Samoa  AS
10212   AndorrA AD
10213   Angola  AO
10214   Anguilla    AI
10215   Antarctica  AQ
10216   Antigua and Barbuda AG
10217   Argentina   AR
10218   Armenia AM
10219   Aruba   AW
10220   Australia   AU
10221   Austria AT
10222   Azerbaijan  AZ
10223   Bahamas BS
10224   Bahrain BH
10225   Bangladesh  BD
10226   Barbados    BB
10227   Belarus BY
10228   Belgium BE
10229   Belize  BZ
10230   Benin   BJ
10231   Bermuda BM
10232   Bhutan  BT
10233   Bolivia BO
10234   Bosnia and Herzegovina  BA
10235   Botswana    BW
10236   Bouvet Island   BV
10237   Brazil  BR
10238   British Indian Ocean Territory  IO
10239   Brunei Darussalam   BN
10240   Bulgaria    BG
10241   Burkina Faso    BF
10242   Burundi BI
10243   Cambodia    KH
10244   Cameroon    CM
10245   Canada  CA
10246   Cape Verde  CV
10247   Cayman Islands  KY
10248   Central African Republic    CF
10249   Chad    TD
10250   Chile   CL
10251   China   CN
10252   Christmas Island    CX
10253   Cocos (Keeling) Islands CC
10254   Colombia    CO
10255   Comoros KM
10256   Congo   CG
10257   Congo, The Democratic Republic of the   CD
10258   Cook Islands    CK
10259   Costa Rica  CR
10260   Cote D"Ivoire   CI
10261   Croatia HR
10262   Cuba    CU
10263   Cyprus  CY
10264   Czech Republic  CZ
10265   Denmark DK
10266   Djibouti    DJ
10267   Dominica    DM
10268   Dominican Republic  DO
10269   Ecuador EC
10270   Egypt   EG
10271   El Salvador SV
10272   Equatorial Guinea   GQ
10273   Eritrea ER
10274   Estonia EE
10275   Ethiopia    ET
10276   Falkland Islands (Malvinas) FK
10277   Faroe Islands   FO
10278   Fiji    FJ
10279   Finland FI
10280   France  FR
10281   French Guiana   GF
10282   French Polynesia    PF
10283   French Southern Territories TF
10284   Gabon   GA
10285   Gambia  GM
10286   Georgia GE
10287   Germany DE
10288   Ghana   GH
10289   Gibraltar   GI
10290   Greece  GR
10291   Greenland   GL
10292   Grenada GD
10293   Guadeloupe  GP
10294   Guam    GU
10295   Guatemala   GT
10296   Guernsey    GG
10297   Guinea  GN
10298   Guinea-Bissau   GW
10299   Guyana  GY
10300   Haiti   HT
10301   Heard Island and Mcdonald Islands   HM
10302   Holy See (Vatican City State)   VA
10303   Honduras    HN
10304   Hong Kong   HK
10305   Hungary HU
10306   Iceland IS
10307   India   IN
10308   Indonesia   ID
10309   Iran, Islamic Republic Of   IR
10310   Iraq    IQ
10311   Ireland IE
10312   Isle of Man IM
10313   Israel  IL
10314   Italy   IT
10315   Jamaica JM
10316   Japan   JP
10317   Jersey  JE
10318   Jordan  JO
10319   Kazakhstan  KZ
10320   Kenya   KE
10321   Kiribati    KI
10322   Korea, Democratic People"S Republic of  KP
10323   Korea, Republic of  KR
10324   Kuwait  KW
10325   Kyrgyzstan  KG
10326   Lao People"S Democratic Republic    LA
10327   Latvia  LV
10328   Lebanon LB
10329   Lesotho LS
10330   Liberia LR
10331   Libyan Arab Jamahiriya  LY
10332   Liechtenstein   LI
10333   Lithuania   LT
10334   Luxembourg  LU
10335   Macao   MO
10336   Macedonia, The Former Yugoslav Republic of  MK
10337   Madagascar  MG
10338   Malawi  MW
10339   Malaysia    MY
10340   Maldives    MV
10341   Mali    ML
10342   Malta   MT
10343   Marshall Islands    MH
10344   Martinique  MQ
10345   Mauritania  MR
10346   Mauritius   MU
10347   Mayotte YT
10348   Mexico  MX
10349   Micronesia, Federated States of FM
10350   Moldova, Republic of    MD
10351   Monaco  MC
10352   Mongolia    MN
10353   Montserrat  MS
10354   Morocco MA
10355   Mozambique  MZ
10356   Myanmar MM
10357   Namibia NA
10358   Nauru   NR
10359   Nepal   NP
10360   Netherlands NL
10361   Netherlands Antilles    AN
10362   New Caledonia   NC
10363   New Zealand NZ
10364   Nicaragua   NI
10365   Niger   NE
10366   Nigeria NG
10367   Niue    NU
10368   Norfolk Island  NF
10369   Northern Mariana Islands    MP
10370   Norway  NO
10371   Oman    OM
10372   Pakistan    PK
10373   Palau   PW
10374   Palestinian Territory, Occupied PS
10375   Panama  PA
10376   Papua New Guinea    PG
10377   Paraguay    PY
10378   Peru    PE
10379   Philippines PH
10380   Pitcairn    PN
10381   Poland  PL
10382   Portugal    PT
10383   Puerto Rico PR
10384   Qatar   QA
10385   Reunion RE
10386   Romania RO
10387   Russian Federation  RU
10388   RWANDA  RW
10389   Saint Helena    SH
10390   Saint Kitts and Nevis   KN
10391   Saint Lucia LC
10392   Saint Pierre and Miquelon   PM
10393   Saint Vincent and the Grenadines    VC
10394   Samoa   WS
10395   San Marino  SM
10396   Sao Tome and Principe   ST
10397   Saudi Arabia    SA
10398   Senegal SN
10399   Serbia and Montenegro   CS
10400   Seychelles  SC
10401   Sierra Leone    SL
10402   Singapore   SG
10403   Slovakia    SK
10404   Slovenia    SI
10405   Solomon Islands SB
10406   Somalia SO
10407   South Africa    ZA
10408   South Georgia and the South Sandwich Islands    GS
10409   Spain   ES
10410   Sri Lanka   LK
10411   Sudan   SD
10412   Suriname    SR
10413   Svalbard and Jan Mayen  SJ
10414   Swaziland   SZ
10415   Sweden  SE
10416   Switzerland CH
10417   Syrian Arab Republic    SY
10418   Taiwan, Province of China   TW
10419   Tajikistan  TJ
10420   Tanzania, United Republic of    TZ
10421   Thailand    TH
10422   Timor-Leste TL
10423   Togo    TG
10424   Tokelau TK
10425   Tonga   TO
10426   Trinidad and Tobago TT
10427   Tunisia TN
10428   Turkey  TR
10429   Turkmenistan    TM
10430   Turks and Caicos Islands    TC
10431   Tuvalu  TV
10432   Uganda  UG
10433   Ukraine UA
10434   United Arab Emirates    AE
10435   United Kingdom  GB
10436   United States   US
10437   United States Minor Outlying Islands    UM
10438   Uruguay UY
10439   Uzbekistan  UZ
10440   Vanuatu VU
10441   Venezuela   VE
10442   Viet Nam    VN
10443   Virgin Islands, British VG
10444   Virgin Islands, U.S.    VI
10445   Wallis and Futuna   WF
10446   Western Sahara  EH
10447   Yemen   YE
10448   Zambia  ZM
10449   Zimbabwe    ZW
\.


--
-- Name: countries_id_seq; Type: SEQUENCE SET; Schema: public; Owner: agufranov
--

SELECT pg_catalog.setval('countries_id_seq', 10449, true);


--
-- Data for Name: languages; Type: TABLE DATA; Schema: public; Owner: agufranov
--

COPY languages (id, name, native_name, code) FROM stdin;
7827    Abkhaz  аҧсуа  ab
7828    Afar    Afaraf  aa
7829    Afrikaans   Afrikaans   af
7830    Akan    Akan    ak
7831    Albanian    Shqip   sq
7832    Amharic አማርኛ    am
7833    Arabic  العربية  ar
7834    Aragonese   Aragonés   an
7835    Armenian    Հայերեն  hy
7836    Assamese    অসমীয়া   as
7837    Avaric  авар мацӀ, магӀарул мацӀ    av
7838    Avestan avesta  ae
7839    Aymara  aymar aru   ay
7840    Azerbaijani azərbaycan dili    az
7841    Bambara bamanankan  bm
7842    Bashkir башҡорт теле ba
7843    Basque  euskara, euskera    eu
7844    Belarusian  Беларуская    be
7845    Bengali বাংলা bn
7846    Bihari  भोजपुरी   bh
7847    Bislama Bislama bi
7848    Bosnian bosanski jezik  bs
7849    Breton  brezhoneg   br
7850    Bulgarian   български език bg
7851    Burmese ဗမာစာ my
7852    Catalan; Valencian  Català ca
7853    Chamorro    Chamoru ch
7854    Chechen нохчийн мотт ce
7855    Chichewa; Chewa; Nyanja chiCheŵa, chinyanja    ny
7856    Chinese 中文 (Zhōngwén), 汉语, 漢語 zh
7857    Chuvash чӑваш чӗлхи   cv
7858    Cornish Kernewek    kw
7859    Corsican    corsu, lingua corsa co
7860    Cree    ᓀᐦᐃᔭᐍᐏᐣ   cr
7861    Croatian    hrvatski    hr
7862    Czech   česky, čeština   cs
7863    Danish  dansk   da
7864    Divehi; Dhivehi; Maldivian; ދިވެހި    dv
7865    Dutch   Nederlands, Vlaams  nl
7866    English English en
7867    Esperanto   Esperanto   eo
7868    Estonian    eesti, eesti keel   et
7869    Ewe Eʋegbe ee
7870    Faroese føroyskt   fo
7871    Fijian  vosa Vakaviti   fj
7872    Finnish suomi, suomen kieli fi
7873    French  français, langue française    fr
7874    Fula; Fulah; Pulaar; Pular  Fulfulde, Pulaar, Pular ff
7875    Galician    Galego  gl
7876    Georgian    ქართული   ka
7877    German  Deutsch de
7878    Greek, Modern   Ελληνικά    el
7879    Guaraní    Avañeẽ   gn
7880    Gujarati    ગુજરાતી   gu
7881    Haitian; Haitian Creole Kreyòl ayisyen ht
7882    Hausa   Hausa, هَوُسَ ha
7883    Hebrew (modern) עברית  he
7884    Herero  Otjiherero  hz
7885    Hindi   हिन्दी, हिंदी hi
7886    Hiri Motu   Hiri Motu   ho
7887    Hungarian   Magyar  hu
7888    Interlingua Interlingua ia
7889    Indonesian  Bahasa Indonesia    id
7890    Interlingue Originally called Occidental; then Interlingue after WWII   ie
7891    Irish   Gaeilge ga
7892    Igbo    Asụsụ Igbo  ig
7893    Inupiaq Iñupiaq, Iñupiatun    ik
7894    Ido Ido io
7895    Icelandic   Íslenska   is
7896    Italian Italiano    it
7897    Inuktitut   ᐃᓄᒃᑎᑐᑦ  iu
7898    Japanese    日本語 (にほんご／にっぽんご)  ja
7899    Javanese    basa Jawa   jv
7900    Kalaallisut, Greenlandic    kalaallisut, kalaallit oqaasii  kl
7901    Kannada ಕನ್ನಡ kn
7902    Kanuri  Kanuri  kr
7903    Kashmiri    कश्मीरी, كشميري‎  ks
7904    Kazakh  Қазақ тілі kk
7905    Khmer   ភាសាខ្មែរ km
7906    Kikuyu, Gikuyu  Gĩkũyũ   ki
7907    Kinyarwanda Ikinyarwanda    rw
7908    Kirghiz, Kyrgyz кыргыз тили   ky
7909    Komi    коми кыв kv
7910    Kongo   KiKongo kg
7911    Korean  한국어 (韓國語), 조선말 (朝鮮語)    ko
7912    Kurdish Kurdî, كوردی‎   ku
7913    Kwanyama, Kuanyama  Kuanyama    kj
7914    Latin   latine, lingua latina   la
7915    Luxembourgish, Letzeburgesch    Lëtzebuergesch lb
7916    Luganda Luganda lg
7917    Limburgish, Limburgan, Limburger    Limburgs    li
7918    Lingala Lingála    ln
7919    Lao ພາສາລາວ   lo
7920    Lithuanian  lietuvių kalba lt
7921    Luba-Katanga        lu
7922    Latvian latviešu valoda    lv
7923    Manx    Gaelg, Gailck   gv
7924    Macedonian  македонски јазик mk
7925    Malagasy    Malagasy fiteny mg
7926    Malay   bahasa Melayu, بهاس ملايو‎   ms
7927    Malayalam   മലയാളം  ml
7928    Maltese Malti   mt
7929    Māori  te reo Māori   mi
7930    Marathi (Marāṭhī)   मराठी mr
7931    Marshallese Kajin M̧ajeļ  mh
7932    Mongolian   монгол    mn
7933    Nauru   Ekakairũ Naoero    na
7934    Navajo, Navaho  Diné bizaad, Dinékʼehǰí    nv
7935    Norwegian Bokmål   Norsk bokmål   nb
7936    North Ndebele   isiNdebele  nd
7937    Nepali  नेपाली  ne
7938    Ndonga  Owambo  ng
7939    Norwegian Nynorsk   Norsk nynorsk   nn
7940    Norwegian   Norsk   no
7941    Nuosu   ꆈꌠ꒿ Nuosuhxop ii
7942    South Ndebele   isiNdebele  nr
7943    Occitan Occitan oc
7944    Ojibwe, Ojibwa  ᐊᓂᔑᓈᐯᒧᐎᓐ    oj
7945    Old Church Slavonic, Church Slavic, Church Slavonic, Old Bulgarian, Old Slavonic    ѩзыкъ словѣньскъ cu
7946    Oromo   Afaan Oromoo    om
7947    Oriya   ଓଡ଼ିଆ or
7948    Ossetian, Ossetic   ирон æвзаг os
7949    Panjabi, Punjabi    ਪੰਜਾਬੀ, پنجابی‎ pa
7950    Pāli   पाऴि    pi
7951    Persian فارسی  fa
7952    Polish  polski  pl
7953    Pashto, Pushto  پښتو    ps
7954    Portuguese  Português  pt
7955    Quechua Runa Simi, Kichwa   qu
7956    Romansh rumantsch grischun  rm
7957    Kirundi kiRundi rn
7958    Romanian, Moldavian, Moldovan   română    ro
7959    Russian русский язык ru
7960    Sanskrit (Saṁskṛta) संस्कृतम् sa
7961    Sardinian   sardu   sc
7962    Sindhi  सिन्धी, سنڌي، سندھی‎    sd
7963    Northern Sami   Davvisámegiella    se
7964    Samoan  gagana faa Samoa    sm
7965    Sango   yângâ tî sängö sg
7966    Serbian српски језик sr
7967    Scottish Gaelic; Gaelic Gàidhlig   gd
7968    Shona   chiShona    sn
7969    Sinhala, Sinhalese  සිංහල si
7970    Slovak  slovenčina sk
7971    Slovene slovenščina   sl
7972    Somali  Soomaaliga, af Soomaali so
7973    Southern Sotho  Sesotho st
7974    Spanish; Castilian  español, castellano    es
7975    Sundanese   Basa Sunda  su
7976    Swahili Kiswahili   sw
7977    Swati   SiSwati ss
7978    Swedish svenska sv
7979    Tamil   தமிழ் ta
7980    Telugu  తెలుగు  te
7981    Tajik   тоҷикӣ, toğikī, تاجیکی‎ tg
7982    Thai    ไทย   th
7983    Tigrinya    ትግርኛ    ti
7984    Tibetan Standard, Tibetan, Central  བོད་ཡིག   bo
7985    Turkmen Türkmen, Түркмен    tk
7986    Tagalog Wikang Tagalog, ᜏᜒᜃᜅ᜔ ᜆᜄᜎᜓᜄ᜔  tl
7987    Tswana  Setswana    tn
7988    Tonga (Tonga Islands)   faka Tonga  to
7989    Turkish Türkçe    tr
7990    Tsonga  Xitsonga    ts
7991    Tatar   татарча, tatarça, تاتارچا‎ tt
7992    Twi Twi tw
7993    Tahitian    Reo Tahiti  ty
7994    Uighur, Uyghur  Uyƣurqə, ئۇيغۇرچە‎  ug
7995    Ukrainian   українська    uk
7996    Urdu    اردو    ur
7997    Uzbek   zbek, Ўзбек, أۇزبېك‎   uz
7998    Venda   Tshivenḓa ve
7999    Vietnamese  Tiếng Việt  vi
8000    Volapük    Volapük    vo
8001    Walloon Walon   wa
8002    Welsh   Cymraeg cy
8003    Wolof   Wollof  wo
8004    Western Frisian Frysk   fy
8005    Xhosa   isiXhosa    xh
8006    Yiddish ייִדיש    yi
8007    Yoruba  Yorùbá    yo
8008    Zhuang, Chuang  Saɯ cueŋƅ, Saw cuengh    za
\.


--
-- Name: languages_id_seq; Type: SEQUENCE SET; Schema: public; Owner: agufranov
--

SELECT pg_catalog.setval('languages_id_seq', 8008, true);


--
-- Data for Name: professions; Type: TABLE DATA; Schema: public; Owner: agufranov
--

COPY professions (id, title) FROM stdin;
157 firefighter
158 advocate
159 attorney at law
160 teacher
161 doctor
162 agriculturist
163 statistician
164 programmer
165 engineer
166 judge
167 architect
168 writer
169 economist
170 accountant
171 human resources
172 chemist
173 actor
174 interpreter
175 web developer
176 biologist
177 musician
178 astronomer
179 designer
180 physicist
181 librarian
182 philosopher
183 police officer
\.


--
-- Name: professions_id_seq; Type: SEQUENCE SET; Schema: public; Owner: agufranov
--

SELECT pg_catalog.setval('professions_id_seq', 183, true);


--
-- Data for Name: project_managers; Type: TABLE DATA; Schema: public; Owner: agufranov
--

COPY project_managers (id, name, email, address, client_id) FROM stdin;
830 Lincoln Greenholt   paxton.thompson@kuhlman.io  Wernerview, 7314 Rudolph Drives 458
831 Dr. Russell Fritsch ardith.witting@ritchiekuphal.co Maudietown, 8009 Riley Dam  458
832 Guillermo Carter    unique@haley.org    Smithview, 2364 Heaney Freeway  458
833 Leta Cole   mariane_simonis@feil.io West Waino, 633 Camren Extensions   458
834 Godfrey Rath    deron_dietrich@langworth.info   Reesebury, 1728 Darwin Parkway  460
835 Elinore Ferry I giovanni_runolfsdottir@funk.net Lake Warren, 8562 Morissette Extensions 461
836 Jerad Kuhn  coy@koelpinheidenreich.co   Bradtkeburgh, 57101 Aleen Causeway  461
837 Aisha Torp Jr.  claria_gutkowski@bruen.biz  New Herminio, 5266 Freda Island 461
838 Ms. Esmeralda Walter    gayle@fritschking.io    Isadoreton, 22900 Mireille Summit   462
839 Odell Ziemann   rosemarie_witting@wehner.name   Kirlinland, 21763 Konopelski Crossing   462
840 Ethelyn Stehr   makenzie@mayert.org Port Marleneland, 16295 Gerald Run  462
841 Effie Olson lon.bailey@bergnaumemard.org    New Winnifredtown, 4583 Mohr Canyon 464
842 Sigrid Haley II jayme@dare.com  Baileestad, 65790 Broderick Rue 465
843 Loraine Rolfson olaf@boyer.info East Aditya, 4173 Alexys Shore  465
844 Mrs. Paula Anderson julie.erdman@sawayn.io  Watsicahaven, 1257 Ora Ports    466
845 Gail Littel IV  jamil.stanton@swaniawskimedhurst.org    South Lorinehaven, 27001 Halvorson Key  466
846 Dortha Weber IV alene.nikolaus@turcotterogahn.co    East Dianaberg, 5853 Destini Junctions  466
847 Bertram Kertzmann PhD   ewald_brown@langosh.name    Jerelport, 161 Roob Mount   467
848 Tristin Torp III    orlando.heller@dachpollich.com  Abbyfort, 5892 Fisher Roads 467
849 Hilario Wintheiser  janea@hoppeschiller.net New Eliport, 1929 Kaitlin Hills 468
850 Milo Bernhard   kaley_kling@lynch.co    Port Chauncey, 6147 Paul Islands    468
851 Isaiah Schmitt  lennie@ritchie.co   Lilafort, 6462 Clotilde Square  470
852 Florian Kris    skylar_dach@carroll.io  Sengerfurt, 458 Schroeder Squares   471
853 Elliott Boyle   delilah.okeefe@turnermohr.org   Heathcotebury, 89237 Stroman Well   471
854 Ara Fay ellsworth@lubowitz.org  West Destany, 8951 Hammes Spurs 471
855 Noe Nolan PhD   aleandra@gutkowski.net  West Carletonville, 26642 Darby Parkway 471
856 Myrtle Grady II twila@hayes.io  Langhaven, 7266 Leann Loop  472
857 Jayden Bayer    kaylin@schinnerrath.com Hahnport, 5409 DuBuque Lock 472
858 Julio Stoltenberg   neal@schultzlabadie.org Danport, 29944 Brian Spring 472
859 Gene Rice III   arnoldo.balistreri@sengerschinner.co    Lake Edmond, 171 Satterfield Rue    472
860 Deshaun Wunsch  remington@lueilwitzcronin.com   North Edgarstad, 68499 Zieme Stravenue  473
861 Mrs. Brennan Blanda arvel@treutel.com   New Abbey, 64900 Chelsey Causeway   473
862 Helena Luettgen DDS lupe@aufderharwalter.com    South Bertha, 66990 Thiel Manors    473
863 Mr. Kaleigh Heaney  sasha@white.name    Watersbury, 867 Carroll Creek   473
864 Obie Marquardt  morgan.steuber@yundt.org    New Jamisonland, 88584 Barrows Passage  474
865 Ms. Gilbert Watsica mateo.reichert@wolff.net    Port Eladioborough, 4160 Roob Landing   474
866 Ms. Verlie Brown    cullen@labadie.io   West Chethaven, 65404 Emmalee Squares   474
867 Ms. Zane Gislason   oran@carrollbailey.com  West Guy, 7500 Virginie Course  476
868 Dan Brekke III  clay_lockman@deckow.biz Joanyside, 49015 O'Keefe Drive  476
869 Kailey Vandervort   kallie.lowe@mertzhuel.io    North Alexanne, 818 Shanahan Stream 476
870 Miss Elva Hamill    nathen@baileydoyle.net  South Daphney, 7650 Zieme Orchard   476
871 Shawn Kerluke   cole@macgyverbradtke.com    McLaughlinside, 82647 Pierce Haven  477
872 Marquis Stokes PhD  ford@yundt.name South Rhett, 890 Tremblay Station   477
873 Ollie Ondricka  devyn.kilback@legros.co Trevionmouth, 8407 Moses Junction   477
\.


--
-- Name: project_managers_id_seq; Type: SEQUENCE SET; Schema: public; Owner: agufranov
--

SELECT pg_catalog.SETVAL('project_managers_id_seq', 873, TRUE);


--
-- Data for Name: projects; Type: TABLE DATA; Schema: public; Owner: agufranov
--

COPY projects (id, NUMBER, project_id_client, words_count, budget_cents, STATUS, start_date, planned_end_date, actual_end_date, comments, client_id, project_manager_id, country_id, original_language_id, target_language_id, condition_id, speciality_id) FROM stdin;
1703    2015-061    748-52-2672 37093   196000  1   2015-01-12 09:05:28.171014  2015-03-01 09:26:13 2015-11-08 23:09:36 \N  464 841 10211   7942    7827    81  81
1643    2015-001    664-04-7052 8907    27000   2   2015-05-28 13:52:10.056941  2015-04-18 08:07:17 2015-07-14 10:50:45 \N  473 862 10354   7976    7901    82  82
1644    2015-002    815-41-1895 7629    98000   1   2015-05-17 22:54:30.013466  2015-07-07 06:37:11 2015-10-13 05:23:59 \N  460 834 10295   7976    7855    82  82
1645    2015-003    262-96-4676 27734   13000   1   2014-12-11 02:33:57.390363  2015-05-25 16:56:26 2015-02-16 02:35:21 \N  470 851 10309   7895    7971    82  81
1646    2015-004    887-05-7160 35139   35000   2   2015-05-22 14:15:16.198981  2018-02-28 02:44:30 2015-09-11 15:48:49 Delectus quae quo tempora ea. Vitae eum voluptate. Eos ducimus sit sequi. Tempore odit quae pariatur repudiandae culpa voluptatem. Est beatae ad architecto incidunt aspernatur.    473 861 10439   7900    7951    82  82
1647    2015-005    785-24-2714 34172   227000  1   2015-02-17 23:50:16.487015  2014-12-11 10:23:52 2015-05-28 18:24:54 Molestiae eius et voluptas. Quis laudantium inventore repudiandae iusto sint est asperiores. Omnis ut sed. Quaerat doloremque repudiandae libero.   458 830 10419   8007    7984    81  81
1648    2015-006    348-09-0782 19409   95000   2   2015-03-02 04:52:15.492186  2018-03-10 09:32:15 2015-08-01 04:01:51 \N  465 842 10390   7910    7937    82  82
1649    2015-007    261-47-2646 31368   127000  2   2015-08-28 16:09:43.906336  2015-09-26 00:23:16 2015-11-11 09:45:38 \N  460 834 10371   7877    7940    81  81
1650    2015-008    206-26-5555 37561   279000  2   2015-02-05 02:20:56.964479  2015-11-15 22:38:43 2015-06-03 16:36:50 Temporibus optio voluptates iste quo. Reiciendis cum aut minima sed qui ut. Modi aut fuga earum occaecati. Velit consequatur aut atque et ratione.  462 838 10222   7983    7942    81  81
1651    2015-009    311-77-5099 17463   190000  2   2015-04-18 02:23:02.964668  2018-08-25 10:28:57 2015-06-25 15:27:09 \N  475 \N  10407   7874    7860    82  81
1652    2015-010    099-53-1195 16352   154000  0   2015-06-10 13:54:36.245592  2015-04-18 20:13:58 \N  \N  475 \N  10245   7975    7859    82  81
1653    2015-011    075-99-0894 25336   73000   2   2015-02-08 17:49:26.37194   2015-05-23 12:01:43 2015-06-13 06:27:44 \N  475 \N  10252   7853    7983    82  82
1654    2015-012    569-77-8682 7036    132000  1   2015-03-10 18:25:41.548756  2015-03-20 17:36:04 2015-08-19 17:17:17 Dolor autem culpa et quibusdam accusamus. Nihil aut ut at aliquam unde quo. Soluta sit est. 470 851 10380   7950    7873    82  82
1655    2015-013    863-45-3723 39213   114000  1   2015-02-07 07:41:06.645546  2015-06-07 21:47:17 2015-10-02 12:54:47 \N  464 841 10224   7875    7837    82  82
1656    2015-014    168-43-4453 28287   143000  0   2015-08-07 10:15:13.55195   2018-03-14 19:00:23 \N  Quia velit iusto odio aut rerum. Sed voluptas molestiae dolorem. Expedita magni et asperiores. Vero perspiciatis recusandae magni cum.  471 852 10313   7873    7843    82  81
1657    2015-015    661-59-2332 31331   206000  1   2015-04-11 07:15:10.627313  2015-06-18 12:41:11 2015-11-17 16:31:50 \N  472 856 10448   7847    7994    81  82
1658    2015-016    723-95-3537 10225   258000  0   2015-07-28 08:18:08.047307  2018-01-06 10:10:03 \N  \N  477 871 10444   7831    7873    82  81
1659    2015-017    862-77-6786 15128   238000  2   2014-12-15 10:52:52.581566  2015-06-05 09:03:26 2014-12-24 20:03:39 \N  466 846 10295   8005    7827    82  81
1660    2015-018    295-96-5408 6627    167000  1   2015-05-18 14:50:40.705316  2018-02-05 08:02:20 2015-07-31 23:13:37 Labore voluptatum est. Occaecati sit quisquam. Deserunt recusandae rem. Et et tempore molestiae quae. Nulla voluptates cupiditate ut expedita repellendus culpa dolores.    462 838 10350   7976    7876    82  82
1661    2015-019    657-15-7411 28915   58000   2   2015-07-26 00:18:36.41428   2015-04-19 21:11:19 2015-11-29 01:47:21 \N  459 \N  10366   7986    7878    81  82
1662    2015-020    848-44-4627 22576   35000   2   2015-06-07 06:43:01.821402  2015-03-09 21:13:16 2015-08-02 00:28:37 Unde recusandae labore sit porro ut hic rerum. Iusto laboriosam consequatur fugit ut quia fugiat dolores. Molestiae eum aspernatur quisquam rerum.  460 834 10339   7900    7921    81  82
1663    2015-021    864-33-7464 25771   143000  2   2015-02-01 19:31:26.625109  2015-01-12 01:33:23 2015-04-23 05:48:59 \N  464 841 10269   7872    7948    81  81
1664    2015-022    536-86-6693 26043   29000   2   2015-05-28 07:08:29.484822  2015-08-26 04:53:47 2015-09-24 13:38:19 \N  464 841 10429   7979    7901    82  82
1665    2015-023    271-33-2515 18126   152000  2   2015-01-07 04:48:46.495351  2015-06-25 16:14:35 2015-07-21 10:05:22 Quo qui nihil necessitatibus quo ea est. IN iure reiciendis est corrupti ipsa. Similique doloremque minus. Quo neque itaque sint.   474 866 10359   7941    7964    81  82
1666    2015-024    497-83-3253 42684   182000  0   2015-05-28 13:07:29.542087  2015-06-12 20:31:02 \N  \N  464 841 10401   7876    7921    82  81
1667    2015-025    491-69-0529 15055   127000  2   2015-01-02 20:05:03.857955  2018-11-22 22:25:41 2015-06-27 19:53:53 Omnis maiores voluptatem ullam sequi. Et amet impedit iusto est. Architecto quisquam accusamus maiores praesentium. 461 837 10353   7882    7978    82  82
1668    2015-026    835-22-0823 24837   262000  1   2015-02-18 16:29:53.147062  2015-11-11 01:07:01 2015-03-09 18:44:15 Dolor ipsam amet ea. Sit quod accusamus. Laborum est non accusantium. Esse rerum tempore facere inventore et. Impedit magni optio rerum iste illum architecto suscipit. 459 \N  10366   7863    8006    81  81
1669    2015-027    831-55-0755 25666   209000  0   2015-02-20 22:06:20.464556  2015-11-21 02:10:24 \N  \N  465 842 10407   7992    7904    81  82
1670    2015-028    162-52-0253 9926    220000  2   2015-06-27 16:46:08.806656  2018-01-02 14:48:36 2015-09-02 17:44:23 IN non aspernatur saepe nihil fuga fugit mollitia. Soluta illum fuga consequatur veritatis eius. Et placeat ut corporis. Similique sed ea cupiditate numquam velit et quaerat.  474 864 10395   7829    7903    82  81
1671    2015-029    036-33-1723 31348   54000   1   2015-02-01 01:17:35.871739  2018-09-22 08:47:24 2015-03-31 20:20:39 \N  466 846 10332   7892    7963    81  81
1672    2015-030    614-98-3922 10327   180000  1   2014-12-23 06:02:57.543248  2015-07-18 18:27:01 2015-03-07 15:41:02 Aut ullam eos atque reiciendis consequatur. Nostrum officiis quo harum autem expedita sint. Rerum aperiam doloribus nisi. Cupiditate vero enim illum adipisci veritatis officiis rem. Vel et repudiandae ut.    474 864 10288   8002    7870    82  82
1673    2015-031    394-04-2203 8703    173000  1   2015-05-14 18:44:51.216313  2018-12-02 04:53:04 2015-10-22 06:26:52 \N  468 849 10343   7900    7944    82  81
1674    2015-032    496-92-9206 39453   289000  1   2015-03-07 22:26:53.813489  2015-10-04 11:38:04 2015-10-03 07:47:52 Ad aut velit debitis rerum aut modi. Qui sit sint vel nobis culpa voluptas iste. Architecto reprehenderit aperiam minus commodi aliquid et. 459 \N  10378   7830    7843    82  82
1675    2015-033    444-15-2536 33450   93000   2   2015-02-20 17:06:42.848438  2018-02-11 05:11:18 2015-06-06 20:42:13 Omnis ab officiis corporis. Ducimus voluptatem soluta sequi expedita cupiditate qui. Fugiat IN at sit magnam eum quae. Ratione maiores quam nulla.  458 831 10370   7900    7911    81  81
1676    2015-034    103-10-0490 42934   31000   1   2015-02-28 17:55:29.784699  2015-03-13 13:52:01 2015-04-11 14:24:37 \N  468 849 10358   7883    7865    81  81
1677    2015-035    601-16-7396 3207    131000  2   2015-01-23 03:16:35.792397  2015-11-09 14:32:26 2015-08-23 14:05:08 \N  461 837 10242   8006    7967    82  81
1678    2015-036    524-86-8495 38731   199000  0   2015-07-15 16:14:28.734666  2015-04-24 08:21:22 \N  \N  475 \N  10430   7963    7880    82  82
1679    2015-037    777-20-0055 37734   203000  2   2015-02-20 16:30:21.934619  2018-01-02 15:36:34 2015-07-12 21:10:50 Aspernatur doloribus facere placeat facilis eum magni illum. Eos velit voluptates. Sapiente totam et officiis quo et.   468 849 10404   7966    7953    81  81
1680    2015-038    858-73-9251 17780   152000  2   2015-07-24 09:07:54.823456  2018-07-25 00:57:32 2015-11-19 21:51:23 \N  462 839 10215   7963    7994    82  82
1681    2015-039    703-85-2684 18139   204000  1   2015-03-09 16:26:06.900012  2018-10-11 06:46:33 2015-04-28 09:09:01 Sit rem aut facilis quia accusamus. Dicta iusto suscipit mollitia magnam. Maxime velit rerum laudantium voluptas blanditiis. Saepe voluptatem rem vel consequatur doloremque.   466 846 10234   8008    7944    82  81
1682    2015-040    336-05-4915 39533   31000   1   2015-04-12 19:56:45.206785  2018-03-25 17:26:39 2015-09-14 09:10:11 Placeat fuga corporis omnis quasi qui rem dolorem. Harum veritatis tempore et error voluptatum. Repellendus enim modi porro.    462 839 10286   7916    7884    81  81
1704    2015-062    432-45-5732 7705    230000  0   2015-08-09 04:23:14.052347  2015-01-25 23:58:51 \N  Dolor possimus eum quod IN excepturi magnam ipsa. Nulla ut dolor expedita ullam quas IN ratione. Dolorem amet animi modi consequatur.   464 841 10322   7931    7875    82  81
1705    2015-063    657-39-6736 6065    173000  2   2015-06-23 15:24:37.207595  2018-12-05 01:36:28 2015-09-30 04:43:58 \N  477 871 10347   7992    7831    82  81
1706    2015-064    263-10-2607 10669   143000  2   2014-12-19 20:53:55.267585  2018-04-04 12:27:17 2015-03-23 16:23:29 \N  474 866 10235   7918    7898    81  82
1707    2015-065    854-42-7662 35084   140000  1   2014-12-15 23:36:56.873191  2014-12-07 15:10:47 2015-03-31 06:21:13 Quo dicta ab non reiciendis saepe et. Sunt excepturi sint dolorem. Qui reiciendis ducimus animi molestiae voluptatum rerum. 461 836 10254   7943    7869    82  82
1708    2015-066    758-68-1723 16016   115000  1   2015-01-19 01:55:57.358036  2015-11-19 02:24:58 2015-08-14 19:13:07 \N  475 \N  10447   7921    7852    82  82
1709    2015-067    506-83-9718 3143    50000   1   2015-02-18 06:18:37.82873   2018-09-15 13:16:38 2015-09-21 06:55:57 Molestiae id non vel voluptate. Quia atque sunt quas odit. Quia suscipit atque perspiciatis.    477 873 10380   7867    7922    81  82
1710    2015-068    731-69-0527 17521   241000  1   2015-04-08 10:44:59.192017  2015-05-14 06:40:01 2015-09-17 07:47:40 Exercitationem corrupti iusto velit voluptas. Et qui voluptatem omnis nulla suscipit recusandae. Rem qui sit reiciendis labore. Consequatur id iure dolorem ut non. 469 \N  10403   7875    7979    82  82
1711    2015-069    009-26-8226 5646    70000   0   2015-03-06 19:15:37.20664   2015-11-14 15:14:09 \N  Sit id numquam odio nam deserunt autem. Ad non alias. Dignissimos harum quod suscipit repellendus enim nesciunt. Molestiae odio eveniet quasi nobis ut. 474 866 10236   7837    7860    81  82
1712    2015-070    780-97-7886 20324   223000  0   2015-03-07 15:20:46.068283  2015-07-12 23:12:29 \N  \N  458 830 10322   7934    7868    81  81
1713    2015-071    837-73-7244 26852   130000  2   2015-02-10 16:38:22.03247   2018-05-09 12:52:47 2015-02-26 21:27:40 Illum est consequatur nihil. Et velit cumque eum. Nihil eaque et explicabo. Labore molestiae a id. Est dolores cumque porro accusamus unde dolor.   473 863 10353   7944    7914    82  82
1714    2015-072    872-22-7237 34231   129000  0   2015-04-18 04:13:10.737035  2015-08-20 03:27:28 \N  \N  466 844 10211   7902    7932    81  81
1715    2015-073    652-77-9145 18900   108000  1   2015-01-22 16:24:43.537153  2018-10-02 17:23:02 2015-03-20 07:23:16 Quo quo aut nam distinctio. Fugiat ut itaque aut provident et dicta libero. Tenetur fugiat dolore ut asperiores aut architecto. Sit voluptas assumenda aut voluptate nulla. Aut deserunt id eos vero tempora facilis vitae. 475 \N  10341   7846    7977    81  81
1716    2015-074    762-06-6396 36279   52000   1   2015-06-09 12:35:20.201351  2015-05-11 11:41:13 2015-07-13 22:14:13 Rerum natus quis sit est. Nulla est vitae. Ipsam soluta incidunt et praesentium cumque. 466 845 10397   7830    7934    82  82
1717    2015-075    771-55-7038 9438    215000  0   2015-03-29 19:34:10.990524  2018-11-09 23:56:55 \N  Eligendi ipsum tempore incidunt aliquid hic et. Consequatur enim et dolor autem veritatis. Aut natus consequuntur. Cumque amet veniam quod. Ipsum nam quibusdam ab ut.  463 \N  10362   7845    7973    82  81
1718    2015-076    869-95-5518 40381   304000  2   2015-01-09 14:35:30.675737  2018-06-26 00:28:31 2015-11-19 07:34:51 \N  475 \N  10279   7870    7943    81  81
1719    2015-077    172-11-0376 30590   38000   1   2015-04-07 16:46:40.936386  2015-02-10 16:35:35 2015-10-06 18:50:35 \N  458 832 10446   7911    7973    81  81
1720    2015-078    010-81-8548 36051   217000  1   2015-09-04 00:58:01.748704  2018-04-18 00:30:43 2015-09-23 07:41:21 IN nihil repellat incidunt consequatur voluptatibus est quae. Ut odit dicta recusandae sit natus. Atque quo sit possimus alias inventore. Maiores perspiciatis temporibus non ut quia vitae et. 459 \N  10337   7883    7902    82  82
1721    2015-079    300-27-5875 27694   148000  1   2015-06-01 22:49:01.073705  2018-09-25 23:20:40 2015-10-28 15:05:28 \N  468 849 10251   8006    8002    82  82
1722    2015-080    363-27-1974 20244   182000  2   2015-01-27 10:22:58.322813  2015-04-17 04:13:46 2015-04-17 02:03:21 \N  466 844 10396   7918    7941    82  81
1723    2015-081    344-55-8152 24005   272000  2   2015-04-04 18:28:08.425631  2015-04-23 23:32:33 2015-06-19 16:39:14 \N  476 869 10258   7981    7913    82  81
1724    2015-082    456-03-5779 40017   189000  2   2015-08-05 00:49:30.144184  2018-02-05 13:04:29 2015-10-31 06:01:24 \N  470 851 10341   7882    7895    81  81
1725    2015-083    701-51-5587 7182    300000  1   2015-03-09 23:42:11.504129  2015-08-31 23:35:08 2015-04-06 01:10:58 \N  458 830 10350   7940    7877    81  82
1726    2015-084    517-70-8617 15924   225000  1   2015-03-01 02:20:24.63036   2015-06-25 13:49:06 2015-08-29 06:06:50 Et sint sit earum dolorum. Rerum sit sequi commodi. Similique architecto et dignissimos error sint iste. Qui placeat ut cupiditate eveniet quis. Dolorem delectus non recusandae cum.   465 843 10235   7975    7851    82  82
1727    2015-085    797-97-1609 35969   18000   1   2015-02-26 23:54:15.634566  2015-05-22 15:23:47 2015-06-03 13:45:49 \N  465 843 10369   7918    7877    81  82
1728    2015-086    649-03-1504 26257   174000  1   2015-06-30 02:59:54.791165  2018-02-09 23:12:31 2015-12-04 22:06:19 \N  460 834 10247   7984    7842    81  81
1729    2015-087    682-01-4608 7713    295000  1   2015-04-15 14:44:28.288179  2018-01-01 17:44:49 2015-09-11 23:47:35 Dolore laborum pariatur nisi consequatur tempora vitae commodi. Ea sed aut debitis sed. Nisi illo porro rerum odit ea ut ut. Rerum enim qui quod.   472 859 10217   7868    7960    81  81
1730    2015-088    668-17-0755 30391   171000  2   2015-04-22 09:47:06.045295  2015-03-09 20:43:30 2015-07-29 06:24:53 Dolore architecto impedit at voluptatem. Architecto aut quos. Quia tempora officiis accusamus consectetur maiores soluta dolores. Labore natus ipsum aspernatur reiciendis nulla non fuga.  477 871 10446   7938    8006    81  82
1731    2015-089    152-28-5011 11501   231000  2   2015-05-20 13:24:40.090881  2018-07-29 04:15:07 2015-05-28 20:15:08 \N  458 832 10242   7954    7945    82  81
1732    2015-090    638-60-1644 16405   245000  1   2015-01-21 20:05:54.154637  2018-11-14 09:31:09 2015-01-21 06:51:58 Ad eum amet dolorem quam nihil expedita cumque. Qui aut sed ut explicabo velit. Possimus quisquam maxime voluptatum. Id reiciendis ipsa harum tempora. Accusantium quaerat dolorum dolor quos molestiae atque impedit.  471 854 10403   7887    7997    82  82
1733    2015-091    200-19-4976 7090    209000  1   2015-03-28 22:00:56.087798  2015-06-09 20:13:04 2015-07-15 00:29:41 Voluptatem natus quod sit maxime. Omnis saepe ipsa nisi ab. Soluta impedit voluptatem iure maiores consequatur accusamus. Dicta aut alias minima magni. 460 834 10207   7972    8001    82  82
1734    2015-092    256-29-6415 31329   302000  2   2015-08-10 19:41:44.022468  2015-11-09 19:22:27 2015-10-25 20:29:21 \N  472 859 10363   7920    7932    82  82
1735    2015-093    371-82-5360 23339   53000   2   2015-03-18 20:07:26.846962  2015-03-20 05:27:47 2015-11-10 19:53:55 \N  462 840 10307   7910    7934    81  81
1736    2015-094    774-84-3876 34732   227000  1   2015-06-16 08:01:37.809133  2018-09-26 03:24:38 2015-07-03 11:31:03 \N  477 872 10427   7912    8001    81  81
1737    2015-095    115-11-4498 4824    189000  1   2015-03-19 02:43:02.980779  2018-01-16 20:24:29 2015-05-23 05:28:26 \N  466 845 10380   7959    7833    82  81
1738    2015-096    885-86-1596 37995   305000  1   2015-02-26 04:20:58.622507  2015-06-07 20:13:30 2015-10-10 15:48:39 Quia illum eius recusandae itaque fugit. Quis ab IN. Quam perferendis sint qui animi.   472 859 10381   7924    7892    82  81
1739    2015-097    827-59-2623 13684   103000  2   2015-03-25 20:14:41.306034  2015-06-13 12:07:26 2015-04-25 22:31:11 \N  470 851 10359   7991    7985    81  81
1740    2015-098    242-46-0752 6241    92000   1   2015-01-05 07:43:28.980581  2015-06-22 20:52:10 2015-01-31 05:15:42 \N  464 841 10320   7924    7978    81  81
1741    2015-099    195-85-5789 10155   234000  1   2015-04-19 15:36:16.926483  2015-05-05 05:36:30 2015-06-06 15:14:00 Laboriosam vel eius vitae itaque mollitia voluptatem sit. Ut quo doloremque et. Dolor labore blanditiis perferendis qui. Ratione consequatur debitis molestiae quia. Quasi neque commodi sint voluptatem at dolores.    466 845 10300   7971    7936    82  81
1742    2015-100    337-02-5737 27853   91000   1   2015-03-27 11:19:30.770814  2018-02-15 07:51:19 2015-06-08 00:13:13 \N  468 850 10229   7836    7983    82  81
1743    2015-101    449-62-3509 14675   38000   0   2015-08-06 08:16:29.961467  2015-02-03 07:21:08 \N  Dolores quia mollitia. Deserunt nam facere aut IN neque fuga. Consectetur voluptatem dolor excepturi odio molestias doloremque. Alias dolor qui et est blanditiis voluptates fuga.  477 871 10232   7988    7988    81  81
1744    2015-102    748-18-4990 4625    104000  2   2015-05-29 10:04:19.271404  2018-04-11 13:08:55 2015-11-05 03:30:58 Porro asperiores aut commodi ipsa tenetur provident maiores. Vel error illum qui voluptas at dolore soluta. Ut dolores non temporibus. Consequatur distinctio sit est reiciendis nesciunt velit. Qui error eos minus repellat beatae.   467 847 10384   7931    7878    81  82
1745    2015-103    311-41-9964 10586   231000  1   2015-04-14 13:21:23.542116  2015-02-08 18:00:30 2015-05-06 08:08:15 At assumenda consequatur ut laborum. Earum quod vel necessitatibus fuga eos corrupti voluptatem. Dicta vitae veritatis. Non pariatur laudantium IN ab quia perferendis numquam. 471 853 10370   7904    7890    81  81
1746    2015-104    681-89-2029 35619   250000  0   2015-04-06 09:58:04.749818  2015-08-26 05:07:56 \N  Quia quo aut aut sed repudiandae delectus eos. Est odio rem sequi praesentium omnis amet. Delectus iusto et dicta expedita nihil illo ut. Quam laudantium impedit aliquid voluptatem velit accusantium. Optio quos ad vel.  464 841 10347   7943    7993    81  82
1747    2015-105    101-45-2242 21682   305000  2   2015-02-22 14:23:40.68007   2015-07-31 06:29:12 2015-07-11 22:18:33 Voluptas deserunt quas sunt laborum voluptatibus. Vel cum mollitia. Velit minima odit non earum. Dicta vitae debitis.   468 849 10421   7841    7836    82  81
1748    2015-106    436-38-7943 8311    72000   2   2015-08-22 05:56:25.484872  2018-08-29 00:57:24 2015-08-26 13:59:49 Cupiditate qui voluptatibus est atque dolores. Ut ipsa non delectus sunt dolor. Culpa ut cumque sequi dicta. Error est neque voluptatem. Hic molestias quidem.  475 \N  10238   7975    7967    81  81
1749    2015-107    545-81-4973 40893   227000  2   2015-01-22 21:24:28.099727  2015-11-20 22:27:40 2015-02-26 18:27:50 Incidunt praesentium aut rerum odit eaque esse debitis. Cupiditate atque sed vitae aspernatur sed. Sed quis deserunt at fugit facere voluptates quae.   476 869 10291   8004    7897    81  81
1750    2015-108    039-20-5547 21591   130000  0   2015-01-09 15:26:14.270445  2015-01-14 14:45:31 \N  \N  473 861 10346   7923    7842    82  81
1751    2015-109    144-83-5114 6726    101000  2   2015-05-02 14:44:19.094487  2015-07-22 14:27:43 2015-07-12 08:14:34 Ipsam maiores hic quidem ullam ea. Vitae qui tenetur. Eos id assumenda corporis vero provident. 464 841 10239   7855    7932    82  82
1752    2015-110    695-12-4321 9038    75000   0   2014-12-25 04:38:33.483214  2018-08-31 15:17:12 \N  \N  469 \N  10249   7951    7923    81  82
1753    2015-111    059-48-7083 3938    74000   1   2015-02-19 12:35:50.03214   2015-04-27 23:33:15 2015-04-11 01:02:46 Voluptates et qui. Non odio et qui distinctio consequatur. Molestiae voluptate corrupti est commodi similique quas est. 473 863 10369   7839    7877    81  82
1754    2015-112    726-93-1263 21726   162000  1   2015-05-27 01:56:26.190088  2018-04-24 06:11:10 2015-08-15 13:43:05 Labore neque assumenda ullam ad voluptatem. Voluptas possimus officiis quidem cumque sit sequi sed. Ut fugit ut debitis.    461 836 10212   7835    7966    82  82
1755    2015-113    376-46-5324 42452   136000  2   2014-12-11 13:26:35.226562  2015-08-31 11:58:46 2015-07-20 04:51:41 \N  460 834 10287   7907    7841    81  82
1756    2015-114    148-71-2079 18192   249000  0   2015-03-10 14:55:13.565013  2018-07-16 11:47:44 \N  Blanditiis aut accusantium et suscipit molestiae nostrum sit. Aperiam accusamus id. Nihil temporibus amet dicta beatae omnis vero et. Qui dolorem labore et voluptates. 466 844 10400   7833    7979    82  82
1757    2015-115    729-24-8933 40457   296000  1   2014-12-30 04:26:27.917211  2018-09-29 05:00:38 2015-01-01 02:18:49 \N  474 864 10382   7842    7840    82  82
1758    2015-116    771-24-7519 10746   186000  1   2015-07-19 12:06:38.454793  2018-09-30 04:02:21 2015-11-29 05:10:30 Id suscipit enim quas ipsam. Ipsam qui sed enim magnam saepe possimus optio. Voluptatum facere velit est laudantium praesentium voluptates. 475 \N  10379   8005    7849    82  82
1759    2015-117    525-69-8556 3256    237000  2   2015-04-08 12:37:00.323492  2014-12-08 13:14:44 2015-05-02 14:04:28 Quod quia et eum nostrum aut laudantium. Quo veritatis mollitia enim voluptas. Est culpa minus porro.   464 841 10358   7853    7886    81  81
1760    2015-118    569-46-4037 10103   149000  2   2015-01-25 21:54:51.486883  2015-04-23 11:17:23 2015-04-13 15:26:16 Laboriosam rem id incidunt sequi consequuntur cum recusandae. Delectus nemo ea numquam iusto vel laborum alias. Eius harum quia vero quasi autem. Cumque officia aut eveniet. Voluptas accusamus ipsa excepturi ducimus doloribus eum est.  465 843 10219   7892    7910    81  81
1761    2015-119    862-33-5178 8098    273000  2   2015-08-22 09:51:55.362818  2015-04-22 23:03:46 2015-10-16 11:58:49 \N  458 830 10234   7989    7882    82  81
1762    2015-120    653-33-5871 17078   251000  2   2014-12-22 20:53:18.098337  2015-05-30 17:14:19 2015-03-20 09:12:41 Ut qui voluptatem. Quasi ab ullam. Porro qui dolorum id ducimus aperiam dolores libero. Voluptas voluptatem deleniti. Illo quibusdam et dolor.  466 846 10388   7961    7917    82  81
1683    2015-041    031-74-5695 34363   263000  1   2015-06-28 17:42:47.471046  2015-09-13 22:14:59 2015-11-09 21:43:23 Itaque est eveniet. Quis nemo quaerat nesciunt. Molestiae maiores aut voluptas. Esse quasi tenetur et porro consectetur voluptatum. Quia ipsam nisi et. 461 835 10239   7916    7922    81  82
1684    2015-042    861-83-2265 39738   277000  1   2015-07-22 16:29:48.246577  2018-10-17 18:43:05 2015-08-08 02:10:16 Nemo voluptatem aliquid cum porro et et. Quis quos quod velit aut vel excepturi. Iste blanditiis qui eum fuga non cupiditate eveniet. Et dolorem soluta.    473 861 10249   7855    7932    82  82
1685    2015-043    108-27-6172 27256   84000   1   2015-07-23 08:10:09.67103   2015-06-21 02:21:33 2015-11-12 04:14:11 Beatae voluptas et. Qui quibusdam alias pariatur ut laudantium ea culpa. Quia quos blanditiis distinctio.   465 843 10363   7983    7936    82  82
1686    2015-044    829-24-0297 31756   257000  0   2015-03-24 07:29:49.036499  2015-09-07 08:45:53 \N  Esse quos quis expedita exercitationem. Quis veritatis facere adipisci. Mollitia architecto voluptatum. 471 855 10349   7922    7907    82  82
1687    2015-045    060-83-5520 26024   33000   2   2015-01-21 22:10:58.576497  2015-11-08 11:13:02 2015-05-28 05:55:44 \N  468 850 10250   7865    7980    81  82
1688    2015-046    683-43-1642 18829   255000  1   2015-06-25 05:11:24.201476  2015-09-04 15:20:26 2015-10-15 07:21:32 \N  468 850 10238   7994    7960    82  81
1689    2015-047    368-85-9745 24312   112000  1   2015-02-20 14:43:50.007209  2015-06-27 03:05:41 2015-03-17 07:49:14 \N  471 854 10323   7963    7843    82  82
1690    2015-048    885-01-4114 39507   146000  1   2015-08-18 15:33:57.700509  2015-04-15 08:40:27 2015-10-20 17:03:35 Non incidunt a eum non voluptatem. Vero enim et molestias repellat rem quia. Expedita consectetur sed dignissimos sit optio. Sapiente consectetur qui libero dolore et provident eum.   458 832 10224   7948    7959    82  82
1691    2015-049    247-71-7879 13192   23000   1   2015-09-02 16:58:54.172567  2017-12-30 11:25:07 2015-11-25 23:00:47 Praesentium vel adipisci ipsam laboriosam eum. Saepe pariatur consequatur voluptas delectus molestiae. Velit aut voluptates omnis consequatur esse autem. Repellat eveniet accusantium officiis facere at.  463 \N  10285   7916    7934    81  82
1692    2015-050    849-87-6211 38070   281000  2   2015-03-20 14:35:27.881872  2015-06-20 12:50:33 2015-12-03 20:16:56 \N  459 \N  10443   7876    8008    81  82
1693    2015-051    558-29-6010 6337    36000   2   2015-05-21 17:37:48.356879  2015-08-03 18:03:50 2015-06-05 16:51:13 \N  460 834 10407   7969    7913    82  81
1694    2015-052    757-90-4514 17612   297000  2   2015-08-01 20:57:17.885445  2018-05-06 08:44:00 2015-09-20 19:25:03 \N  472 856 10363   7827    7946    81  81
1695    2015-053    124-67-4511 21371   309000  2   2015-06-20 09:21:16.105139  2018-05-07 21:07:36 2015-09-22 05:42:19 \N  469 \N  10300   8006    7996    81  82
1696    2015-054    664-09-0136 19675   151000  1   2015-06-26 08:55:57.483887  2015-06-16 11:44:02 2015-09-26 15:24:41 \N  466 845 10345   8002    7930    82  82
1697    2015-055    631-96-7253 31970   89000   2   2014-12-30 20:04:38.945141  2015-03-17 16:25:20 2015-07-06 14:49:32 Fuga voluptatem rerum quam eligendi quia. Illum ex voluptas debitis ipsa voluptatum aliquid. Et assumenda et alias enim voluptas velit nulla.   470 851 10259   7928    7894    81  82
1698    2015-056    626-24-6965 12661   226000  0   2015-08-12 10:16:07.876364  2015-04-02 12:40:07 \N  Quod incidunt mollitia aliquid qui velit nihil sint. Debitis accusamus libero nostrum quisquam. Aperiam doloremque cum commodi dolorem. 460 834 10291   7936    7844    81  81
1699    2015-057    053-94-5394 4613    179000  2   2015-04-15 09:42:24.696778  2015-06-14 21:11:51 2015-09-23 22:04:25 \N  470 851 10404   7848    7971    81  82
1700    2015-058    293-05-8218 38006   152000  2   2015-04-24 10:12:13.921347  2017-12-19 22:24:30 2015-10-28 12:47:53 \N  463 \N  10238   7958    7930    81  82
1701    2015-059    157-14-5334 17374   111000  2   2015-01-06 13:30:58.214726  2018-01-30 21:55:44 2015-09-07 07:34:00 \N  469 \N  10231   7912    7978    81  81
1702    2015-060    574-47-0065 6555    147000  0   2015-06-07 04:18:12.515361  2018-11-12 08:40:10 \N  Autem mollitia quisquam sed. Sed non id omnis culpa. Doloremque odio consequatur nihil aut magni eos.   469 \N  10264   7994    7960    82  81
\.


--
-- Name: projects_id_seq; Type: SEQUENCE SET; Schema: public; Owner: agufranov
--

SELECT pg_catalog.SETVAL('projects_id_seq', 1762, TRUE);


--
-- Data for Name: schema_migrations; Type: TABLE DATA; Schema: public; Owner: agufranov
--

COPY schema_migrations (version) FROM stdin;
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
\.


--
-- Data for Name: specialities; Type: TABLE DATA; Schema: public; Owner: agufranov
--

COPY specialities (id, title) FROM stdin;
81  Speciality 1
82  Speciality 2
\.


--
-- Name: specialities_id_seq; Type: SEQUENCE SET; Schema: public; Owner: agufranov
--

SELECT pg_catalog.SETVAL('specialities_id_seq', 82, TRUE);


--
-- Data for Name: vendor_countries; Type: TABLE DATA; Schema: public; Owner: agufranov
--

COPY vendor_countries (id, vendor_id, country_id) FROM stdin;
614 646 10298
615 646 10260
616 650 10228
617 652 10239
618 652 10389
619 653 10225
620 655 10282
621 655 10424
622 658 10244
623 662 10296
624 662 10373
625 663 10329
626 663 10364
627 664 10328
628 664 10248
629 665 10415
630 666 10255
631 666 10298
632 667 10316
633 667 10300
634 669 10379
635 670 10333
636 670 10227
637 671 10241
638 671 10294
639 673 10397
640 673 10400
641 674 10425
642 675 10287
643 677 10400
644 677 10220
645 678 10269
646 679 10414
647 679 10437
648 681 10318
649 682 10419
650 683 10241
651 683 10245
652 684 10284
653 684 10247
654 685 10407
655 687 10367
656 689 10439
657 690 10284
658 690 10213
659 693 10350
660 695 10208
661 696 10449
662 697 10351
663 697 10444
664 698 10435
665 700 10375
666 700 10330
667 702 10372
668 702 10258
669 703 10254
670 704 10404
671 706 10256
672 708 10348
673 709 10339
674 709 10268
675 710 10336
676 710 10286
677 711 10306
678 715 10362
679 715 10269
680 717 10254
681 717 10209
682 718 10340
683 718 10364
684 719 10401
685 719 10443
686 722 10411
687 725 10437
688 725 10318
\.


--
-- Name: vendor_countries_id_seq; Type: SEQUENCE SET; Schema: public; Owner: agufranov
--

SELECT pg_catalog.SETVAL('vendor_countries_id_seq', 688, TRUE);


--
-- Data for Name: vendor_languages; Type: TABLE DATA; Schema: public; Owner: agufranov
--

COPY vendor_languages (id, vendor_id, language_id, proficiency) FROM stdin;
795 646 7952    3
796 646 7991    3
797 647 7998    2
798 648 7983    2
799 648 7853    1
800 649 7894    3
801 650 7933    3
802 650 7860    2
803 651 7870    1
804 651 7853    0
805 652 7883    1
806 653 7976    2
807 653 8005    0
808 654 7985    1
809 654 7963    1
810 655 7900    0
811 655 7926    0
812 656 7883    3
813 656 7827    1
814 657 7948    1
815 657 7838    3
816 658 7960    3
817 659 7899    1
818 659 7872    3
819 660 7839    3
820 660 7928    1
821 661 7988    2
822 662 7876    0
823 663 7981    3
824 664 7879    3
825 664 7891    1
826 665 7931    2
827 666 7870    1
828 666 7951    1
829 667 7878    3
830 668 7989    0
831 668 7948    2
832 669 7986    3
833 670 7944    2
834 671 8000    1
835 671 7986    0
836 672 7978    2
837 673 8007    0
838 674 7988    1
839 675 7927    3
840 676 7961    0
841 676 7864    1
842 677 7982    2
843 678 7846    1
844 678 7990    0
845 679 7968    1
846 679 8005    2
847 680 7933    2
848 681 8003    2
849 682 7963    3
850 682 7882    1
851 683 7873    2
852 683 7921    3
853 684 7838    2
854 685 7914    2
855 686 7872    1
856 686 7981    1
857 687 7926    1
858 688 8007    0
859 688 7971    3
860 689 7862    3
861 689 7905    3
862 690 7841    2
863 690 7938    1
864 691 7897    2
865 692 7926    0
866 692 7992    1
867 693 7973    2
868 693 7940    2
869 694 7857    0
870 694 7983    3
871 695 8002    1
872 695 7908    0
873 696 7915    3
874 697 7989    1
875 698 7903    0
876 699 7865    1
877 700 7887    3
878 700 7888    1
879 701 7850    1
880 702 7966    3
881 703 7863    3
882 703 7904    0
883 704 7834    0
884 704 7920    3
885 705 7881    0
886 706 7904    0
887 706 7870    0
888 707 7929    1
889 708 7994    1
890 709 7957    3
891 709 8002    3
892 710 8000    3
893 711 7881    0
894 712 7859    3
895 713 7834    2
896 714 7874    3
897 714 7985    2
898 715 7950    2
899 715 7890    3
900 716 7988    0
901 717 7973    3
902 717 7837    0
903 718 7898    0
904 718 7999    0
905 719 7866    1
906 720 7948    2
907 721 7916    0
908 721 7871    0
909 722 7830    1
910 723 7899    2
911 723 7882    3
912 724 7948    3
913 724 7837    3
914 725 7863    3
\.


--
-- Name: vendor_languages_id_seq; Type: SEQUENCE SET; Schema: public; Owner: agufranov
--

SELECT pg_catalog.SETVAL('vendor_languages_id_seq', 914, TRUE);


--
-- Data for Name: vendors; Type: TABLE DATA; Schema: public; Owner: agufranov
--

COPY vendors (id, name, mapi_code, tasks_flags, rate_hour_cents, rate_interview_cents, rate_word_cents, comments, profession_id, condition_id, speciality_id) FROM stdin;
646 Dangelo Kerluke V   S6297300E   106 1700    1200    1700    Fixie pbr&b bushwick cardigan.  166 82  82
647 Brenda Robel DDS    S7072745E   37  1000    1700    2000    Pbr&b cronut paleo beard raw denim. 157 82  81
648 Kameron Maggio  S5884142J   138 2300    2400    1200    Viral readymade drinking yuccie intelligentsia goth vegan messenger bag health. 175 81  81
649 Mr. Emmett Herman   S5350099D   116 1400    1500    1700    Cliche craft beer mlkshk pitchfork bespoke sustainable loko.    165 82  82
650 Seth Reinger    S7482653I   31  2100    700 1600    Listicle beard literally bicycle rights chartreuse chia.    157 81  82
651 Maximilian Gulgowski    S9120705B   83  500 1200    2200    Put a bird ON it cold-pressed single-origin coffee schlitz shabby chic cardigan chillwave.  168 81  81
652 Otha Renner Jr. S6749550J   18  700 1900    1300    Banh mi vice brunch neutra selvage synth master +1. 180 82  82
653 Kyra Beahan II  S5657575H   107 600 1700    2400    Portland tacos bitters truffaut distillery viral listicle BEFORE they sold OUT pug. 163 81  82
654 Abigale Robel MD    S7500265C   237 1900    1400    2300    You probably haven't heard of them ramps waistcoat put a bird on it fingerstache next level shabby chic hoodie. 175 81  81
655 Trevion Krajcik S8034402C   39  900 1600    1200    Fingerstache hella plaid post-ironic raw denim migas pop-up.    169 81  81
656 Josefina Rice   S8633860B   187 600 1900    800 Asymmetrical vhs gastropub hoodie cornhole shabby chic hella.   168 81  82
657 Kayla Bogan S7410831H   241 500 1000    1500    Blue bottle vice iphone pitchfork.  167 81  82
658 Maximillian Ebert   S6210883E   7   2200    1500    2200    Tilde chartreuse chicharrones authentic green juice kickstarter.    178 81  82
659 Mr. Brenna Anderson S9772528D   249 2300    500 2400    Craft beer whatever asymmetrical narwhal yr tumblr keytar tattooed diy. 179 82  81
660 Alanna Jaskolski    S8694615G   40  800 2000    1200    Small batch pug ethical health. 158 81  82
661 Neal Larkin MD  S7083368I   161 1600    1100    2000    Salvia kogi typewriter venmo vinegar tumblr.    172 82  81
662 Raleigh Lockman S5626843Z   111 500 800 800 Tacos fixie park ugh asymmetrical mixtape lumbersexual. 167 82  82
663 Mozelle Graham  S6330001B   54  1000    1700    1500    Park readymade tilde ugh thundercats kitsch hammock austin. 162 82  81
664 Lazaro Welch    S9703019G   175 600 900 1300    Hella 3 wolf moon tilde cray gastropub hammock meh vinyl.   176 82  82
665 Ms. Marcelina Simonis   S9167781D   211 1200    1800    1400    Celiac intelligentsia wolf brooklyn 8-bit.  157 82  82
666 Samson Russel   S8255245F   228 500 800 1000    Slow-carb bicycle rights swag semiotics photo booth poutine truffaut.   175 82  81
667 Gregg Gusikowski    S5095426I   210 1200    900 2200    Meggings biodiesel salvia taxidermy.    181 82  81
668 Providenci Lang S7717878C   195 1300    2300    2400    Intelligentsia kale chips green juice ugh.  159 81  81
669 Sabina Jast S9252647Z   155 2300    1000    1100    Gastropub xoxo hashtag carry pork belly seitan blue bottle. 169 81  81
670 Gideon Boyer    S9707683I   49  500 2400    2300    Retro fixie chartreuse cardigan 90's organic celiac.    169 81  81
671 Amanda Bahringer Jr.    S8653223I   16  1800    1300    1600    Hammock cardigan jean shorts aesthetic pinterest kitsch bushwick cliche.    173 81  82
672 Tyreek Tillman Jr.  S5461945F   179 2200    2400    1300    Helvetica bushwick 8-bit goth.  182 82  82
673 Neil Stracke    S8948117A   50  2400    1600    1800    Schlitz echo migas actually sartorial banh mi pbr&b.    173 81  81
674 Hayley Christiansen S5800002G   28  1800    2300    1600    Art party thundercats locavore mustache jean shorts.    174 81  81
675 Polly Vandervort    S5307265H   218 500 1500    1200    Ugh pug semiotics viral everyday.   169 81  81
676 Nick Funk   S9122974I   195 1700    1300    2400    Celiac squid lomo synth xoxo.   171 81  82
677 Kirstin Labadie S6063107G   115 1100    1700    2300    Godard NEXT level plaid park tumblr carry.  161 82  82
678 Lelah Leannon   S6405292F   137 2200    2300    1800    Organic intelligentsia master kogi put a bird ON it tattooed small batch biodiesel vinegar. 176 81  81
679 Alexandria Price    S8796305E   212 700 2100    500 Flannel lumbersexual austin intelligentsia heirloom microdosing chia.   173 82  81
680 Heber Bernier   S5516050C   120 1300    1300    2400    Sustainable farm-to-TABLE portland street.  174 81  82
681 Mason Heller III    S5785146E   47  1300    2100    900 Polaroid post-ironic asymmetrical bushwick meggings messenger bag trust fund.   159 81  81
682 Eriberto McDermott II   S5359434D   199 600 2400    2300    Cliche waistcoat chicharrones kombucha cleanse butcher. 176 81  81
683 Meta Quitzon IV S7048573G   230 2200    2200    2000    Sustainable irony pickled thundercats plaid kinfolk.    172 82  81
684 Haskell Zieme   S6955233A   107 900 500 1400    Williamsburg bitters carry farm-to-TABLE twee hashtag typewriter thundercats.   170 81  81
685 Lawrence Bernhard MD    S8453543E   237 1500    1100    2000    Food truck synth portland tacos 3 wolf moon.    177 81  81
686 Justus Goodwin  S8008109Z   78  1000    1000    1900    Aesthetic tofu master celiac fanny pack.    164 81  81
687 Willard Wiza    S8564947G   185 1400    800 2100    Shabby chic tilde dreamcatcher narwhal waistcoat wes anderson normcore gluten-free austin.  180 82  82
688 Fannie Collins  S8690002E   230 1200    1200    600 Ethical mlkshk farm-to-TABLE pug intelligentsia.    176 82  81
689 Lyla Balistreri II  S8937616E   58  1900    1900    1200    Plaid xoxo ennui cliche pour-OVER paleo synth.  177 82  82
690 Eldora Witting  S8199332G   55  600 500 900 Pork belly umami direct trade readymade.    173 81  81
691 Laverna Conn    S8487853G   4   1100    1600    1100    Ugh normcore dreamcatcher artisan crucifix offal pickled umami mlkshk.  166 81  81
692 Marlin Gleichner DDS    S6316802E   224 600 600 2400    Organic schlitz ugh master forage gluten-free you probably haven't heard of them.   161 81  81
693 Trey Klein I    S7075790G   155 1800    2000    2200    Pinterest semiotics sartorial selfies small batch.  164 82  81
694 Kristy Kihn S9650551E   212 1600    1300    2100    Banh mi art party pinterest deep v venmo kinfolk artisan.   182 81  82
695 Emelia Miller   S6343666F   212 2300    1900    1300    Williamsburg portland neutra microdosing +1.    160 81  82
696 Lacy Koepp  S8355745A   28  2200    700 1100    Pinterest cronut next level bitters.    170 82  82
697 Vern Bradtke    S6666398A   52  700 2000    2200    Microdosing pickled vinegar kale chips knausgaard yr godard food truck. 159 81  81
698 Lennie Tillman I    S6647283C   197 1100    1600    2300    Xoxo intelligentsia goth letterpress disrupt pour-over cornhole dreamcatcher drinking.  168 82  82
699 Jaylin Stokes I S5892552G   43  1400    1600    500 Swag plaid vegan etsy.  166 82  82
700 Webster Daugherty   S9051950F   36  2300    1600    1300    Ramps put a bird on it irony ugh mixtape.   166 82  81
701 Aurelia Reinger S7650110F   236 600 1100    500 Cred offal cardigan cronut. 178 81  81
702 Una Schmitt S9609395J   62  1000    700 600 Cornhole drinking keffiyeh hoodie.  158 82  82
703 Jaiden Block    S8356230G   172 900 700 1600    Cray fanny pack 3 wolf moon deep v park aesthetic wes anderson. 168 82  81
704 Willa Huel  S7339972F   129 1200    1500    1200    Tilde banh mi swag fap authentic.   157 81  81
705 Alva Christiansen   S6991332F   238 1500    2100    1000    Roof hammock goth asymmetrical meditation chia plaid tattooed.  171 82  82
706 Nia Schimmel    S5477919D   234 600 2300    1300    Brunch master try-hard bitters portland mumblecore photo booth mixtape authentic.   178 81  82
707 Jessyca Langosh S6688397C   95  2200    1700    1400    Kogi sustainable thundercats street 3 wolf moon health crucifix farm-to-table.  175 81  82
708 Tessie Bashirian    S5475392F   36  700 1700    900 Mustache keytar franzen gentrify disrupt microdosing shabby chic tofu.  182 81  82
709 Saige Reynolds  S9682364I   127 700 2300    1000    Chicharrones tattooed swag squid roof tumblr street organic lo-fi.  174 81  82
710 Waino Rodriguez S5816476C   5   1700    1500    1600    Shabby chic tumblr migas marfa hella neutra forage trust fund.  165 82  82
711 Fredrick Bashirian  S7440587H   131 1300    2000    1200    Goth everyday disrupt pour-over food truck trust fund paleo meh swag.   165 82  81
712 Fredrick Huel   S7440229A   106 2200    1600    1900    Brooklyn loko synth authentic.  171 81  81
713 Jaylan Grant    S7664012B   147 1500    2400    1900    Quinoa cliche helvetica diy banjo cred letterpress fap carry.   159 82  82
714 Mara Rath   S5545245H   34  2400    1900    800 Disrupt offal actually heirloom jean shorts meggings intelligentsia sriracha.   177 82  82
715 Quinn Abernathy S5996116J   3   600 600 700 Blue bottle pour-over quinoa chillwave meh. 161 82  81
716 Miss Emmitt Upton   S7508806Z   28  1300    1300    500 Tousled gastropub small batch next level cleanse drinking bitters paleo.    174 82  82
717 Miss Tito Green S5336741J   3   1100    1000    900 Craft beer meh put a bird on it art party.  166 82  82
718 Dr. Sterling Mosciski   S6469566E   96  1300    1500    1700    Williamsburg cliche selvage pickled pop-up park pitchfork synth.    176 81  82
719 Candido Pollich S8144140E   216 1400    1800    1100    Ethical asymmetrical vinegar before they sold out.  178 81  82
720 Ms. Jordan Miller   S6424038B   156 500 700 2400    Goth mlkshk roof skateboard.    172 82  82
721 Belle Grimes    S8973019H   45  500 1300    1200    Viral narwhal echo church-key sartorial.    171 81  82
722 Shanel Heller   S7555172Z   248 1300    1100    700 Synth meh mlkshk hashtag skateboard fap tattooed kinfolk.   164 82  81
723 Vinnie Adams    S8595269B   248 2400    800 1400    Sustainable butcher hella slow-carb.    175 82  82
724 Jo Oberbrunner  S7813389I   218 1400    900 2200    Plaid skateboard artisan fap offal tilde.   173 82  81
725 Duncan Bradtke  S6684034D   254 2200    2000    1400    Mustache pickled cronut neutra readymade wayfarers narwhal venmo meditation.    170 81  81
\.


--
-- Name: vendors_id_seq; Type: SEQUENCE SET; Schema: public; Owner: agufranov
--

SELECT pg_catalog.setval('vendors_id_seq', 725, true);


--
-- Name: assignments_pkey; Type: CONSTRAINT; Schema: public; Owner: agufranov; Tablespace:
--

ALTER TABLE ONLY assignments
    ADD CONSTRAINT assignments_pkey PRIMARY KEY (id);


--
-- Name: clients_pkey; Type: CONSTRAINT; Schema: public; Owner: agufranov; Tablespace:
--

ALTER TABLE ONLY clients
    ADD CONSTRAINT clients_pkey PRIMARY KEY (id);


--
-- Name: conditions_pkey; Type: CONSTRAINT; Schema: public; Owner: agufranov; Tablespace:
--

ALTER TABLE ONLY conditions
    ADD CONSTRAINT conditions_pkey PRIMARY KEY (id);


--
-- Name: countries_pkey; Type: CONSTRAINT; Schema: public; Owner: agufranov; Tablespace:
--

ALTER TABLE ONLY countries
    ADD CONSTRAINT countries_pkey PRIMARY KEY (id);


--
-- Name: languages_pkey; Type: CONSTRAINT; Schema: public; Owner: agufranov; Tablespace:
--

ALTER TABLE ONLY languages
    ADD CONSTRAINT languages_pkey PRIMARY KEY (id);


--
-- Name: professions_pkey; Type: CONSTRAINT; Schema: public; Owner: agufranov; Tablespace:
--

ALTER TABLE ONLY professions
    ADD CONSTRAINT professions_pkey PRIMARY KEY (id);


--
-- Name: project_managers_pkey; Type: CONSTRAINT; Schema: public; Owner: agufranov; Tablespace:
--

ALTER TABLE ONLY project_managers
    ADD CONSTRAINT project_managers_pkey PRIMARY KEY (id);


--
-- Name: projects_pkey; Type: CONSTRAINT; Schema: public; Owner: agufranov; Tablespace:
--

ALTER TABLE ONLY projects
    ADD CONSTRAINT projects_pkey PRIMARY KEY (id);


--
-- Name: specialities_pkey; Type: CONSTRAINT; Schema: public; Owner: agufranov; Tablespace:
--

ALTER TABLE ONLY specialities
    ADD CONSTRAINT specialities_pkey PRIMARY KEY (id);


--
-- Name: vendor_countries_pkey; Type: CONSTRAINT; Schema: public; Owner: agufranov; Tablespace:
--

ALTER TABLE ONLY vendor_countries
    ADD CONSTRAINT vendor_countries_pkey PRIMARY KEY (id);


--
-- Name: vendor_languages_pkey; Type: CONSTRAINT; Schema: public; Owner: agufranov; Tablespace:
--

ALTER TABLE ONLY vendor_languages
    ADD CONSTRAINT vendor_languages_pkey PRIMARY KEY (id);


--
-- Name: vendors_pkey; Type: CONSTRAINT; Schema: public; Owner: agufranov; Tablespace:
--

ALTER TABLE ONLY vendors
    ADD CONSTRAINT vendors_pkey PRIMARY KEY (id);


--
-- Name: index_assignments_on_vendor_id_and_project_id; Type: INDEX; Schema: public; Owner: agufranov; Tablespace:
--

CREATE UNIQUE INDEX index_assignments_on_vendor_id_and_project_id ON assignments USING btree (vendor_id, project_id);


--
-- Name: index_conditions_on_name; Type: INDEX; Schema: public; Owner: agufranov; Tablespace:
--

CREATE UNIQUE INDEX index_conditions_on_name ON conditions USING btree (name);


--
-- Name: index_countries_on_name; Type: INDEX; Schema: public; Owner: agufranov; Tablespace:
--

CREATE UNIQUE INDEX index_countries_on_name ON countries USING btree (name);


--
-- Name: index_languages_on_name; Type: INDEX; Schema: public; Owner: agufranov; Tablespace:
--

CREATE UNIQUE INDEX index_languages_on_name ON languages USING btree (name);


--
-- Name: index_professions_on_title; Type: INDEX; Schema: public; Owner: agufranov; Tablespace:
--

CREATE UNIQUE INDEX index_professions_on_title ON professions USING btree (title);


--
-- Name: index_projects_on_number; Type: INDEX; Schema: public; Owner: agufranov; Tablespace:
--

CREATE UNIQUE INDEX index_projects_on_number ON projects USING btree (number);


--
-- Name: index_specialities_on_title; Type: INDEX; Schema: public; Owner: agufranov; Tablespace:
--

CREATE UNIQUE INDEX index_specialities_on_title ON specialities USING btree (title);


--
-- Name: index_vendor_countries_on_vendor_id_and_country_id; Type: INDEX; Schema: public; Owner: agufranov; Tablespace:
--

CREATE UNIQUE INDEX index_vendor_countries_on_vendor_id_and_country_id ON vendor_countries USING btree (vendor_id, country_id);


--
-- Name: index_vendor_languages_on_vendor_id_and_language_id; Type: INDEX; Schema: public; Owner: agufranov; Tablespace:
--

CREATE UNIQUE INDEX index_vendor_languages_on_vendor_id_and_language_id ON vendor_languages USING btree (vendor_id, language_id);


--
-- Name: unique_schema_migrations; Type: INDEX; Schema: public; Owner: agufranov; Tablespace:
--

CREATE UNIQUE INDEX unique_schema_migrations ON schema_migrations USING btree (version);


--
-- Name: fk_rails_102d49228a; Type: FK CONSTRAINT; Schema: public; Owner: agufranov
--

ALTER TABLE ONLY vendor_languages
    ADD CONSTRAINT fk_rails_102d49228a FOREIGN KEY (vendor_id) REFERENCES vendors(id);


--
-- Name: fk_rails_156fe9f60c; Type: FK CONSTRAINT; Schema: public; Owner: agufranov
--

ALTER TABLE ONLY projects
    ADD CONSTRAINT fk_rails_156fe9f60c FOREIGN KEY (speciality_id) REFERENCES specialities(id);


--
-- Name: fk_rails_24a132526a; Type: FK CONSTRAINT; Schema: public; Owner: agufranov
--

ALTER TABLE ONLY projects
    ADD CONSTRAINT fk_rails_24a132526a FOREIGN KEY (country_id) REFERENCES countries(id);


--
-- Name: fk_rails_3549273dc2; Type: FK CONSTRAINT; Schema: public; Owner: agufranov
--

ALTER TABLE ONLY projects
    ADD CONSTRAINT fk_rails_3549273dc2 FOREIGN KEY (project_manager_id) REFERENCES project_managers(id);


--
-- Name: fk_rails_4d3d2c839c; Type: FK CONSTRAINT; Schema: public; Owner: agufranov
--

ALTER TABLE ONLY assignments
    ADD CONSTRAINT fk_rails_4d3d2c839c FOREIGN KEY (project_id) REFERENCES projects(id);


--
-- Name: fk_rails_6a4bb456c6; Type: FK CONSTRAINT; Schema: public; Owner: agufranov
--

ALTER TABLE ONLY projects
    ADD CONSTRAINT fk_rails_6a4bb456c6 FOREIGN KEY (condition_id) REFERENCES conditions(id);


--
-- Name: fk_rails_74246e9b3a; Type: FK CONSTRAINT; Schema: public; Owner: agufranov
--

ALTER TABLE ONLY vendors
    ADD CONSTRAINT fk_rails_74246e9b3a FOREIGN KEY (profession_id) REFERENCES professions(id);


--
-- Name: fk_rails_8d9657cec3; Type: FK CONSTRAINT; Schema: public; Owner: agufranov
--

ALTER TABLE ONLY projects
    ADD CONSTRAINT fk_rails_8d9657cec3 FOREIGN KEY (client_id) REFERENCES clients(id);


--
-- Name: fk_rails_a0697f438d; Type: FK CONSTRAINT; Schema: public; Owner: agufranov
--

ALTER TABLE ONLY vendors
    ADD CONSTRAINT fk_rails_a0697f438d FOREIGN KEY (speciality_id) REFERENCES specialities(id);


--
-- Name: fk_rails_b48dd4d0f7; Type: FK CONSTRAINT; Schema: public; Owner: agufranov
--

ALTER TABLE ONLY clients
    ADD CONSTRAINT fk_rails_b48dd4d0f7 FOREIGN KEY (country_id) REFERENCES countries(id);


--
-- Name: fk_rails_ba30d1a3e1; Type: FK CONSTRAINT; Schema: public; Owner: agufranov
--

ALTER TABLE ONLY project_managers
    ADD CONSTRAINT fk_rails_ba30d1a3e1 FOREIGN KEY (client_id) REFERENCES clients(id);


--
-- Name: fk_rails_bc6c1c3a37; Type: FK CONSTRAINT; Schema: public; Owner: agufranov
--

ALTER TABLE ONLY vendors
    ADD CONSTRAINT fk_rails_bc6c1c3a37 FOREIGN KEY (condition_id) REFERENCES conditions(id);


--
-- Name: fk_rails_c3863b55f1; Type: FK CONSTRAINT; Schema: public; Owner: agufranov
--

ALTER TABLE ONLY vendor_countries
    ADD CONSTRAINT fk_rails_c3863b55f1 FOREIGN KEY (country_id) REFERENCES countries(id);


--
-- Name: fk_rails_cfaed64ff3; Type: FK CONSTRAINT; Schema: public; Owner: agufranov
--

ALTER TABLE ONLY vendor_countries
    ADD CONSTRAINT fk_rails_cfaed64ff3 FOREIGN KEY (vendor_id) REFERENCES vendors(id);


--
-- Name: fk_rails_ecf30ce61e; Type: FK CONSTRAINT; Schema: public; Owner: agufranov
--

ALTER TABLE ONLY vendor_languages
    ADD CONSTRAINT fk_rails_ecf30ce61e FOREIGN KEY (language_id) REFERENCES languages(id);


--
-- Name: fk_rails_ef42a526ae; Type: FK CONSTRAINT; Schema: public; Owner: agufranov
--

ALTER TABLE ONLY projects
    ADD CONSTRAINT fk_rails_ef42a526ae FOREIGN KEY (original_language_id) REFERENCES languages(id);


--
-- Name: fk_rails_f351cdedca; Type: FK CONSTRAINT; Schema: public; Owner: agufranov
--

ALTER TABLE ONLY projects
    ADD CONSTRAINT fk_rails_f351cdedca FOREIGN KEY (target_language_id) REFERENCES languages(id);


--
-- Name: fk_rails_f6f2a82126; Type: FK CONSTRAINT; Schema: public; Owner: agufranov
--

ALTER TABLE ONLY assignments
    ADD CONSTRAINT fk_rails_f6f2a82126 FOREIGN KEY (vendor_id) REFERENCES vendors(id);


--
-- Name: public; Type: ACL; Schema: -; Owner: postgres
--

REVOKE ALL ON SCHEMA public FROM PUBLIC;
REVOKE ALL ON SCHEMA public FROM postgres;
GRANT ALL ON SCHEMA public TO postgres;
GRANT ALL ON SCHEMA public TO PUBLIC;


--
-- PostgreSQL database dump complete
--