CeeN8M31

1--
2-- PostgreSQL database dump
3--
4
5-- Dumped from database version 9.6.6
6-- Dumped by pg_dump version 9.6.6
7
8SET statement_timeout = 0;
9SET lock_timeout = 0;
10SET idle_in_transaction_session_timeout = 0;
11SET client_encoding = 'UTF8';
12SET standard_conforming_strings = on;
13SET check_function_bodies = false;
14SET client_min_messages = warning;
15SET row_security = off;
16
17--
18-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: 
19--
20
21CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;
22
23
24--
25-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner: 
26--
27
28COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';
29
30
31SET search_path = public, pg_catalog;
32
33SET default_tablespace = '';
34
35SET default_with_oids = false;
36
37--
38-- Name: address; Type: TABLE; Schema: public; Owner: hospital
39--
40
41CREATE TABLE address (
42    address_id integer NOT NULL,
43    district_id integer NOT NULL,
44    country_id integer NOT NULL,
45    state_id integer NOT NULL,
46    city_id integer NOT NULL,
47    latlong character varying(225) DEFAULT 0,
48    doorno character varying(225),
49    landmark character varying(225),
50    pincode integer,
51    fax character varying(225),
52    contactperson character varying(225)
53);
54
55
56ALTER TABLE address OWNER TO hospital;
57
58--
59-- Name: address_address_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
60--
61
62CREATE SEQUENCE address_address_id_seq
63    START WITH 1
64    INCREMENT BY 1
65    NO MINVALUE
66    NO MAXVALUE
67    CACHE 1;
68
69
70ALTER TABLE address_address_id_seq OWNER TO hospital;
71
72--
73-- Name: address_address_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
74--
75
76ALTER SEQUENCE address_address_id_seq OWNED BY address.address_id;
77
78
79--
80-- Name: agegroup; Type: TABLE; Schema: public; Owner: hospital
81--
82
83CREATE TABLE agegroup (
84    agegroup_id integer NOT NULL,
85    agegroup character varying(225),
86    sort_by integer,
87    status_2 integer DEFAULT 1
88);
89
90
91ALTER TABLE agegroup OWNER TO hospital;
92
93--
94-- Name: agegroup_agegroup_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
95--
96
97CREATE SEQUENCE agegroup_agegroup_id_seq
98    START WITH 1
99    INCREMENT BY 1
100    NO MINVALUE
101    NO MAXVALUE
102    CACHE 1;
103
104
105ALTER TABLE agegroup_agegroup_id_seq OWNER TO hospital;
106
107--
108-- Name: agegroup_agegroup_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
109--
110
111ALTER SEQUENCE agegroup_agegroup_id_seq OWNED BY agegroup.agegroup_id;
112
113
114--
115-- Name: alertsources; Type: TABLE; Schema: public; Owner: hospital
116--
117
118CREATE TABLE alertsources (
119    alertsources_id integer NOT NULL,
120    alertsource character varying(225),
121    sort_by integer,
122    status_2 integer DEFAULT 1
123);
124
125
126ALTER TABLE alertsources OWNER TO hospital;
127
128--
129-- Name: alertsources_alertsources_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
130--
131
132CREATE SEQUENCE alertsources_alertsources_id_seq
133    START WITH 1
134    INCREMENT BY 1
135    NO MINVALUE
136    NO MAXVALUE
137    CACHE 1;
138
139
140ALTER TABLE alertsources_alertsources_id_seq OWNER TO hospital;
141
142--
143-- Name: alertsources_alertsources_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
144--
145
146ALTER SEQUENCE alertsources_alertsources_id_seq OWNED BY alertsources.alertsources_id;
147
148
149--
150-- Name: alerttype; Type: TABLE; Schema: public; Owner: hospital
151--
152
153CREATE TABLE alerttype (
154    alerttype_id integer NOT NULL,
155    alerttype character varying(225),
156    sort_by integer,
157    status_2 integer DEFAULT 1
158);
159
160
161ALTER TABLE alerttype OWNER TO hospital;
162
163--
164-- Name: alerttype_alerttype_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
165--
166
167CREATE SEQUENCE alerttype_alerttype_id_seq
168    START WITH 1
169    INCREMENT BY 1
170    NO MINVALUE
171    NO MAXVALUE
172    CACHE 1;
173
174
175ALTER TABLE alerttype_alerttype_id_seq OWNER TO hospital;
176
177--
178-- Name: alerttype_alerttype_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
179--
180
181ALTER SEQUENCE alerttype_alerttype_id_seq OWNED BY alerttype.alerttype_id;
182
183
184--
185-- Name: appointmentbooking; Type: TABLE; Schema: public; Owner: hospital
186--
187
188CREATE TABLE appointmentbooking (
189    appointmentbooking_id integer NOT NULL,
190    date date NOT NULL,
191    priyority_id integer NOT NULL,
192    speciality_id integer NOT NULL,
193    healthseeker_id integer NOT NULL,
194    clinicians_id integer NOT NULL,
195    bookingsources_id integer NOT NULL,
196    "time" time without time zone,
197    reg_date timestamp without time zone,
198    ipaddress character varying(225),
199    macaddress character varying(225),
200    isnew integer,
201    visittype integer
202);
203
204
205ALTER TABLE appointmentbooking OWNER TO hospital;
206
207--
208-- Name: appointmentbooking_appointmentbooking_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
209--
210
211CREATE SEQUENCE appointmentbooking_appointmentbooking_id_seq
212    START WITH 1
213    INCREMENT BY 1
214    NO MINVALUE
215    NO MAXVALUE
216    CACHE 1;
217
218
219ALTER TABLE appointmentbooking_appointmentbooking_id_seq OWNER TO hospital;
220
221--
222-- Name: appointmentbooking_appointmentbooking_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
223--
224
225ALTER SEQUENCE appointmentbooking_appointmentbooking_id_seq OWNED BY appointmentbooking.appointmentbooking_id;
226
227
228--
229-- Name: auth_group; Type: TABLE; Schema: public; Owner: hospital
230--
231
232CREATE TABLE auth_group (
233    id integer NOT NULL,
234    name character varying(80) NOT NULL
235);
236
237
238ALTER TABLE auth_group OWNER TO hospital;
239
240--
241-- Name: auth_group_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
242--
243
244CREATE SEQUENCE auth_group_id_seq
245    START WITH 1
246    INCREMENT BY 1
247    NO MINVALUE
248    NO MAXVALUE
249    CACHE 1;
250
251
252ALTER TABLE auth_group_id_seq OWNER TO hospital;
253
254--
255-- Name: auth_group_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
256--
257
258ALTER SEQUENCE auth_group_id_seq OWNED BY auth_group.id;
259
260
261--
262-- Name: auth_group_permissions; Type: TABLE; Schema: public; Owner: hospital
263--
264
265CREATE TABLE auth_group_permissions (
266    id integer NOT NULL,
267    group_id integer NOT NULL,
268    permission_id integer NOT NULL
269);
270
271
272ALTER TABLE auth_group_permissions OWNER TO hospital;
273
274--
275-- Name: auth_group_permissions_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
276--
277
278CREATE SEQUENCE auth_group_permissions_id_seq
279    START WITH 1
280    INCREMENT BY 1
281    NO MINVALUE
282    NO MAXVALUE
283    CACHE 1;
284
285
286ALTER TABLE auth_group_permissions_id_seq OWNER TO hospital;
287
288--
289-- Name: auth_group_permissions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
290--
291
292ALTER SEQUENCE auth_group_permissions_id_seq OWNED BY auth_group_permissions.id;
293
294
295--
296-- Name: auth_permission; Type: TABLE; Schema: public; Owner: hospital
297--
298
299CREATE TABLE auth_permission (
300    id integer NOT NULL,
301    name character varying(255) NOT NULL,
302    content_type_id integer NOT NULL,
303    codename character varying(100) NOT NULL
304);
305
306
307ALTER TABLE auth_permission OWNER TO hospital;
308
309--
310-- Name: auth_permission_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
311--
312
313CREATE SEQUENCE auth_permission_id_seq
314    START WITH 1
315    INCREMENT BY 1
316    NO MINVALUE
317    NO MAXVALUE
318    CACHE 1;
319
320
321ALTER TABLE auth_permission_id_seq OWNER TO hospital;
322
323--
324-- Name: auth_permission_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
325--
326
327ALTER SEQUENCE auth_permission_id_seq OWNED BY auth_permission.id;
328
329
330--
331-- Name: auth_user; Type: TABLE; Schema: public; Owner: hospital
332--
333
334CREATE TABLE auth_user (
335    id integer NOT NULL,
336    password character varying(128) NOT NULL,
337    last_login timestamp with time zone,
338    is_superuser boolean NOT NULL,
339    username character varying(150) NOT NULL,
340    first_name character varying(30) NOT NULL,
341    last_name character varying(150) NOT NULL,
342    email character varying(254) NOT NULL,
343    is_staff boolean NOT NULL,
344    is_active boolean NOT NULL,
345    date_joined timestamp with time zone NOT NULL
346);
347
348
349ALTER TABLE auth_user OWNER TO hospital;
350
351--
352-- Name: auth_user_groups; Type: TABLE; Schema: public; Owner: hospital
353--
354
355CREATE TABLE auth_user_groups (
356    id integer NOT NULL,
357    user_id integer NOT NULL,
358    group_id integer NOT NULL
359);
360
361
362ALTER TABLE auth_user_groups OWNER TO hospital;
363
364--
365-- Name: auth_user_groups_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
366--
367
368CREATE SEQUENCE auth_user_groups_id_seq
369    START WITH 1
370    INCREMENT BY 1
371    NO MINVALUE
372    NO MAXVALUE
373    CACHE 1;
374
375
376ALTER TABLE auth_user_groups_id_seq OWNER TO hospital;
377
378--
379-- Name: auth_user_groups_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
380--
381
382ALTER SEQUENCE auth_user_groups_id_seq OWNED BY auth_user_groups.id;
383
384
385--
386-- Name: auth_user_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
387--
388
389CREATE SEQUENCE auth_user_id_seq
390    START WITH 1
391    INCREMENT BY 1
392    NO MINVALUE
393    NO MAXVALUE
394    CACHE 1;
395
396
397ALTER TABLE auth_user_id_seq OWNER TO hospital;
398
399--
400-- Name: auth_user_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
401--
402
403ALTER SEQUENCE auth_user_id_seq OWNED BY auth_user.id;
404
405
406--
407-- Name: auth_user_user_permissions; Type: TABLE; Schema: public; Owner: hospital
408--
409
410CREATE TABLE auth_user_user_permissions (
411    id integer NOT NULL,
412    user_id integer NOT NULL,
413    permission_id integer NOT NULL
414);
415
416
417ALTER TABLE auth_user_user_permissions OWNER TO hospital;
418
419--
420-- Name: auth_user_user_permissions_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
421--
422
423CREATE SEQUENCE auth_user_user_permissions_id_seq
424    START WITH 1
425    INCREMENT BY 1
426    NO MINVALUE
427    NO MAXVALUE
428    CACHE 1;
429
430
431ALTER TABLE auth_user_user_permissions_id_seq OWNER TO hospital;
432
433--
434-- Name: auth_user_user_permissions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
435--
436
437ALTER SEQUENCE auth_user_user_permissions_id_seq OWNED BY auth_user_user_permissions.id;
438
439
440--
441-- Name: availablefacilities; Type: TABLE; Schema: public; Owner: hospital
442--
443
444CREATE TABLE availablefacilities (
445    availablefacilities_id integer NOT NULL,
446    facilities_services_id integer NOT NULL,
447    healthproviders_id integer NOT NULL,
448    facilities_id integer NOT NULL,
449    sort_by integer,
450    status_2 integer DEFAULT 1
451);
452
453
454ALTER TABLE availablefacilities OWNER TO hospital;
455
456--
457-- Name: availablefacilities_availablefacilities_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
458--
459
460CREATE SEQUENCE availablefacilities_availablefacilities_id_seq
461    START WITH 1
462    INCREMENT BY 1
463    NO MINVALUE
464    NO MAXVALUE
465    CACHE 1;
466
467
468ALTER TABLE availablefacilities_availablefacilities_id_seq OWNER TO hospital;
469
470--
471-- Name: availablefacilities_availablefacilities_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
472--
473
474ALTER SEQUENCE availablefacilities_availablefacilities_id_seq OWNED BY availablefacilities.availablefacilities_id;
475
476
477--
478-- Name: bookingsources; Type: TABLE; Schema: public; Owner: hospital
479--
480
481CREATE TABLE bookingsources (
482    bookingsources_id integer NOT NULL,
483    sourcename character varying(225),
484    sort_by integer,
485    status_2 integer DEFAULT 1
486);
487
488
489ALTER TABLE bookingsources OWNER TO hospital;
490
491--
492-- Name: bookingsources_bookingsources_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
493--
494
495CREATE SEQUENCE bookingsources_bookingsources_id_seq
496    START WITH 1
497    INCREMENT BY 1
498    NO MINVALUE
499    NO MAXVALUE
500    CACHE 1;
501
502
503ALTER TABLE bookingsources_bookingsources_id_seq OWNER TO hospital;
504
505--
506-- Name: bookingsources_bookingsources_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
507--
508
509ALTER SEQUENCE bookingsources_bookingsources_id_seq OWNED BY bookingsources.bookingsources_id;
510
511
512--
513-- Name: businessregtype; Type: TABLE; Schema: public; Owner: hospital
514--
515
516CREATE TABLE businessregtype (
517    businessregtype_id integer NOT NULL,
518    businessregtype character varying(225),
519    sort_by integer,
520    status_2 integer DEFAULT 1
521);
522
523
524ALTER TABLE businessregtype OWNER TO hospital;
525
526--
527-- Name: businessregtype_businessregtype_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
528--
529
530CREATE SEQUENCE businessregtype_businessregtype_id_seq
531    START WITH 1
532    INCREMENT BY 1
533    NO MINVALUE
534    NO MAXVALUE
535    CACHE 1;
536
537
538ALTER TABLE businessregtype_businessregtype_id_seq OWNER TO hospital;
539
540--
541-- Name: businessregtype_businessregtype_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
542--
543
544ALTER SEQUENCE businessregtype_businessregtype_id_seq OWNED BY businessregtype.businessregtype_id;
545
546
547--
548-- Name: city; Type: TABLE; Schema: public; Owner: hospital
549--
550
551CREATE TABLE city (
552    city_id integer NOT NULL,
553    city character varying(225) NOT NULL,
554    sort_by integer,
555    status_2 integer DEFAULT 1
556);
557
558
559ALTER TABLE city OWNER TO hospital;
560
561--
562-- Name: city_city_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
563--
564
565CREATE SEQUENCE city_city_id_seq
566    START WITH 1
567    INCREMENT BY 1
568    NO MINVALUE
569    NO MAXVALUE
570    CACHE 1;
571
572
573ALTER TABLE city_city_id_seq OWNER TO hospital;
574
575--
576-- Name: city_city_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
577--
578
579ALTER SEQUENCE city_city_id_seq OWNED BY city.city_id;
580
581
582--
583-- Name: clinician_memberships; Type: TABLE; Schema: public; Owner: hospital
584--
585
586CREATE TABLE clinician_memberships (
587    clinician_memberships_id integer NOT NULL,
588    city_id integer NOT NULL,
589    country_id integer NOT NULL,
590    association character varying(225),
591    reg_date timestamp without time zone
592);
593
594
595ALTER TABLE clinician_memberships OWNER TO hospital;
596
597--
598-- Name: clinician_memberships_clinician_memberships_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
599--
600
601CREATE SEQUENCE clinician_memberships_clinician_memberships_id_seq
602    START WITH 1
603    INCREMENT BY 1
604    NO MINVALUE
605    NO MAXVALUE
606    CACHE 1;
607
608
609ALTER TABLE clinician_memberships_clinician_memberships_id_seq OWNER TO hospital;
610
611--
612-- Name: clinician_memberships_clinician_memberships_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
613--
614
615ALTER SEQUENCE clinician_memberships_clinician_memberships_id_seq OWNED BY clinician_memberships.clinician_memberships_id;
616
617
618--
619-- Name: clinicians; Type: TABLE; Schema: public; Owner: hospital
620--
621
622CREATE TABLE clinicians (
623    clinicians_id integer NOT NULL,
624    languages_id integer NOT NULL,
625    gender_id integer NOT NULL,
626    users_id integer NOT NULL,
627    dob date,
628    image character varying(225)
629);
630
631
632ALTER TABLE clinicians OWNER TO hospital;
633
634--
635-- Name: clinicians_clinicians_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
636--
637
638CREATE SEQUENCE clinicians_clinicians_id_seq
639    START WITH 1
640    INCREMENT BY 1
641    NO MINVALUE
642    NO MAXVALUE
643    CACHE 1;
644
645
646ALTER TABLE clinicians_clinicians_id_seq OWNER TO hospital;
647
648--
649-- Name: clinicians_clinicians_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
650--
651
652ALTER SEQUENCE clinicians_clinicians_id_seq OWNED BY clinicians.clinicians_id;
653
654
655--
656-- Name: clinicians_dates; Type: TABLE; Schema: public; Owner: hospital
657--
658
659CREATE TABLE clinicians_dates (
660    clinicians_dates_id integer NOT NULL,
661    clinicians_id integer NOT NULL,
662    timeslots_id integer NOT NULL,
663    week_id integer NOT NULL,
664    alldays integer
665);
666
667
668ALTER TABLE clinicians_dates OWNER TO hospital;
669
670--
671-- Name: clinicians_dates_clinicians_dates_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
672--
673
674CREATE SEQUENCE clinicians_dates_clinicians_dates_id_seq
675    START WITH 1
676    INCREMENT BY 1
677    NO MINVALUE
678    NO MAXVALUE
679    CACHE 1;
680
681
682ALTER TABLE clinicians_dates_clinicians_dates_id_seq OWNER TO hospital;
683
684--
685-- Name: clinicians_dates_clinicians_dates_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
686--
687
688ALTER SEQUENCE clinicians_dates_clinicians_dates_id_seq OWNED BY clinicians_dates.clinicians_dates_id;
689
690
691--
692-- Name: clinicians_education; Type: TABLE; Schema: public; Owner: hospital
693--
694
695CREATE TABLE clinicians_education (
696    clinicians_education_id integer NOT NULL,
697    qualification_id integer NOT NULL,
698    clinicians_id integer NOT NULL,
699    registrationno character varying(225),
700    college character varying(225)
701);
702
703
704ALTER TABLE clinicians_education OWNER TO hospital;
705
706--
707-- Name: clinicians_education_clinicians_education_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
708--
709
710CREATE SEQUENCE clinicians_education_clinicians_education_id_seq
711    START WITH 1
712    INCREMENT BY 1
713    NO MINVALUE
714    NO MAXVALUE
715    CACHE 1;
716
717
718ALTER TABLE clinicians_education_clinicians_education_id_seq OWNER TO hospital;
719
720--
721-- Name: clinicians_education_clinicians_education_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
722--
723
724ALTER SEQUENCE clinicians_education_clinicians_education_id_seq OWNED BY clinicians_education.clinicians_education_id;
725
726
727--
728-- Name: clinicians_experience; Type: TABLE; Schema: public; Owner: hospital
729--
730
731CREATE TABLE clinicians_experience (
732    clinicians_experience_id integer NOT NULL,
733    designation_id integer NOT NULL,
734    clinicians_id integer NOT NULL,
735    institution character varying(225),
736    workfrom date,
737    workto date,
738    reg_date timestamp without time zone
739);
740
741
742ALTER TABLE clinicians_experience OWNER TO hospital;
743
744--
745-- Name: clinicians_experience_clinicians_experience_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
746--
747
748CREATE SEQUENCE clinicians_experience_clinicians_experience_id_seq
749    START WITH 1
750    INCREMENT BY 1
751    NO MINVALUE
752    NO MAXVALUE
753    CACHE 1;
754
755
756ALTER TABLE clinicians_experience_clinicians_experience_id_seq OWNER TO hospital;
757
758--
759-- Name: clinicians_experience_clinicians_experience_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
760--
761
762ALTER SEQUENCE clinicians_experience_clinicians_experience_id_seq OWNED BY clinicians_experience.clinicians_experience_id;
763
764
765--
766-- Name: clinicians_speciality; Type: TABLE; Schema: public; Owner: hospital
767--
768
769CREATE TABLE clinicians_speciality (
770    clinicians_speciality_id integer NOT NULL,
771    symptoms_id integer NOT NULL,
772    healthproviders_speciality_id integer NOT NULL,
773    clinicians_id integer NOT NULL,
774    activefrom timestamp without time zone,
775    activeto timestamp without time zone,
776    reg_date timestamp without time zone
777);
778
779
780ALTER TABLE clinicians_speciality OWNER TO hospital;
781
782--
783-- Name: clinicians_speciality_clinicians_speciality_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
784--
785
786CREATE SEQUENCE clinicians_speciality_clinicians_speciality_id_seq
787    START WITH 1
788    INCREMENT BY 1
789    NO MINVALUE
790    NO MAXVALUE
791    CACHE 1;
792
793
794ALTER TABLE clinicians_speciality_clinicians_speciality_id_seq OWNER TO hospital;
795
796--
797-- Name: clinicians_speciality_clinicians_speciality_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
798--
799
800ALTER SEQUENCE clinicians_speciality_clinicians_speciality_id_seq OWNED BY clinicians_speciality.clinicians_speciality_id;
801
802
803--
804-- Name: conditions; Type: TABLE; Schema: public; Owner: hospital
805--
806
807CREATE TABLE conditions (
808    conditions_id integer NOT NULL,
809    conditionname character varying(225),
810    sort_by integer,
811    status_2 integer DEFAULT 1
812);
813
814
815ALTER TABLE conditions OWNER TO hospital;
816
817--
818-- Name: conditions_conditions_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
819--
820
821CREATE SEQUENCE conditions_conditions_id_seq
822    START WITH 1
823    INCREMENT BY 1
824    NO MINVALUE
825    NO MAXVALUE
826    CACHE 1;
827
828
829ALTER TABLE conditions_conditions_id_seq OWNER TO hospital;
830
831--
832-- Name: conditions_conditions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
833--
834
835ALTER SEQUENCE conditions_conditions_id_seq OWNED BY conditions.conditions_id;
836
837
838--
839-- Name: country; Type: TABLE; Schema: public; Owner: hospital
840--
841
842CREATE TABLE country (
843    country_id integer NOT NULL,
844    country character varying(225),
845    sort_by integer,
846    status_2 integer DEFAULT 1
847);
848
849
850ALTER TABLE country OWNER TO hospital;
851
852--
853-- Name: country_country_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
854--
855
856CREATE SEQUENCE country_country_id_seq
857    START WITH 1
858    INCREMENT BY 1
859    NO MINVALUE
860    NO MAXVALUE
861    CACHE 1;
862
863
864ALTER TABLE country_country_id_seq OWNER TO hospital;
865
866--
867-- Name: country_country_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
868--
869
870ALTER SEQUENCE country_country_id_seq OWNED BY country.country_id;
871
872
873--
874-- Name: couponaccept; Type: TABLE; Schema: public; Owner: hospital
875--
876
877CREATE TABLE couponaccept (
878    couponaccept_id integer NOT NULL,
879    couponaccept character varying(225),
880    sort_by integer,
881    status_2 integer DEFAULT 1
882);
883
884
885ALTER TABLE couponaccept OWNER TO hospital;
886
887--
888-- Name: couponaccept_couponaccept_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
889--
890
891CREATE SEQUENCE couponaccept_couponaccept_id_seq
892    START WITH 1
893    INCREMENT BY 1
894    NO MINVALUE
895    NO MAXVALUE
896    CACHE 1;
897
898
899ALTER TABLE couponaccept_couponaccept_id_seq OWNER TO hospital;
900
901--
902-- Name: couponaccept_couponaccept_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
903--
904
905ALTER SEQUENCE couponaccept_couponaccept_id_seq OWNED BY couponaccept.couponaccept_id;
906
907
908--
909-- Name: coupons; Type: TABLE; Schema: public; Owner: hospital
910--
911
912CREATE TABLE coupons (
913    coupons_id integer NOT NULL,
914    coupon character varying(225),
915    applicablesponsor integer,
916    uniquecode character varying(225),
917    validity date,
918    timevalidity integer,
919    couponstatus integer DEFAULT 1
920);
921
922
923ALTER TABLE coupons OWNER TO hospital;
924
925--
926-- Name: coupons_coupons_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
927--
928
929CREATE SEQUENCE coupons_coupons_id_seq
930    START WITH 1
931    INCREMENT BY 1
932    NO MINVALUE
933    NO MAXVALUE
934    CACHE 1;
935
936
937ALTER TABLE coupons_coupons_id_seq OWNER TO hospital;
938
939--
940-- Name: coupons_coupons_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
941--
942
943ALTER SEQUENCE coupons_coupons_id_seq OWNED BY coupons.coupons_id;
944
945
946--
947-- Name: designation; Type: TABLE; Schema: public; Owner: hospital
948--
949
950CREATE TABLE designation (
951    designation_id integer NOT NULL,
952    designation character varying(225),
953    sort_by integer,
954    status_2 integer DEFAULT 1
955);
956
957
958ALTER TABLE designation OWNER TO hospital;
959
960--
961-- Name: designation_designation_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
962--
963
964CREATE SEQUENCE designation_designation_id_seq
965    START WITH 1
966    INCREMENT BY 1
967    NO MINVALUE
968    NO MAXVALUE
969    CACHE 1;
970
971
972ALTER TABLE designation_designation_id_seq OWNER TO hospital;
973
974--
975-- Name: designation_designation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
976--
977
978ALTER SEQUENCE designation_designation_id_seq OWNED BY designation.designation_id;
979
980
981--
982-- Name: discountcard; Type: TABLE; Schema: public; Owner: hospital
983--
984
985CREATE TABLE discountcard (
986    discountcard_id integer NOT NULL,
987    healthchecks_id integer NOT NULL,
988    discountcard character varying(225),
989    description character varying(225),
990    eligibility integer,
991    familyrestriction integer DEFAULT 0,
992    addfamilyrestriction integer DEFAULT 0,
993    applicablesponser integer DEFAULT 0,
994    otherbenfits character varying(225)
995);
996
997
998ALTER TABLE discountcard OWNER TO hospital;
999
1000--
1001-- Name: discountcard_discountcard_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
1002--
1003
1004CREATE SEQUENCE discountcard_discountcard_id_seq
1005    START WITH 1
1006    INCREMENT BY 1
1007    NO MINVALUE
1008    NO MAXVALUE
1009    CACHE 1;
1010
1011
1012ALTER TABLE discountcard_discountcard_id_seq OWNER TO hospital;
1013
1014--
1015-- Name: discountcard_discountcard_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
1016--
1017
1018ALTER SEQUENCE discountcard_discountcard_id_seq OWNED BY discountcard.discountcard_id;
1019
1020
1021--
1022-- Name: discountcard_family; Type: TABLE; Schema: public; Owner: hospital
1023--
1024
1025CREATE TABLE discountcard_family (
1026    discountcard_family_id integer NOT NULL,
1027    discountcard_id integer NOT NULL,
1028    family_id integer NOT NULL,
1029    price integer
1030);
1031
1032
1033ALTER TABLE discountcard_family OWNER TO hospital;
1034
1035--
1036-- Name: discountcard_family_discountcard_family_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
1037--
1038
1039CREATE SEQUENCE discountcard_family_discountcard_family_id_seq
1040    START WITH 1
1041    INCREMENT BY 1
1042    NO MINVALUE
1043    NO MAXVALUE
1044    CACHE 1;
1045
1046
1047ALTER TABLE discountcard_family_discountcard_family_id_seq OWNER TO hospital;
1048
1049--
1050-- Name: discountcard_family_discountcard_family_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
1051--
1052
1053ALTER SEQUENCE discountcard_family_discountcard_family_id_seq OWNED BY discountcard_family.discountcard_family_id;
1054
1055
1056--
1057-- Name: discountcard_family_extra; Type: TABLE; Schema: public; Owner: hospital
1058--
1059
1060CREATE TABLE discountcard_family_extra (
1061    discountcard_family_extra_id integer NOT NULL,
1062    family_id integer NOT NULL,
1063    discountcard_id integer NOT NULL,
1064    price integer DEFAULT 100
1065);
1066
1067
1068ALTER TABLE discountcard_family_extra OWNER TO hospital;
1069
1070--
1071-- Name: discountcard_family_extra_discountcard_family_extra_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
1072--
1073
1074CREATE SEQUENCE discountcard_family_extra_discountcard_family_extra_id_seq
1075    START WITH 1
1076    INCREMENT BY 1
1077    NO MINVALUE
1078    NO MAXVALUE
1079    CACHE 1;
1080
1081
1082ALTER TABLE discountcard_family_extra_discountcard_family_extra_id_seq OWNER TO hospital;
1083
1084--
1085-- Name: discountcard_family_extra_discountcard_family_extra_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
1086--
1087
1088ALTER SEQUENCE discountcard_family_extra_discountcard_family_extra_id_seq OWNED BY discountcard_family_extra.discountcard_family_extra_id;
1089
1090
1091--
1092-- Name: district; Type: TABLE; Schema: public; Owner: hospital
1093--
1094
1095CREATE TABLE district (
1096    district_id integer NOT NULL,
1097    district character varying(225),
1098    sort_by integer,
1099    status_2 integer DEFAULT 1
1100);
1101
1102
1103ALTER TABLE district OWNER TO hospital;
1104
1105--
1106-- Name: district_district_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
1107--
1108
1109CREATE SEQUENCE district_district_id_seq
1110    START WITH 1
1111    INCREMENT BY 1
1112    NO MINVALUE
1113    NO MAXVALUE
1114    CACHE 1;
1115
1116
1117ALTER TABLE district_district_id_seq OWNER TO hospital;
1118
1119--
1120-- Name: district_district_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
1121--
1122
1123ALTER SEQUENCE district_district_id_seq OWNED BY district.district_id;
1124
1125
1126--
1127-- Name: django_admin_log; Type: TABLE; Schema: public; Owner: hospital
1128--
1129
1130CREATE TABLE django_admin_log (
1131    id integer NOT NULL,
1132    action_time timestamp with time zone NOT NULL,
1133    object_id text,
1134    object_repr character varying(200) NOT NULL,
1135    action_flag smallint NOT NULL,
1136    change_message text NOT NULL,
1137    content_type_id integer,
1138    user_id integer NOT NULL,
1139    CONSTRAINT django_admin_log_action_flag_check CHECK ((action_flag >= 0))
1140);
1141
1142
1143ALTER TABLE django_admin_log OWNER TO hospital;
1144
1145--
1146-- Name: django_admin_log_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
1147--
1148
1149CREATE SEQUENCE django_admin_log_id_seq
1150    START WITH 1
1151    INCREMENT BY 1
1152    NO MINVALUE
1153    NO MAXVALUE
1154    CACHE 1;
1155
1156
1157ALTER TABLE django_admin_log_id_seq OWNER TO hospital;
1158
1159--
1160-- Name: django_admin_log_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
1161--
1162
1163ALTER SEQUENCE django_admin_log_id_seq OWNED BY django_admin_log.id;
1164
1165
1166--
1167-- Name: django_content_type; Type: TABLE; Schema: public; Owner: hospital
1168--
1169
1170CREATE TABLE django_content_type (
1171    id integer NOT NULL,
1172    app_label character varying(100) NOT NULL,
1173    model character varying(100) NOT NULL
1174);
1175
1176
1177ALTER TABLE django_content_type OWNER TO hospital;
1178
1179--
1180-- Name: django_content_type_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
1181--
1182
1183CREATE SEQUENCE django_content_type_id_seq
1184    START WITH 1
1185    INCREMENT BY 1
1186    NO MINVALUE
1187    NO MAXVALUE
1188    CACHE 1;
1189
1190
1191ALTER TABLE django_content_type_id_seq OWNER TO hospital;
1192
1193--
1194-- Name: django_content_type_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
1195--
1196
1197ALTER SEQUENCE django_content_type_id_seq OWNED BY django_content_type.id;
1198
1199
1200--
1201-- Name: django_migrations; Type: TABLE; Schema: public; Owner: hospital
1202--
1203
1204CREATE TABLE django_migrations (
1205    id integer NOT NULL,
1206    app character varying(255) NOT NULL,
1207    name character varying(255) NOT NULL,
1208    applied timestamp with time zone NOT NULL
1209);
1210
1211
1212ALTER TABLE django_migrations OWNER TO hospital;
1213
1214--
1215-- Name: django_migrations_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
1216--
1217
1218CREATE SEQUENCE django_migrations_id_seq
1219    START WITH 1
1220    INCREMENT BY 1
1221    NO MINVALUE
1222    NO MAXVALUE
1223    CACHE 1;
1224
1225
1226ALTER TABLE django_migrations_id_seq OWNER TO hospital;
1227
1228--
1229-- Name: django_migrations_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
1230--
1231
1232ALTER SEQUENCE django_migrations_id_seq OWNED BY django_migrations.id;
1233
1234
1235--
1236-- Name: django_session; Type: TABLE; Schema: public; Owner: hospital
1237--
1238
1239CREATE TABLE django_session (
1240    session_key character varying(40) NOT NULL,
1241    session_data text NOT NULL,
1242    expire_date timestamp with time zone NOT NULL
1243);
1244
1245
1246ALTER TABLE django_session OWNER TO hospital;
1247
1248--
1249-- Name: facilities; Type: TABLE; Schema: public; Owner: hospital
1250--
1251
1252CREATE TABLE facilities (
1253    facilities_id integer NOT NULL,
1254    facility character varying(225),
1255    sort_by integer,
1256    status_2 integer DEFAULT 1
1257);
1258
1259
1260ALTER TABLE facilities OWNER TO hospital;
1261
1262--
1263-- Name: facilities_facilities_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
1264--
1265
1266CREATE SEQUENCE facilities_facilities_id_seq
1267    START WITH 1
1268    INCREMENT BY 1
1269    NO MINVALUE
1270    NO MAXVALUE
1271    CACHE 1;
1272
1273
1274ALTER TABLE facilities_facilities_id_seq OWNER TO hospital;
1275
1276--
1277-- Name: facilities_facilities_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
1278--
1279
1280ALTER SEQUENCE facilities_facilities_id_seq OWNED BY facilities.facilities_id;
1281
1282
1283--
1284-- Name: facilities_services; Type: TABLE; Schema: public; Owner: hospital
1285--
1286
1287CREATE TABLE facilities_services (
1288    facilities_services_id integer NOT NULL,
1289    facilities_id integer NOT NULL,
1290    facilities_services character varying(225),
1291    sort_by integer,
1292    status_2 integer DEFAULT 1
1293);
1294
1295
1296ALTER TABLE facilities_services OWNER TO hospital;
1297
1298--
1299-- Name: facilities_services_facilities_services_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
1300--
1301
1302CREATE SEQUENCE facilities_services_facilities_services_id_seq
1303    START WITH 1
1304    INCREMENT BY 1
1305    NO MINVALUE
1306    NO MAXVALUE
1307    CACHE 1;
1308
1309
1310ALTER TABLE facilities_services_facilities_services_id_seq OWNER TO hospital;
1311
1312--
1313-- Name: facilities_services_facilities_services_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
1314--
1315
1316ALTER SEQUENCE facilities_services_facilities_services_id_seq OWNED BY facilities_services.facilities_services_id;
1317
1318
1319--
1320-- Name: family; Type: TABLE; Schema: public; Owner: hospital
1321--
1322
1323CREATE TABLE family (
1324    family_id integer NOT NULL,
1325    family character varying(225),
1326    sort_by integer,
1327    status_2 integer DEFAULT 1
1328);
1329
1330
1331ALTER TABLE family OWNER TO hospital;
1332
1333--
1334-- Name: family_family_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
1335--
1336
1337CREATE SEQUENCE family_family_id_seq
1338    START WITH 1
1339    INCREMENT BY 1
1340    NO MINVALUE
1341    NO MAXVALUE
1342    CACHE 1;
1343
1344
1345ALTER TABLE family_family_id_seq OWNER TO hospital;
1346
1347--
1348-- Name: family_family_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
1349--
1350
1351ALTER SEQUENCE family_family_id_seq OWNED BY family.family_id;
1352
1353
1354--
1355-- Name: feedback; Type: TABLE; Schema: public; Owner: hospital
1356--
1357
1358CREATE TABLE feedback (
1359    feedback_id integer NOT NULL,
1360    users_id integer NOT NULL,
1361    users_feedback character varying(225),
1362    from_2 character varying(225),
1363    reg_date timestamp without time zone,
1364    feedbackstatus integer
1365);
1366
1367
1368ALTER TABLE feedback OWNER TO hospital;
1369
1370--
1371-- Name: feedback_feedback_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
1372--
1373
1374CREATE SEQUENCE feedback_feedback_id_seq
1375    START WITH 1
1376    INCREMENT BY 1
1377    NO MINVALUE
1378    NO MAXVALUE
1379    CACHE 1;
1380
1381
1382ALTER TABLE feedback_feedback_id_seq OWNER TO hospital;
1383
1384--
1385-- Name: feedback_feedback_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
1386--
1387
1388ALTER SEQUENCE feedback_feedback_id_seq OWNED BY feedback.feedback_id;
1389
1390
1391--
1392-- Name: gender; Type: TABLE; Schema: public; Owner: hospital
1393--
1394
1395CREATE TABLE gender (
1396    gender_id integer NOT NULL,
1397    gender character varying(225),
1398    sort_by integer,
1399    status_2 integer DEFAULT 1
1400);
1401
1402
1403ALTER TABLE gender OWNER TO hospital;
1404
1405--
1406-- Name: gender_gender_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
1407--
1408
1409CREATE SEQUENCE gender_gender_id_seq
1410    START WITH 1
1411    INCREMENT BY 1
1412    NO MINVALUE
1413    NO MAXVALUE
1414    CACHE 1;
1415
1416
1417ALTER TABLE gender_gender_id_seq OWNER TO hospital;
1418
1419--
1420-- Name: gender_gender_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
1421--
1422
1423ALTER SEQUENCE gender_gender_id_seq OWNED BY gender.gender_id;
1424
1425
1426--
1427-- Name: healthcheckbooking; Type: TABLE; Schema: public; Owner: hospital
1428--
1429
1430CREATE TABLE healthcheckbooking (
1431    healthcheckbooking_id integer NOT NULL,
1432    healthseeker_id integer NOT NULL,
1433    healthproviders_id integer NOT NULL,
1434    bookingsources_id integer NOT NULL,
1435    date date,
1436    "time" time without time zone,
1437    reg_date timestamp without time zone
1438);
1439
1440
1441ALTER TABLE healthcheckbooking OWNER TO hospital;
1442
1443--
1444-- Name: healthcheckbooking_healthcheckbooking_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
1445--
1446
1447CREATE SEQUENCE healthcheckbooking_healthcheckbooking_id_seq
1448    START WITH 1
1449    INCREMENT BY 1
1450    NO MINVALUE
1451    NO MAXVALUE
1452    CACHE 1;
1453
1454
1455ALTER TABLE healthcheckbooking_healthcheckbooking_id_seq OWNER TO hospital;
1456
1457--
1458-- Name: healthcheckbooking_healthcheckbooking_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
1459--
1460
1461ALTER SEQUENCE healthcheckbooking_healthcheckbooking_id_seq OWNED BY healthcheckbooking.healthcheckbooking_id;
1462
1463
1464--
1465-- Name: healthchecks; Type: TABLE; Schema: public; Owner: hospital
1466--
1467
1468CREATE TABLE healthchecks (
1469    healthchecks_id integer NOT NULL,
1470    coupons_id integer NOT NULL,
1471    healthcheck character varying(225),
1472    description character varying(225),
1473    price integer,
1474    promoimage character varying(225),
1475    applicable_sponser integer
1476);
1477
1478
1479ALTER TABLE healthchecks OWNER TO hospital;
1480
1481--
1482-- Name: healthchecks_healthchecks_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
1483--
1484
1485CREATE SEQUENCE healthchecks_healthchecks_id_seq
1486    START WITH 1
1487    INCREMENT BY 1
1488    NO MINVALUE
1489    NO MAXVALUE
1490    CACHE 1;
1491
1492
1493ALTER TABLE healthchecks_healthchecks_id_seq OWNER TO hospital;
1494
1495--
1496-- Name: healthchecks_healthchecks_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
1497--
1498
1499ALTER SEQUENCE healthchecks_healthchecks_id_seq OWNED BY healthchecks.healthchecks_id;
1500
1501
1502--
1503-- Name: healthchecks_inclusion; Type: TABLE; Schema: public; Owner: hospital
1504--
1505
1506CREATE TABLE healthchecks_inclusion (
1507    healthchecks_inclusion_id integer NOT NULL,
1508    test_id integer NOT NULL,
1509    healthchecks_id integer NOT NULL
1510);
1511
1512
1513ALTER TABLE healthchecks_inclusion OWNER TO hospital;
1514
1515--
1516-- Name: healthchecks_inclusion_healthchecks_inclusion_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
1517--
1518
1519CREATE SEQUENCE healthchecks_inclusion_healthchecks_inclusion_id_seq
1520    START WITH 1
1521    INCREMENT BY 1
1522    NO MINVALUE
1523    NO MAXVALUE
1524    CACHE 1;
1525
1526
1527ALTER TABLE healthchecks_inclusion_healthchecks_inclusion_id_seq OWNER TO hospital;
1528
1529--
1530-- Name: healthchecks_inclusion_healthchecks_inclusion_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
1531--
1532
1533ALTER SEQUENCE healthchecks_inclusion_healthchecks_inclusion_id_seq OWNED BY healthchecks_inclusion.healthchecks_inclusion_id;
1534
1535
1536--
1537-- Name: healthproviders; Type: TABLE; Schema: public; Owner: hospital
1538--
1539
1540CREATE TABLE healthproviders (
1541    healthproviders_id integer NOT NULL,
1542    address_id integer NOT NULL,
1543    users_id integer NOT NULL,
1544    is_branch integer DEFAULT 0,
1545    under_healthproviders_id integer,
1546    display_cost integer,
1547    activefrom timestamp without time zone,
1548    activeto timestamp without time zone,
1549    m_date timestamp without time zone
1550);
1551
1552
1553ALTER TABLE healthproviders OWNER TO hospital;
1554
1555--
1556-- Name: healthproviders_healthproviders_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
1557--
1558
1559CREATE SEQUENCE healthproviders_healthproviders_id_seq
1560    START WITH 1
1561    INCREMENT BY 1
1562    NO MINVALUE
1563    NO MAXVALUE
1564    CACHE 1;
1565
1566
1567ALTER TABLE healthproviders_healthproviders_id_seq OWNER TO hospital;
1568
1569--
1570-- Name: healthproviders_healthproviders_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
1571--
1572
1573ALTER SEQUENCE healthproviders_healthproviders_id_seq OWNED BY healthproviders.healthproviders_id;
1574
1575
1576--
1577-- Name: healthproviders_speciality; Type: TABLE; Schema: public; Owner: hospital
1578--
1579
1580CREATE TABLE healthproviders_speciality (
1581    healthproviders_speciality_id integer NOT NULL,
1582    speciality_id integer NOT NULL,
1583    healthproviders_id integer NOT NULL,
1584    sort_by integer,
1585    speciality_name character varying(225),
1586    speciality_description character varying(225),
1587    price integer,
1588    discountpercentage integer DEFAULT 0,
1589    activefrom timestamp without time zone,
1590    activeto timestamp without time zone,
1591    status_2 integer DEFAULT 1,
1592    reg_date timestamp without time zone
1593);
1594
1595
1596ALTER TABLE healthproviders_speciality OWNER TO hospital;
1597
1598--
1599-- Name: healthproviders_speciality_healthproviders_speciality_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
1600--
1601
1602CREATE SEQUENCE healthproviders_speciality_healthproviders_speciality_id_seq
1603    START WITH 1
1604    INCREMENT BY 1
1605    NO MINVALUE
1606    NO MAXVALUE
1607    CACHE 1;
1608
1609
1610ALTER TABLE healthproviders_speciality_healthproviders_speciality_id_seq OWNER TO hospital;
1611
1612--
1613-- Name: healthproviders_speciality_healthproviders_speciality_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
1614--
1615
1616ALTER SEQUENCE healthproviders_speciality_healthproviders_speciality_id_seq OWNED BY healthproviders_speciality.healthproviders_speciality_id;
1617
1618
1619--
1620-- Name: healthrecords; Type: TABLE; Schema: public; Owner: hospital
1621--
1622
1623CREATE TABLE healthrecords (
1624    healthrecords_id integer NOT NULL,
1625    healthrecord character varying(225),
1626    sort_by integer,
1627    status_2 integer DEFAULT 1
1628);
1629
1630
1631ALTER TABLE healthrecords OWNER TO hospital;
1632
1633--
1634-- Name: healthrecords_healthrecords_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
1635--
1636
1637CREATE SEQUENCE healthrecords_healthrecords_id_seq
1638    START WITH 1
1639    INCREMENT BY 1
1640    NO MINVALUE
1641    NO MAXVALUE
1642    CACHE 1;
1643
1644
1645ALTER TABLE healthrecords_healthrecords_id_seq OWNER TO hospital;
1646
1647--
1648-- Name: healthrecords_healthrecords_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
1649--
1650
1651ALTER SEQUENCE healthrecords_healthrecords_id_seq OWNED BY healthrecords.healthrecords_id;
1652
1653
1654--
1655-- Name: healthseeker; Type: TABLE; Schema: public; Owner: hospital
1656--
1657
1658CREATE TABLE healthseeker (
1659    healthseeker_id integer NOT NULL,
1660    healthseeker_type_id integer NOT NULL,
1661    profession_id integer NOT NULL,
1662    languages_id integer NOT NULL,
1663    gender_id integer NOT NULL,
1664    users_id integer NOT NULL,
1665    underfamily integer DEFAULT 0,
1666    undersponser integer DEFAULT 0,
1667    dob date,
1668    image character varying(225)
1669);
1670
1671
1672ALTER TABLE healthseeker OWNER TO hospital;
1673
1674--
1675-- Name: healthseeker_alerts; Type: TABLE; Schema: public; Owner: hospital
1676--
1677
1678CREATE TABLE healthseeker_alerts (
1679    healthseeker_alerts_id integer NOT NULL,
1680    alertsources_id integer NOT NULL,
1681    alerttype_id integer NOT NULL,
1682    healthseeker_id integer NOT NULL,
1683    activefrom timestamp without time zone,
1684    activeto timestamp without time zone,
1685    alert_to integer
1686);
1687
1688
1689ALTER TABLE healthseeker_alerts OWNER TO hospital;
1690
1691--
1692-- Name: healthseeker_alerts_healthseeker_alerts_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
1693--
1694
1695CREATE SEQUENCE healthseeker_alerts_healthseeker_alerts_id_seq
1696    START WITH 1
1697    INCREMENT BY 1
1698    NO MINVALUE
1699    NO MAXVALUE
1700    CACHE 1;
1701
1702
1703ALTER TABLE healthseeker_alerts_healthseeker_alerts_id_seq OWNER TO hospital;
1704
1705--
1706-- Name: healthseeker_alerts_healthseeker_alerts_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
1707--
1708
1709ALTER SEQUENCE healthseeker_alerts_healthseeker_alerts_id_seq OWNED BY healthseeker_alerts.healthseeker_alerts_id;
1710
1711
1712--
1713-- Name: healthseeker_availabilities; Type: TABLE; Schema: public; Owner: hospital
1714--
1715
1716CREATE TABLE healthseeker_availabilities (
1717    healthseeker_availabilities_id integer NOT NULL,
1718    healthchecks_id integer NOT NULL,
1719    discountcard_id integer NOT NULL,
1720    coupons_id integer NOT NULL,
1721    healthseeker_id integer NOT NULL,
1722    amount integer
1723);
1724
1725
1726ALTER TABLE healthseeker_availabilities OWNER TO hospital;
1727
1728--
1729-- Name: healthseeker_availabilities_healthseeker_availabilities_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
1730--
1731
1732CREATE SEQUENCE healthseeker_availabilities_healthseeker_availabilities_id_seq
1733    START WITH 1
1734    INCREMENT BY 1
1735    NO MINVALUE
1736    NO MAXVALUE
1737    CACHE 1;
1738
1739
1740ALTER TABLE healthseeker_availabilities_healthseeker_availabilities_id_seq OWNER TO hospital;
1741
1742--
1743-- Name: healthseeker_availabilities_healthseeker_availabilities_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
1744--
1745
1746ALTER SEQUENCE healthseeker_availabilities_healthseeker_availabilities_id_seq OWNED BY healthseeker_availabilities.healthseeker_availabilities_id;
1747
1748
1749--
1750-- Name: healthseeker_healthrecords; Type: TABLE; Schema: public; Owner: hospital
1751--
1752
1753CREATE TABLE healthseeker_healthrecords (
1754    healthseeker_healthrecords_id integer NOT NULL,
1755    healthrecords_id integer NOT NULL,
1756    healthseeker_id integer NOT NULL,
1757    refdate date,
1758    file_2 character varying(225),
1759    file3 character varying(225),
1760    reg_date timestamp without time zone,
1761    m_date timestamp without time zone
1762);
1763
1764
1765ALTER TABLE healthseeker_healthrecords OWNER TO hospital;
1766
1767--
1768-- Name: healthseeker_healthrecords_healthseeker_healthrecords_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
1769--
1770
1771CREATE SEQUENCE healthseeker_healthrecords_healthseeker_healthrecords_id_seq
1772    START WITH 1
1773    INCREMENT BY 1
1774    NO MINVALUE
1775    NO MAXVALUE
1776    CACHE 1;
1777
1778
1779ALTER TABLE healthseeker_healthrecords_healthseeker_healthrecords_id_seq OWNER TO hospital;
1780
1781--
1782-- Name: healthseeker_healthrecords_healthseeker_healthrecords_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
1783--
1784
1785ALTER SEQUENCE healthseeker_healthrecords_healthseeker_healthrecords_id_seq OWNED BY healthseeker_healthrecords.healthseeker_healthrecords_id;
1786
1787
1788--
1789-- Name: healthseeker_healthseeker_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
1790--
1791
1792CREATE SEQUENCE healthseeker_healthseeker_id_seq
1793    START WITH 1
1794    INCREMENT BY 1
1795    NO MINVALUE
1796    NO MAXVALUE
1797    CACHE 1;
1798
1799
1800ALTER TABLE healthseeker_healthseeker_id_seq OWNER TO hospital;
1801
1802--
1803-- Name: healthseeker_healthseeker_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
1804--
1805
1806ALTER SEQUENCE healthseeker_healthseeker_id_seq OWNED BY healthseeker.healthseeker_id;
1807
1808
1809--
1810-- Name: healthseeker_type; Type: TABLE; Schema: public; Owner: hospital
1811--
1812
1813CREATE TABLE healthseeker_type (
1814    healthseeker_type_id integer NOT NULL,
1815    healthseeker_type character varying(225)
1816);
1817
1818
1819ALTER TABLE healthseeker_type OWNER TO hospital;
1820
1821--
1822-- Name: healthseeker_type_healthseeker_type_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
1823--
1824
1825CREATE SEQUENCE healthseeker_type_healthseeker_type_id_seq
1826    START WITH 1
1827    INCREMENT BY 1
1828    NO MINVALUE
1829    NO MAXVALUE
1830    CACHE 1;
1831
1832
1833ALTER TABLE healthseeker_type_healthseeker_type_id_seq OWNER TO hospital;
1834
1835--
1836-- Name: healthseeker_type_healthseeker_type_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
1837--
1838
1839ALTER SEQUENCE healthseeker_type_healthseeker_type_id_seq OWNED BY healthseeker_type.healthseeker_type_id;
1840
1841
1842--
1843-- Name: interest; Type: TABLE; Schema: public; Owner: hospital
1844--
1845
1846CREATE TABLE interest (
1847    interest_id integer NOT NULL,
1848    healthseeker_id integer NOT NULL,
1849    interest character varying(225),
1850    sort_by integer,
1851    status_2 integer DEFAULT 1
1852);
1853
1854
1855ALTER TABLE interest OWNER TO hospital;
1856
1857--
1858-- Name: interest_interest_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
1859--
1860
1861CREATE SEQUENCE interest_interest_id_seq
1862    START WITH 1
1863    INCREMENT BY 1
1864    NO MINVALUE
1865    NO MAXVALUE
1866    CACHE 1;
1867
1868
1869ALTER TABLE interest_interest_id_seq OWNER TO hospital;
1870
1871--
1872-- Name: interest_interest_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
1873--
1874
1875ALTER SEQUENCE interest_interest_id_seq OWNED BY interest.interest_id;
1876
1877
1878--
1879-- Name: languages; Type: TABLE; Schema: public; Owner: hospital
1880--
1881
1882CREATE TABLE languages (
1883    languages_id integer NOT NULL,
1884    language character varying(225),
1885    sort_by integer,
1886    status_2 integer DEFAULT 1
1887);
1888
1889
1890ALTER TABLE languages OWNER TO hospital;
1891
1892--
1893-- Name: languages_languages_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
1894--
1895
1896CREATE SEQUENCE languages_languages_id_seq
1897    START WITH 1
1898    INCREMENT BY 1
1899    NO MINVALUE
1900    NO MAXVALUE
1901    CACHE 1;
1902
1903
1904ALTER TABLE languages_languages_id_seq OWNER TO hospital;
1905
1906--
1907-- Name: languages_languages_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
1908--
1909
1910ALTER SEQUENCE languages_languages_id_seq OWNED BY languages.languages_id;
1911
1912
1913--
1914-- Name: photoalbum; Type: TABLE; Schema: public; Owner: hospital
1915--
1916
1917CREATE TABLE photoalbum (
1918    photoalbum_id integer NOT NULL,
1919    users_id integer NOT NULL,
1920    photo_title character varying(225),
1921    image_path character varying(225) NOT NULL,
1922    forusage character varying(225),
1923    sort_by integer,
1924    status_2 integer DEFAULT 1
1925);
1926
1927
1928ALTER TABLE photoalbum OWNER TO hospital;
1929
1930--
1931-- Name: photoalbum_photoalbum_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
1932--
1933
1934CREATE SEQUENCE photoalbum_photoalbum_id_seq
1935    START WITH 1
1936    INCREMENT BY 1
1937    NO MINVALUE
1938    NO MAXVALUE
1939    CACHE 1;
1940
1941
1942ALTER TABLE photoalbum_photoalbum_id_seq OWNER TO hospital;
1943
1944--
1945-- Name: photoalbum_photoalbum_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
1946--
1947
1948ALTER SEQUENCE photoalbum_photoalbum_id_seq OWNED BY photoalbum.photoalbum_id;
1949
1950
1951--
1952-- Name: plans; Type: TABLE; Schema: public; Owner: hospital
1953--
1954
1955CREATE TABLE plans (
1956    plans_id integer NOT NULL,
1957    plans_groups_id integer NOT NULL,
1958    plan character varying(225),
1959    description character varying(225),
1960    price integer,
1961    noofpatients integer,
1962    benefits character varying(225),
1963    share1stconsultation integer,
1964    sharenextconsultation integer,
1965    planworks character varying(225),
1966    addbenfits character varying(225),
1967    cmslicencevalidity character varying(225),
1968    validity character varying(225),
1969    discount1stconsultation integer,
1970    discountnextconsultation integer,
1971    promoimage character varying(225),
1972    applicability character varying(225),
1973    doctorscoupon integer,
1974    reg_date timestamp without time zone,
1975    activefrom timestamp without time zone,
1976    activeto timestamp without time zone
1977);
1978
1979
1980ALTER TABLE plans OWNER TO hospital;
1981
1982--
1983-- Name: plans_groups; Type: TABLE; Schema: public; Owner: hospital
1984--
1985
1986CREATE TABLE plans_groups (
1987    plans_groups_id integer NOT NULL,
1988    plans_groups_specialities_id integer NOT NULL,
1989    plans_group character varying(225),
1990    activefrom timestamp without time zone,
1991    activeto timestamp without time zone
1992);
1993
1994
1995ALTER TABLE plans_groups OWNER TO hospital;
1996
1997--
1998-- Name: plans_groups_plans_groups_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
1999--
2000
2001CREATE SEQUENCE plans_groups_plans_groups_id_seq
2002    START WITH 1
2003    INCREMENT BY 1
2004    NO MINVALUE
2005    NO MAXVALUE
2006    CACHE 1;
2007
2008
2009ALTER TABLE plans_groups_plans_groups_id_seq OWNER TO hospital;
2010
2011--
2012-- Name: plans_groups_plans_groups_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
2013--
2014
2015ALTER SEQUENCE plans_groups_plans_groups_id_seq OWNED BY plans_groups.plans_groups_id;
2016
2017
2018--
2019-- Name: plans_groups_specialities; Type: TABLE; Schema: public; Owner: hospital
2020--
2021
2022CREATE TABLE plans_groups_specialities (
2023    plans_groups_specialities_id integer NOT NULL
2024);
2025
2026
2027ALTER TABLE plans_groups_specialities OWNER TO hospital;
2028
2029--
2030-- Name: plans_groups_specialities_plans_groups_specialities_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
2031--
2032
2033CREATE SEQUENCE plans_groups_specialities_plans_groups_specialities_id_seq
2034    START WITH 1
2035    INCREMENT BY 1
2036    NO MINVALUE
2037    NO MAXVALUE
2038    CACHE 1;
2039
2040
2041ALTER TABLE plans_groups_specialities_plans_groups_specialities_id_seq OWNER TO hospital;
2042
2043--
2044-- Name: plans_groups_specialities_plans_groups_specialities_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
2045--
2046
2047ALTER SEQUENCE plans_groups_specialities_plans_groups_specialities_id_seq OWNED BY plans_groups_specialities.plans_groups_specialities_id;
2048
2049
2050--
2051-- Name: plans_plans_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
2052--
2053
2054CREATE SEQUENCE plans_plans_id_seq
2055    START WITH 1
2056    INCREMENT BY 1
2057    NO MINVALUE
2058    NO MAXVALUE
2059    CACHE 1;
2060
2061
2062ALTER TABLE plans_plans_id_seq OWNER TO hospital;
2063
2064--
2065-- Name: plans_plans_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
2066--
2067
2068ALTER SEQUENCE plans_plans_id_seq OWNED BY plans.plans_id;
2069
2070
2071--
2072-- Name: priyority; Type: TABLE; Schema: public; Owner: hospital
2073--
2074
2075CREATE TABLE priyority (
2076    priyority_id integer NOT NULL,
2077    priyority integer,
2078    sort_by integer,
2079    status_2 integer DEFAULT 1
2080);
2081
2082
2083ALTER TABLE priyority OWNER TO hospital;
2084
2085--
2086-- Name: priyority_priyority_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
2087--
2088
2089CREATE SEQUENCE priyority_priyority_id_seq
2090    START WITH 1
2091    INCREMENT BY 1
2092    NO MINVALUE
2093    NO MAXVALUE
2094    CACHE 1;
2095
2096
2097ALTER TABLE priyority_priyority_id_seq OWNER TO hospital;
2098
2099--
2100-- Name: priyority_priyority_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
2101--
2102
2103ALTER SEQUENCE priyority_priyority_id_seq OWNED BY priyority.priyority_id;
2104
2105
2106--
2107-- Name: profession; Type: TABLE; Schema: public; Owner: hospital
2108--
2109
2110CREATE TABLE profession (
2111    profession_id integer NOT NULL,
2112    poorofession character varying(225),
2113    sort_by integer,
2114    status_2 integer DEFAULT 1
2115);
2116
2117
2118ALTER TABLE profession OWNER TO hospital;
2119
2120--
2121-- Name: profession_profession_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
2122--
2123
2124CREATE SEQUENCE profession_profession_id_seq
2125    START WITH 1
2126    INCREMENT BY 1
2127    NO MINVALUE
2128    NO MAXVALUE
2129    CACHE 1;
2130
2131
2132ALTER TABLE profession_profession_id_seq OWNER TO hospital;
2133
2134--
2135-- Name: profession_profession_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
2136--
2137
2138ALTER SEQUENCE profession_profession_id_seq OWNED BY profession.profession_id;
2139
2140
2141--
2142-- Name: qualification; Type: TABLE; Schema: public; Owner: hospital
2143--
2144
2145CREATE TABLE qualification (
2146    qualification_id integer NOT NULL,
2147    qualification character varying(225),
2148    sort_by integer,
2149    status_2 integer DEFAULT 1
2150);
2151
2152
2153ALTER TABLE qualification OWNER TO hospital;
2154
2155--
2156-- Name: qualification_qualification_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
2157--
2158
2159CREATE SEQUENCE qualification_qualification_id_seq
2160    START WITH 1
2161    INCREMENT BY 1
2162    NO MINVALUE
2163    NO MAXVALUE
2164    CACHE 1;
2165
2166
2167ALTER TABLE qualification_qualification_id_seq OWNER TO hospital;
2168
2169--
2170-- Name: qualification_qualification_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
2171--
2172
2173ALTER SEQUENCE qualification_qualification_id_seq OWNED BY qualification.qualification_id;
2174
2175
2176--
2177-- Name: referrels; Type: TABLE; Schema: public; Owner: hospital
2178--
2179
2180CREATE TABLE referrels (
2181    referrels_id integer NOT NULL,
2182    fromusers_id integer,
2183    referredusers_id integer,
2184    cashback integer,
2185    source integer,
2186    reg_date timestamp without time zone
2187);
2188
2189
2190ALTER TABLE referrels OWNER TO hospital;
2191
2192--
2193-- Name: referrels_referrels_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
2194--
2195
2196CREATE SEQUENCE referrels_referrels_id_seq
2197    START WITH 1
2198    INCREMENT BY 1
2199    NO MINVALUE
2200    NO MAXVALUE
2201    CACHE 1;
2202
2203
2204ALTER TABLE referrels_referrels_id_seq OWNER TO hospital;
2205
2206--
2207-- Name: referrels_referrels_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
2208--
2209
2210ALTER SEQUENCE referrels_referrels_id_seq OWNED BY referrels.referrels_id;
2211
2212
2213--
2214-- Name: referrelscheme; Type: TABLE; Schema: public; Owner: hospital
2215--
2216
2217CREATE TABLE referrelscheme (
2218    referrelscheme_id integer NOT NULL,
2219    title character varying(225),
2220    noofreferels integer,
2221    cashback integer
2222);
2223
2224
2225ALTER TABLE referrelscheme OWNER TO hospital;
2226
2227--
2228-- Name: referrelscheme_referrelscheme_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
2229--
2230
2231CREATE SEQUENCE referrelscheme_referrelscheme_id_seq
2232    START WITH 1
2233    INCREMENT BY 1
2234    NO MINVALUE
2235    NO MAXVALUE
2236    CACHE 1;
2237
2238
2239ALTER TABLE referrelscheme_referrelscheme_id_seq OWNER TO hospital;
2240
2241--
2242-- Name: referrelscheme_referrelscheme_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
2243--
2244
2245ALTER SEQUENCE referrelscheme_referrelscheme_id_seq OWNED BY referrelscheme.referrelscheme_id;
2246
2247
2248--
2249-- Name: registration_welcome_message; Type: TABLE; Schema: public; Owner: hospital
2250--
2251
2252CREATE TABLE registration_welcome_message (
2253    registration_welcome_message_id integer NOT NULL,
2254    registration_welcome_message character varying(225),
2255    sort_by integer,
2256    status_2 integer DEFAULT 1,
2257    reg_date timestamp without time zone,
2258    activefrom timestamp without time zone,
2259    activeto timestamp without time zone,
2260    m_user integer,
2261    c_user integer,
2262    m_date timestamp without time zone
2263);
2264
2265
2266ALTER TABLE registration_welcome_message OWNER TO hospital;
2267
2268--
2269-- Name: registration_welcome_message_registration_welcome_message_i_seq; Type: SEQUENCE; Schema: public; Owner: hospital
2270--
2271
2272CREATE SEQUENCE registration_welcome_message_registration_welcome_message_i_seq
2273    START WITH 1
2274    INCREMENT BY 1
2275    NO MINVALUE
2276    NO MAXVALUE
2277    CACHE 1;
2278
2279
2280ALTER TABLE registration_welcome_message_registration_welcome_message_i_seq OWNER TO hospital;
2281
2282--
2283-- Name: registration_welcome_message_registration_welcome_message_i_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
2284--
2285
2286ALTER SEQUENCE registration_welcome_message_registration_welcome_message_i_seq OWNED BY registration_welcome_message.registration_welcome_message_id;
2287
2288
2289--
2290-- Name: resellerpackages; Type: TABLE; Schema: public; Owner: hospital
2291--
2292
2293CREATE TABLE resellerpackages (
2294    resellerpackages_id integer NOT NULL,
2295    salestarget_id integer NOT NULL,
2296    packagename character varying(225),
2297    price integer,
2298    noofdiscountcards integer,
2299    packagetype character varying(225),
2300    validity integer,
2301    campaignvalidfrom date,
2302    campaignvalidto date
2303);
2304
2305
2306ALTER TABLE resellerpackages OWNER TO hospital;
2307
2308--
2309-- Name: resellerpackages_resellerpackages_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
2310--
2311
2312CREATE SEQUENCE resellerpackages_resellerpackages_id_seq
2313    START WITH 1
2314    INCREMENT BY 1
2315    NO MINVALUE
2316    NO MAXVALUE
2317    CACHE 1;
2318
2319
2320ALTER TABLE resellerpackages_resellerpackages_id_seq OWNER TO hospital;
2321
2322--
2323-- Name: resellerpackages_resellerpackages_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
2324--
2325
2326ALTER SEQUENCE resellerpackages_resellerpackages_id_seq OWNED BY resellerpackages.resellerpackages_id;
2327
2328
2329--
2330-- Name: resellers; Type: TABLE; Schema: public; Owner: hospital
2331--
2332
2333CREATE TABLE resellers (
2334    resellers_id integer NOT NULL,
2335    users_id integer NOT NULL,
2336    fathername character varying(225),
2337    relationofsalesagents character varying(225),
2338    idproof character varying(225),
2339    serviceoffered character varying(225),
2340    seviceagreementimage character varying(225)
2341);
2342
2343
2344ALTER TABLE resellers OWNER TO hospital;
2345
2346--
2347-- Name: resellers_resellers_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
2348--
2349
2350CREATE SEQUENCE resellers_resellers_id_seq
2351    START WITH 1
2352    INCREMENT BY 1
2353    NO MINVALUE
2354    NO MAXVALUE
2355    CACHE 1;
2356
2357
2358ALTER TABLE resellers_resellers_id_seq OWNER TO hospital;
2359
2360--
2361-- Name: resellers_resellers_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
2362--
2363
2364ALTER SEQUENCE resellers_resellers_id_seq OWNED BY resellers.resellers_id;
2365
2366
2367--
2368-- Name: role; Type: TABLE; Schema: public; Owner: hospital
2369--
2370
2371CREATE TABLE role (
2372    role_id integer NOT NULL,
2373    role character varying(225) NOT NULL,
2374    sort_by integer,
2375    status_2 integer DEFAULT 1,
2376    roleocode character varying(225)
2377);
2378
2379
2380ALTER TABLE role OWNER TO hospital;
2381
2382--
2383-- Name: role_role_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
2384--
2385
2386CREATE SEQUENCE role_role_id_seq
2387    START WITH 1
2388    INCREMENT BY 1
2389    NO MINVALUE
2390    NO MAXVALUE
2391    CACHE 1;
2392
2393
2394ALTER TABLE role_role_id_seq OWNER TO hospital;
2395
2396--
2397-- Name: role_role_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
2398--
2399
2400ALTER SEQUENCE role_role_id_seq OWNED BY role.role_id;
2401
2402
2403--
2404-- Name: salesagentpackages; Type: TABLE; Schema: public; Owner: hospital
2405--
2406
2407CREATE TABLE salesagentpackages (
2408    salesagentpackages_id integer NOT NULL,
2409    salestarget_id integer NOT NULL,
2410    packagename character varying(225),
2411    price integer,
2412    noofdiscountcards integer,
2413    packagetype character varying(225),
2414    validity integer,
2415    campaignvalidfrom date,
2416    campaignvalidto date
2417);
2418
2419
2420ALTER TABLE salesagentpackages OWNER TO hospital;
2421
2422--
2423-- Name: salesagentpackages_salesagentpackages_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
2424--
2425
2426CREATE SEQUENCE salesagentpackages_salesagentpackages_id_seq
2427    START WITH 1
2428    INCREMENT BY 1
2429    NO MINVALUE
2430    NO MAXVALUE
2431    CACHE 1;
2432
2433
2434ALTER TABLE salesagentpackages_salesagentpackages_id_seq OWNER TO hospital;
2435
2436--
2437-- Name: salesagentpackages_salesagentpackages_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
2438--
2439
2440ALTER SEQUENCE salesagentpackages_salesagentpackages_id_seq OWNED BY salesagentpackages.salesagentpackages_id;
2441
2442
2443--
2444-- Name: salesagents; Type: TABLE; Schema: public; Owner: hospital
2445--
2446
2447CREATE TABLE salesagents (
2448    salesagents_id integer NOT NULL,
2449    users_id integer NOT NULL,
2450    agencyname character varying(225),
2451    registrationdate date,
2452    registrationno integer,
2453    registrationproof character varying(225),
2454    authorizedpersonproof character varying(225),
2455    serviceoffered character varying(225),
2456    minimumnoresellers integer,
2457    serviceproposal character varying(225),
2458    ndaagreemert integer DEFAULT 1,
2459    ndaagreementproof character varying(225),
2460    agreementstarts date,
2461    agreementends date,
2462    serviceagreementimage character varying(225)
2463);
2464
2465
2466ALTER TABLE salesagents OWNER TO hospital;
2467
2468--
2469-- Name: salesagents_salesagents_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
2470--
2471
2472CREATE SEQUENCE salesagents_salesagents_id_seq
2473    START WITH 1
2474    INCREMENT BY 1
2475    NO MINVALUE
2476    NO MAXVALUE
2477    CACHE 1;
2478
2479
2480ALTER TABLE salesagents_salesagents_id_seq OWNER TO hospital;
2481
2482--
2483-- Name: salesagents_salesagents_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
2484--
2485
2486ALTER SEQUENCE salesagents_salesagents_id_seq OWNED BY salesagents.salesagents_id;
2487
2488
2489--
2490-- Name: salestarget; Type: TABLE; Schema: public; Owner: hospital
2491--
2492
2493CREATE TABLE salestarget (
2494    salestarget_id integer NOT NULL,
2495    salestarget character varying(225),
2496    noofsales integer,
2497    days integer,
2498    addextracards integer
2499);
2500
2501
2502ALTER TABLE salestarget OWNER TO hospital;
2503
2504--
2505-- Name: salestarget_salestarget_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
2506--
2507
2508CREATE SEQUENCE salestarget_salestarget_id_seq
2509    START WITH 1
2510    INCREMENT BY 1
2511    NO MINVALUE
2512    NO MAXVALUE
2513    CACHE 1;
2514
2515
2516ALTER TABLE salestarget_salestarget_id_seq OWNER TO hospital;
2517
2518--
2519-- Name: salestarget_salestarget_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
2520--
2521
2522ALTER SEQUENCE salestarget_salestarget_id_seq OWNED BY salestarget.salestarget_id;
2523
2524
2525--
2526-- Name: secretquestions; Type: TABLE; Schema: public; Owner: hospital
2527--
2528
2529CREATE TABLE secretquestions (
2530    secretquestions_id integer NOT NULL,
2531    secretquestion character varying(225),
2532    sort_by integer,
2533    status_2 integer DEFAULT 1
2534);
2535
2536
2537ALTER TABLE secretquestions OWNER TO hospital;
2538
2539--
2540-- Name: secretquestions_secretquestions_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
2541--
2542
2543CREATE SEQUENCE secretquestions_secretquestions_id_seq
2544    START WITH 1
2545    INCREMENT BY 1
2546    NO MINVALUE
2547    NO MAXVALUE
2548    CACHE 1;
2549
2550
2551ALTER TABLE secretquestions_secretquestions_id_seq OWNER TO hospital;
2552
2553--
2554-- Name: secretquestions_secretquestions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
2555--
2556
2557ALTER SEQUENCE secretquestions_secretquestions_id_seq OWNED BY secretquestions.secretquestions_id;
2558
2559
2560--
2561-- Name: speciality; Type: TABLE; Schema: public; Owner: hospital
2562--
2563
2564CREATE TABLE speciality (
2565    speciality_id integer NOT NULL,
2566    speciality_type_id integer NOT NULL,
2567    qualification_id integer NOT NULL,
2568    speciality character varying(225),
2569    sort_by integer,
2570    status_2 integer DEFAULT 1
2571);
2572
2573
2574ALTER TABLE speciality OWNER TO hospital;
2575
2576--
2577-- Name: speciality_speciality_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
2578--
2579
2580CREATE SEQUENCE speciality_speciality_id_seq
2581    START WITH 1
2582    INCREMENT BY 1
2583    NO MINVALUE
2584    NO MAXVALUE
2585    CACHE 1;
2586
2587
2588ALTER TABLE speciality_speciality_id_seq OWNER TO hospital;
2589
2590--
2591-- Name: speciality_speciality_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
2592--
2593
2594ALTER SEQUENCE speciality_speciality_id_seq OWNED BY speciality.speciality_id;
2595
2596
2597--
2598-- Name: speciality_type; Type: TABLE; Schema: public; Owner: hospital
2599--
2600
2601CREATE TABLE speciality_type (
2602    speciality_type_id integer NOT NULL,
2603    speciality_type_name character varying(225),
2604    sort_by integer,
2605    status_2 integer DEFAULT 1
2606);
2607
2608
2609ALTER TABLE speciality_type OWNER TO hospital;
2610
2611--
2612-- Name: speciality_type_speciality_type_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
2613--
2614
2615CREATE SEQUENCE speciality_type_speciality_type_id_seq
2616    START WITH 1
2617    INCREMENT BY 1
2618    NO MINVALUE
2619    NO MAXVALUE
2620    CACHE 1;
2621
2622
2623ALTER TABLE speciality_type_speciality_type_id_seq OWNER TO hospital;
2624
2625--
2626-- Name: speciality_type_speciality_type_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
2627--
2628
2629ALTER SEQUENCE speciality_type_speciality_type_id_seq OWNED BY speciality_type.speciality_type_id;
2630
2631
2632--
2633-- Name: sponsors; Type: TABLE; Schema: public; Owner: hospital
2634--
2635
2636CREATE TABLE sponsors (
2637    sponsors_id integer NOT NULL,
2638    sponsors_group_id integer NOT NULL,
2639    users_id integer NOT NULL,
2640    businessregtype_id integer NOT NULL,
2641    organizationname character varying(225),
2642    groupsize integer,
2643    designation character varying(225),
2644    image character varying(225),
2645    operatinghours character varying(225),
2646    oprtainglocation character varying(225),
2647    website character varying(225),
2648    requiredlocation character varying(225),
2649    activefrom timestamp without time zone,
2650    activeto timestamp without time zone
2651);
2652
2653
2654ALTER TABLE sponsors OWNER TO hospital;
2655
2656--
2657-- Name: sponsors_group; Type: TABLE; Schema: public; Owner: hospital
2658--
2659
2660CREATE TABLE sponsors_group (
2661    sponsors_group_id integer NOT NULL,
2662    sponsors_group character varying(225),
2663    sort_by integer,
2664    status_2 integer DEFAULT 1
2665);
2666
2667
2668ALTER TABLE sponsors_group OWNER TO hospital;
2669
2670--
2671-- Name: sponsors_group_sponsors_group_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
2672--
2673
2674CREATE SEQUENCE sponsors_group_sponsors_group_id_seq
2675    START WITH 1
2676    INCREMENT BY 1
2677    NO MINVALUE
2678    NO MAXVALUE
2679    CACHE 1;
2680
2681
2682ALTER TABLE sponsors_group_sponsors_group_id_seq OWNER TO hospital;
2683
2684--
2685-- Name: sponsors_group_sponsors_group_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
2686--
2687
2688ALTER SEQUENCE sponsors_group_sponsors_group_id_seq OWNED BY sponsors_group.sponsors_group_id;
2689
2690
2691--
2692-- Name: sponsors_sponsors_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
2693--
2694
2695CREATE SEQUENCE sponsors_sponsors_id_seq
2696    START WITH 1
2697    INCREMENT BY 1
2698    NO MINVALUE
2699    NO MAXVALUE
2700    CACHE 1;
2701
2702
2703ALTER TABLE sponsors_sponsors_id_seq OWNER TO hospital;
2704
2705--
2706-- Name: sponsors_sponsors_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
2707--
2708
2709ALTER SEQUENCE sponsors_sponsors_id_seq OWNED BY sponsors.sponsors_id;
2710
2711
2712--
2713-- Name: state; Type: TABLE; Schema: public; Owner: hospital
2714--
2715
2716CREATE TABLE state (
2717    state_id integer NOT NULL,
2718    state character varying(225),
2719    sort_by integer,
2720    status_2 integer DEFAULT 1
2721);
2722
2723
2724ALTER TABLE state OWNER TO hospital;
2725
2726--
2727-- Name: state_state_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
2728--
2729
2730CREATE SEQUENCE state_state_id_seq
2731    START WITH 1
2732    INCREMENT BY 1
2733    NO MINVALUE
2734    NO MAXVALUE
2735    CACHE 1;
2736
2737
2738ALTER TABLE state_state_id_seq OWNER TO hospital;
2739
2740--
2741-- Name: state_state_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
2742--
2743
2744ALTER SEQUENCE state_state_id_seq OWNED BY state.state_id;
2745
2746
2747--
2748-- Name: symptoms; Type: TABLE; Schema: public; Owner: hospital
2749--
2750
2751CREATE TABLE symptoms (
2752    symptoms_id integer NOT NULL,
2753    speciality_id integer NOT NULL,
2754    symptoms character varying(225),
2755    sort_by integer,
2756    status_2 integer DEFAULT 1
2757);
2758
2759
2760ALTER TABLE symptoms OWNER TO hospital;
2761
2762--
2763-- Name: symptoms_symptoms_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
2764--
2765
2766CREATE SEQUENCE symptoms_symptoms_id_seq
2767    START WITH 1
2768    INCREMENT BY 1
2769    NO MINVALUE
2770    NO MAXVALUE
2771    CACHE 1;
2772
2773
2774ALTER TABLE symptoms_symptoms_id_seq OWNER TO hospital;
2775
2776--
2777-- Name: symptoms_symptoms_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
2778--
2779
2780ALTER SEQUENCE symptoms_symptoms_id_seq OWNED BY symptoms.symptoms_id;
2781
2782
2783--
2784-- Name: telephone; Type: TABLE; Schema: public; Owner: hospital
2785--
2786
2787CREATE TABLE telephone (
2788    telephone_id integer NOT NULL,
2789    address_id integer NOT NULL,
2790    phone integer,
2791    sort_by integer,
2792    status_2 integer DEFAULT 1
2793);
2794
2795
2796ALTER TABLE telephone OWNER TO hospital;
2797
2798--
2799-- Name: telephone_telephone_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
2800--
2801
2802CREATE SEQUENCE telephone_telephone_id_seq
2803    START WITH 1
2804    INCREMENT BY 1
2805    NO MINVALUE
2806    NO MAXVALUE
2807    CACHE 1;
2808
2809
2810ALTER TABLE telephone_telephone_id_seq OWNER TO hospital;
2811
2812--
2813-- Name: telephone_telephone_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
2814--
2815
2816ALTER SEQUENCE telephone_telephone_id_seq OWNED BY telephone.telephone_id;
2817
2818
2819--
2820-- Name: test; Type: TABLE; Schema: public; Owner: hospital
2821--
2822
2823CREATE TABLE test (
2824    test_id integer NOT NULL,
2825    test_subcategory_id integer NOT NULL,
2826    test_category_id integer NOT NULL,
2827    test character varying(225),
2828    description character varying(225)
2829);
2830
2831
2832ALTER TABLE test OWNER TO hospital;
2833
2834--
2835-- Name: test_category; Type: TABLE; Schema: public; Owner: hospital
2836--
2837
2838CREATE TABLE test_category (
2839    test_category_id integer NOT NULL,
2840    test_category character varying(225),
2841    description character varying(225)
2842);
2843
2844
2845ALTER TABLE test_category OWNER TO hospital;
2846
2847--
2848-- Name: test_category_test_category_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
2849--
2850
2851CREATE SEQUENCE test_category_test_category_id_seq
2852    START WITH 1
2853    INCREMENT BY 1
2854    NO MINVALUE
2855    NO MAXVALUE
2856    CACHE 1;
2857
2858
2859ALTER TABLE test_category_test_category_id_seq OWNER TO hospital;
2860
2861--
2862-- Name: test_category_test_category_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
2863--
2864
2865ALTER SEQUENCE test_category_test_category_id_seq OWNED BY test_category.test_category_id;
2866
2867
2868--
2869-- Name: test_subcategory; Type: TABLE; Schema: public; Owner: hospital
2870--
2871
2872CREATE TABLE test_subcategory (
2873    test_subcategory_id integer NOT NULL,
2874    test_category_id integer NOT NULL,
2875    subcategory character varying(225),
2876    description character varying(225)
2877);
2878
2879
2880ALTER TABLE test_subcategory OWNER TO hospital;
2881
2882--
2883-- Name: test_subcategory_test_subcategory_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
2884--
2885
2886CREATE SEQUENCE test_subcategory_test_subcategory_id_seq
2887    START WITH 1
2888    INCREMENT BY 1
2889    NO MINVALUE
2890    NO MAXVALUE
2891    CACHE 1;
2892
2893
2894ALTER TABLE test_subcategory_test_subcategory_id_seq OWNER TO hospital;
2895
2896--
2897-- Name: test_subcategory_test_subcategory_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
2898--
2899
2900ALTER SEQUENCE test_subcategory_test_subcategory_id_seq OWNED BY test_subcategory.test_subcategory_id;
2901
2902
2903--
2904-- Name: test_test_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
2905--
2906
2907CREATE SEQUENCE test_test_id_seq
2908    START WITH 1
2909    INCREMENT BY 1
2910    NO MINVALUE
2911    NO MAXVALUE
2912    CACHE 1;
2913
2914
2915ALTER TABLE test_test_id_seq OWNER TO hospital;
2916
2917--
2918-- Name: test_test_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
2919--
2920
2921ALTER SEQUENCE test_test_id_seq OWNED BY test.test_id;
2922
2923
2924--
2925-- Name: testimonials; Type: TABLE; Schema: public; Owner: hospital
2926--
2927
2928CREATE TABLE testimonials (
2929    testimonials_id integer NOT NULL,
2930    users_id integer NOT NULL,
2931    testimonial character varying(225),
2932    image character varying(225),
2933    video character varying(225),
2934    status_2 integer DEFAULT 0,
2935    activefrom timestamp without time zone,
2936    activeto timestamp without time zone,
2937    reg_date timestamp without time zone
2938);
2939
2940
2941ALTER TABLE testimonials OWNER TO hospital;
2942
2943--
2944-- Name: testimonials_testimonials_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
2945--
2946
2947CREATE SEQUENCE testimonials_testimonials_id_seq
2948    START WITH 1
2949    INCREMENT BY 1
2950    NO MINVALUE
2951    NO MAXVALUE
2952    CACHE 1;
2953
2954
2955ALTER TABLE testimonials_testimonials_id_seq OWNER TO hospital;
2956
2957--
2958-- Name: testimonials_testimonials_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
2959--
2960
2961ALTER SEQUENCE testimonials_testimonials_id_seq OWNED BY testimonials.testimonials_id;
2962
2963
2964--
2965-- Name: timeslots; Type: TABLE; Schema: public; Owner: hospital
2966--
2967
2968CREATE TABLE timeslots (
2969    timeslots_id integer NOT NULL,
2970    timeslots character varying(225),
2971    fromslot time without time zone,
2972    toslot time without time zone,
2973    sort_by integer,
2974    status_2 integer DEFAULT 1
2975);
2976
2977
2978ALTER TABLE timeslots OWNER TO hospital;
2979
2980--
2981-- Name: timeslots_timeslots_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
2982--
2983
2984CREATE SEQUENCE timeslots_timeslots_id_seq
2985    START WITH 1
2986    INCREMENT BY 1
2987    NO MINVALUE
2988    NO MAXVALUE
2989    CACHE 1;
2990
2991
2992ALTER TABLE timeslots_timeslots_id_seq OWNER TO hospital;
2993
2994--
2995-- Name: timeslots_timeslots_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
2996--
2997
2998ALTER SEQUENCE timeslots_timeslots_id_seq OWNED BY timeslots.timeslots_id;
2999
3000
3001--
3002-- Name: trxn_appointmentbookings; Type: TABLE; Schema: public; Owner: hospital
3003--
3004
3005CREATE TABLE trxn_appointmentbookings (
3006    trxn_appointmentbookings_id integer NOT NULL,
3007    appointmentbooking_date date NOT NULL,
3008    appointmentbooking_id integer NOT NULL,
3009    status_2 character varying(225),
3010    session_activity integer DEFAULT 1,
3011    ip character varying(225),
3012    trxn_by integer,
3013    reg_date timestamp without time zone
3014);
3015
3016
3017ALTER TABLE trxn_appointmentbookings OWNER TO hospital;
3018
3019--
3020-- Name: trxn_appointmentbookings_trxn_appointmentbookings_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
3021--
3022
3023CREATE SEQUENCE trxn_appointmentbookings_trxn_appointmentbookings_id_seq
3024    START WITH 1
3025    INCREMENT BY 1
3026    NO MINVALUE
3027    NO MAXVALUE
3028    CACHE 1;
3029
3030
3031ALTER TABLE trxn_appointmentbookings_trxn_appointmentbookings_id_seq OWNER TO hospital;
3032
3033--
3034-- Name: trxn_appointmentbookings_trxn_appointmentbookings_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
3035--
3036
3037ALTER SEQUENCE trxn_appointmentbookings_trxn_appointmentbookings_id_seq OWNED BY trxn_appointmentbookings.trxn_appointmentbookings_id;
3038
3039
3040--
3041-- Name: trxn_coupons; Type: TABLE; Schema: public; Owner: hospital
3042--
3043
3044CREATE TABLE trxn_coupons (
3045    trxn_coupons_id integer NOT NULL,
3046    coupons_id integer NOT NULL,
3047    status_2 character varying(225),
3048    sessionactivity integer DEFAULT 1,
3049    ip character varying(225),
3050    trxn_by integer,
3051    reg_date timestamp without time zone
3052);
3053
3054
3055ALTER TABLE trxn_coupons OWNER TO hospital;
3056
3057--
3058-- Name: trxn_coupons_trxn_coupons_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
3059--
3060
3061CREATE SEQUENCE trxn_coupons_trxn_coupons_id_seq
3062    START WITH 1
3063    INCREMENT BY 1
3064    NO MINVALUE
3065    NO MAXVALUE
3066    CACHE 1;
3067
3068
3069ALTER TABLE trxn_coupons_trxn_coupons_id_seq OWNER TO hospital;
3070
3071--
3072-- Name: trxn_coupons_trxn_coupons_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
3073--
3074
3075ALTER SEQUENCE trxn_coupons_trxn_coupons_id_seq OWNED BY trxn_coupons.trxn_coupons_id;
3076
3077
3078--
3079-- Name: trxn_discountcard; Type: TABLE; Schema: public; Owner: hospital
3080--
3081
3082CREATE TABLE trxn_discountcard (
3083    trxn_discountcard_id integer NOT NULL,
3084    discountcard_id integer NOT NULL,
3085    status_2 character varying(225),
3086    sessionactivity integer DEFAULT 1,
3087    ip character varying(225),
3088    trxn_by integer,
3089    reg_date timestamp without time zone
3090);
3091
3092
3093ALTER TABLE trxn_discountcard OWNER TO hospital;
3094
3095--
3096-- Name: trxn_discountcard_trxn_discountcard_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
3097--
3098
3099CREATE SEQUENCE trxn_discountcard_trxn_discountcard_id_seq
3100    START WITH 1
3101    INCREMENT BY 1
3102    NO MINVALUE
3103    NO MAXVALUE
3104    CACHE 1;
3105
3106
3107ALTER TABLE trxn_discountcard_trxn_discountcard_id_seq OWNER TO hospital;
3108
3109--
3110-- Name: trxn_discountcard_trxn_discountcard_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
3111--
3112
3113ALTER SEQUENCE trxn_discountcard_trxn_discountcard_id_seq OWNED BY trxn_discountcard.trxn_discountcard_id;
3114
3115
3116--
3117-- Name: trxn_healthcheckbooking; Type: TABLE; Schema: public; Owner: hospital
3118--
3119
3120CREATE TABLE trxn_healthcheckbooking (
3121    trxn_healthcheckbooking_id integer NOT NULL,
3122    healthcheckbooking_id integer NOT NULL,
3123    status_2 character varying(225),
3124    sessionactivity integer DEFAULT 1,
3125    ip character varying(225),
3126    trxn_by integer,
3127    reg_date timestamp without time zone
3128);
3129
3130
3131ALTER TABLE trxn_healthcheckbooking OWNER TO hospital;
3132
3133--
3134-- Name: trxn_healthcheckbooking_trxn_healthcheckbooking_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
3135--
3136
3137CREATE SEQUENCE trxn_healthcheckbooking_trxn_healthcheckbooking_id_seq
3138    START WITH 1
3139    INCREMENT BY 1
3140    NO MINVALUE
3141    NO MAXVALUE
3142    CACHE 1;
3143
3144
3145ALTER TABLE trxn_healthcheckbooking_trxn_healthcheckbooking_id_seq OWNER TO hospital;
3146
3147--
3148-- Name: trxn_healthcheckbooking_trxn_healthcheckbooking_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
3149--
3150
3151ALTER SEQUENCE trxn_healthcheckbooking_trxn_healthcheckbooking_id_seq OWNED BY trxn_healthcheckbooking.trxn_healthcheckbooking_id;
3152
3153
3154--
3155-- Name: trxn_payments; Type: TABLE; Schema: public; Owner: hospital
3156--
3157
3158CREATE TABLE trxn_payments (
3159    trxn_payments_id integer NOT NULL,
3160    amount integer,
3161    status_2 character varying(225),
3162    paymentfor character varying(225),
3163    for_id integer,
3164    ip character varying(225),
3165    trxn_by integer,
3166    reg_date timestamp without time zone
3167);
3168
3169
3170ALTER TABLE trxn_payments OWNER TO hospital;
3171
3172--
3173-- Name: trxn_payments_trxn_payments_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
3174--
3175
3176CREATE SEQUENCE trxn_payments_trxn_payments_id_seq
3177    START WITH 1
3178    INCREMENT BY 1
3179    NO MINVALUE
3180    NO MAXVALUE
3181    CACHE 1;
3182
3183
3184ALTER TABLE trxn_payments_trxn_payments_id_seq OWNER TO hospital;
3185
3186--
3187-- Name: trxn_payments_trxn_payments_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
3188--
3189
3190ALTER SEQUENCE trxn_payments_trxn_payments_id_seq OWNED BY trxn_payments.trxn_payments_id;
3191
3192
3193--
3194-- Name: users; Type: TABLE; Schema: public; Owner: hospital
3195--
3196
3197CREATE TABLE users (
3198    users_id integer NOT NULL,
3199    secretquestions_id integer NOT NULL,
3200    role_id integer NOT NULL,
3201    mobile integer NOT NULL,
3202    email character varying(225) NOT NULL,
3203    firstname character varying(225),
3204    lastname character varying(225),
3205    middlename character varying(225),
3206    enc_password character varying(225) NOT NULL,
3207    verified integer DEFAULT 0,
3208    pw_request integer DEFAULT 0,
3209    user_status integer DEFAULT 1,
3210    reg_date timestamp without time zone,
3211    reg_by integer,
3212    m_date timestamp without time zone,
3213    m_by integer,
3214    failure_attempts integer,
3215    secretanswer character varying(225),
3216    ipaddress character varying(225),
3217    macaddress character varying(225)
3218);
3219
3220
3221ALTER TABLE users OWNER TO hospital;
3222
3223--
3224-- Name: users_users_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
3225--
3226
3227CREATE SEQUENCE users_users_id_seq
3228    START WITH 1
3229    INCREMENT BY 1
3230    NO MINVALUE
3231    NO MAXVALUE
3232    CACHE 1;
3233
3234
3235ALTER TABLE users_users_id_seq OWNER TO hospital;
3236
3237--
3238-- Name: users_users_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
3239--
3240
3241ALTER SEQUENCE users_users_id_seq OWNED BY users.users_id;
3242
3243
3244--
3245-- Name: week; Type: TABLE; Schema: public; Owner: hospital
3246--
3247
3248CREATE TABLE week (
3249    week_id integer NOT NULL,
3250    week character varying(225),
3251    sort_by integer,
3252    status_2 integer DEFAULT 1
3253);
3254
3255
3256ALTER TABLE week OWNER TO hospital;
3257
3258--
3259-- Name: week_week_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
3260--
3261
3262CREATE SEQUENCE week_week_id_seq
3263    START WITH 1
3264    INCREMENT BY 1
3265    NO MINVALUE
3266    NO MAXVALUE
3267    CACHE 1;
3268
3269
3270ALTER TABLE week_week_id_seq OWNER TO hospital;
3271
3272--
3273-- Name: week_week_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
3274--
3275
3276ALTER SEQUENCE week_week_id_seq OWNED BY week.week_id;
3277
3278
3279--
3280-- Name: wellnessplan; Type: TABLE; Schema: public; Owner: hospital
3281--
3282
3283CREATE TABLE wellnessplan (
3284    wellnessplan_id integer NOT NULL,
3285    wellnessplan_socialhistory_id integer NOT NULL,
3286    wellnessplan_profession_id integer NOT NULL,
3287    conditions_id integer NOT NULL,
3288    agegroup_id integer NOT NULL,
3289    medicalhistory character varying(225),
3290    surgicalhistory character varying(225)
3291);
3292
3293
3294ALTER TABLE wellnessplan OWNER TO hospital;
3295
3296--
3297-- Name: wellnessplan_profession; Type: TABLE; Schema: public; Owner: hospital
3298--
3299
3300CREATE TABLE wellnessplan_profession (
3301    wellnessplan_profession_id integer NOT NULL,
3302    wellnessplan_profession character varying(225),
3303    sort_by integer,
3304    status_2 integer DEFAULT 1
3305);
3306
3307
3308ALTER TABLE wellnessplan_profession OWNER TO hospital;
3309
3310--
3311-- Name: wellnessplan_profession_wellnessplan_profession_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
3312--
3313
3314CREATE SEQUENCE wellnessplan_profession_wellnessplan_profession_id_seq
3315    START WITH 1
3316    INCREMENT BY 1
3317    NO MINVALUE
3318    NO MAXVALUE
3319    CACHE 1;
3320
3321
3322ALTER TABLE wellnessplan_profession_wellnessplan_profession_id_seq OWNER TO hospital;
3323
3324--
3325-- Name: wellnessplan_profession_wellnessplan_profession_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
3326--
3327
3328ALTER SEQUENCE wellnessplan_profession_wellnessplan_profession_id_seq OWNED BY wellnessplan_profession.wellnessplan_profession_id;
3329
3330
3331--
3332-- Name: wellnessplan_socialhistory; Type: TABLE; Schema: public; Owner: hospital
3333--
3334
3335CREATE TABLE wellnessplan_socialhistory (
3336    wellnessplan_socialhistory_id integer NOT NULL,
3337    wellnessplan_socialhistory character varying(225),
3338    sort_by integer,
3339    status_2 integer DEFAULT 1
3340);
3341
3342
3343ALTER TABLE wellnessplan_socialhistory OWNER TO hospital;
3344
3345--
3346-- Name: wellnessplan_socialhistory_wellnessplan_socialhistory_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
3347--
3348
3349CREATE SEQUENCE wellnessplan_socialhistory_wellnessplan_socialhistory_id_seq
3350    START WITH 1
3351    INCREMENT BY 1
3352    NO MINVALUE
3353    NO MAXVALUE
3354    CACHE 1;
3355
3356
3357ALTER TABLE wellnessplan_socialhistory_wellnessplan_socialhistory_id_seq OWNER TO hospital;
3358
3359--
3360-- Name: wellnessplan_socialhistory_wellnessplan_socialhistory_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
3361--
3362
3363ALTER SEQUENCE wellnessplan_socialhistory_wellnessplan_socialhistory_id_seq OWNED BY wellnessplan_socialhistory.wellnessplan_socialhistory_id;
3364
3365
3366--
3367-- Name: wellnessplan_wellnessplan_id_seq; Type: SEQUENCE; Schema: public; Owner: hospital
3368--
3369
3370CREATE SEQUENCE wellnessplan_wellnessplan_id_seq
3371    START WITH 1
3372    INCREMENT BY 1
3373    NO MINVALUE
3374    NO MAXVALUE
3375    CACHE 1;
3376
3377
3378ALTER TABLE wellnessplan_wellnessplan_id_seq OWNER TO hospital;
3379
3380--
3381-- Name: wellnessplan_wellnessplan_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hospital
3382--
3383
3384ALTER SEQUENCE wellnessplan_wellnessplan_id_seq OWNED BY wellnessplan.wellnessplan_id;
3385
3386
3387--
3388-- Name: address address_id; Type: DEFAULT; Schema: public; Owner: hospital
3389--
3390
3391ALTER TABLE ONLY address ALTER COLUMN address_id SET DEFAULT nextval('address_address_id_seq'::regclass);
3392
3393
3394--
3395-- Name: agegroup agegroup_id; Type: DEFAULT; Schema: public; Owner: hospital
3396--
3397
3398ALTER TABLE ONLY agegroup ALTER COLUMN agegroup_id SET DEFAULT nextval('agegroup_agegroup_id_seq'::regclass);
3399
3400
3401--
3402-- Name: alertsources alertsources_id; Type: DEFAULT; Schema: public; Owner: hospital
3403--
3404
3405ALTER TABLE ONLY alertsources ALTER COLUMN alertsources_id SET DEFAULT nextval('alertsources_alertsources_id_seq'::regclass);
3406
3407
3408--
3409-- Name: alerttype alerttype_id; Type: DEFAULT; Schema: public; Owner: hospital
3410--
3411
3412ALTER TABLE ONLY alerttype ALTER COLUMN alerttype_id SET DEFAULT nextval('alerttype_alerttype_id_seq'::regclass);
3413
3414
3415--
3416-- Name: appointmentbooking appointmentbooking_id; Type: DEFAULT; Schema: public; Owner: hospital
3417--
3418
3419ALTER TABLE ONLY appointmentbooking ALTER COLUMN appointmentbooking_id SET DEFAULT nextval('appointmentbooking_appointmentbooking_id_seq'::regclass);
3420
3421
3422--
3423-- Name: auth_group id; Type: DEFAULT; Schema: public; Owner: hospital
3424--
3425
3426ALTER TABLE ONLY auth_group ALTER COLUMN id SET DEFAULT nextval('auth_group_id_seq'::regclass);
3427
3428
3429--
3430-- Name: auth_group_permissions id; Type: DEFAULT; Schema: public; Owner: hospital
3431--
3432
3433ALTER TABLE ONLY auth_group_permissions ALTER COLUMN id SET DEFAULT nextval('auth_group_permissions_id_seq'::regclass);
3434
3435
3436--
3437-- Name: auth_permission id; Type: DEFAULT; Schema: public; Owner: hospital
3438--
3439
3440ALTER TABLE ONLY auth_permission ALTER COLUMN id SET DEFAULT nextval('auth_permission_id_seq'::regclass);
3441
3442
3443--
3444-- Name: auth_user id; Type: DEFAULT; Schema: public; Owner: hospital
3445--
3446
3447ALTER TABLE ONLY auth_user ALTER COLUMN id SET DEFAULT nextval('auth_user_id_seq'::regclass);
3448
3449
3450--
3451-- Name: auth_user_groups id; Type: DEFAULT; Schema: public; Owner: hospital
3452--
3453
3454ALTER TABLE ONLY auth_user_groups ALTER COLUMN id SET DEFAULT nextval('auth_user_groups_id_seq'::regclass);
3455
3456
3457--
3458-- Name: auth_user_user_permissions id; Type: DEFAULT; Schema: public; Owner: hospital
3459--
3460
3461ALTER TABLE ONLY auth_user_user_permissions ALTER COLUMN id SET DEFAULT nextval('auth_user_user_permissions_id_seq'::regclass);
3462
3463
3464--
3465-- Name: availablefacilities availablefacilities_id; Type: DEFAULT; Schema: public; Owner: hospital
3466--
3467
3468ALTER TABLE ONLY availablefacilities ALTER COLUMN availablefacilities_id SET DEFAULT nextval('availablefacilities_availablefacilities_id_seq'::regclass);
3469
3470
3471--
3472-- Name: bookingsources bookingsources_id; Type: DEFAULT; Schema: public; Owner: hospital
3473--
3474
3475ALTER TABLE ONLY bookingsources ALTER COLUMN bookingsources_id SET DEFAULT nextval('bookingsources_bookingsources_id_seq'::regclass);
3476
3477
3478--
3479-- Name: businessregtype businessregtype_id; Type: DEFAULT; Schema: public; Owner: hospital
3480--
3481
3482ALTER TABLE ONLY businessregtype ALTER COLUMN businessregtype_id SET DEFAULT nextval('businessregtype_businessregtype_id_seq'::regclass);
3483
3484
3485--
3486-- Name: city city_id; Type: DEFAULT; Schema: public; Owner: hospital
3487--
3488
3489ALTER TABLE ONLY city ALTER COLUMN city_id SET DEFAULT nextval('city_city_id_seq'::regclass);
3490
3491
3492--
3493-- Name: clinician_memberships clinician_memberships_id; Type: DEFAULT; Schema: public; Owner: hospital
3494--
3495
3496ALTER TABLE ONLY clinician_memberships ALTER COLUMN clinician_memberships_id SET DEFAULT nextval('clinician_memberships_clinician_memberships_id_seq'::regclass);
3497
3498
3499--
3500-- Name: clinicians clinicians_id; Type: DEFAULT; Schema: public; Owner: hospital
3501--
3502
3503ALTER TABLE ONLY clinicians ALTER COLUMN clinicians_id SET DEFAULT nextval('clinicians_clinicians_id_seq'::regclass);
3504
3505
3506--
3507-- Name: clinicians_dates clinicians_dates_id; Type: DEFAULT; Schema: public; Owner: hospital
3508--
3509
3510ALTER TABLE ONLY clinicians_dates ALTER COLUMN clinicians_dates_id SET DEFAULT nextval('clinicians_dates_clinicians_dates_id_seq'::regclass);
3511
3512
3513--
3514-- Name: clinicians_education clinicians_education_id; Type: DEFAULT; Schema: public; Owner: hospital
3515--
3516
3517ALTER TABLE ONLY clinicians_education ALTER COLUMN clinicians_education_id SET DEFAULT nextval('clinicians_education_clinicians_education_id_seq'::regclass);
3518
3519
3520--
3521-- Name: clinicians_experience clinicians_experience_id; Type: DEFAULT; Schema: public; Owner: hospital
3522--
3523
3524ALTER TABLE ONLY clinicians_experience ALTER COLUMN clinicians_experience_id SET DEFAULT nextval('clinicians_experience_clinicians_experience_id_seq'::regclass);
3525
3526
3527--
3528-- Name: clinicians_speciality clinicians_speciality_id; Type: DEFAULT; Schema: public; Owner: hospital
3529--
3530
3531ALTER TABLE ONLY clinicians_speciality ALTER COLUMN clinicians_speciality_id SET DEFAULT nextval('clinicians_speciality_clinicians_speciality_id_seq'::regclass);
3532
3533
3534--
3535-- Name: conditions conditions_id; Type: DEFAULT; Schema: public; Owner: hospital
3536--
3537
3538ALTER TABLE ONLY conditions ALTER COLUMN conditions_id SET DEFAULT nextval('conditions_conditions_id_seq'::regclass);
3539
3540
3541--
3542-- Name: country country_id; Type: DEFAULT; Schema: public; Owner: hospital
3543--
3544
3545ALTER TABLE ONLY country ALTER COLUMN country_id SET DEFAULT nextval('country_country_id_seq'::regclass);
3546
3547
3548--
3549-- Name: couponaccept couponaccept_id; Type: DEFAULT; Schema: public; Owner: hospital
3550--
3551
3552ALTER TABLE ONLY couponaccept ALTER COLUMN couponaccept_id SET DEFAULT nextval('couponaccept_couponaccept_id_seq'::regclass);
3553
3554
3555--
3556-- Name: coupons coupons_id; Type: DEFAULT; Schema: public; Owner: hospital
3557--
3558
3559ALTER TABLE ONLY coupons ALTER COLUMN coupons_id SET DEFAULT nextval('coupons_coupons_id_seq'::regclass);
3560
3561
3562--
3563-- Name: designation designation_id; Type: DEFAULT; Schema: public; Owner: hospital
3564--
3565
3566ALTER TABLE ONLY designation ALTER COLUMN designation_id SET DEFAULT nextval('designation_designation_id_seq'::regclass);
3567
3568
3569--
3570-- Name: discountcard discountcard_id; Type: DEFAULT; Schema: public; Owner: hospital
3571--
3572
3573ALTER TABLE ONLY discountcard ALTER COLUMN discountcard_id SET DEFAULT nextval('discountcard_discountcard_id_seq'::regclass);
3574
3575
3576--
3577-- Name: discountcard_family discountcard_family_id; Type: DEFAULT; Schema: public; Owner: hospital
3578--
3579
3580ALTER TABLE ONLY discountcard_family ALTER COLUMN discountcard_family_id SET DEFAULT nextval('discountcard_family_discountcard_family_id_seq'::regclass);
3581
3582
3583--
3584-- Name: discountcard_family_extra discountcard_family_extra_id; Type: DEFAULT; Schema: public; Owner: hospital
3585--
3586
3587ALTER TABLE ONLY discountcard_family_extra ALTER COLUMN discountcard_family_extra_id SET DEFAULT nextval('discountcard_family_extra_discountcard_family_extra_id_seq'::regclass);
3588
3589
3590--
3591-- Name: district district_id; Type: DEFAULT; Schema: public; Owner: hospital
3592--
3593
3594ALTER TABLE ONLY district ALTER COLUMN district_id SET DEFAULT nextval('district_district_id_seq'::regclass);
3595
3596
3597--
3598-- Name: django_admin_log id; Type: DEFAULT; Schema: public; Owner: hospital
3599--
3600
3601ALTER TABLE ONLY django_admin_log ALTER COLUMN id SET DEFAULT nextval('django_admin_log_id_seq'::regclass);
3602
3603
3604--
3605-- Name: django_content_type id; Type: DEFAULT; Schema: public; Owner: hospital
3606--
3607
3608ALTER TABLE ONLY django_content_type ALTER COLUMN id SET DEFAULT nextval('django_content_type_id_seq'::regclass);
3609
3610
3611--
3612-- Name: django_migrations id; Type: DEFAULT; Schema: public; Owner: hospital
3613--
3614
3615ALTER TABLE ONLY django_migrations ALTER COLUMN id SET DEFAULT nextval('django_migrations_id_seq'::regclass);
3616
3617
3618--
3619-- Name: facilities facilities_id; Type: DEFAULT; Schema: public; Owner: hospital
3620--
3621
3622ALTER TABLE ONLY facilities ALTER COLUMN facilities_id SET DEFAULT nextval('facilities_facilities_id_seq'::regclass);
3623
3624
3625--
3626-- Name: facilities_services facilities_services_id; Type: DEFAULT; Schema: public; Owner: hospital
3627--
3628
3629ALTER TABLE ONLY facilities_services ALTER COLUMN facilities_services_id SET DEFAULT nextval('facilities_services_facilities_services_id_seq'::regclass);
3630
3631
3632--
3633-- Name: family family_id; Type: DEFAULT; Schema: public; Owner: hospital
3634--
3635
3636ALTER TABLE ONLY family ALTER COLUMN family_id SET DEFAULT nextval('family_family_id_seq'::regclass);
3637
3638
3639--
3640-- Name: feedback feedback_id; Type: DEFAULT; Schema: public; Owner: hospital
3641--
3642
3643ALTER TABLE ONLY feedback ALTER COLUMN feedback_id SET DEFAULT nextval('feedback_feedback_id_seq'::regclass);
3644
3645
3646--
3647-- Name: gender gender_id; Type: DEFAULT; Schema: public; Owner: hospital
3648--
3649
3650ALTER TABLE ONLY gender ALTER COLUMN gender_id SET DEFAULT nextval('gender_gender_id_seq'::regclass);
3651
3652
3653--
3654-- Name: healthcheckbooking healthcheckbooking_id; Type: DEFAULT; Schema: public; Owner: hospital
3655--
3656
3657ALTER TABLE ONLY healthcheckbooking ALTER COLUMN healthcheckbooking_id SET DEFAULT nextval('healthcheckbooking_healthcheckbooking_id_seq'::regclass);
3658
3659
3660--
3661-- Name: healthchecks healthchecks_id; Type: DEFAULT; Schema: public; Owner: hospital
3662--
3663
3664ALTER TABLE ONLY healthchecks ALTER COLUMN healthchecks_id SET DEFAULT nextval('healthchecks_healthchecks_id_seq'::regclass);
3665
3666
3667--
3668-- Name: healthchecks_inclusion healthchecks_inclusion_id; Type: DEFAULT; Schema: public; Owner: hospital
3669--
3670
3671ALTER TABLE ONLY healthchecks_inclusion ALTER COLUMN healthchecks_inclusion_id SET DEFAULT nextval('healthchecks_inclusion_healthchecks_inclusion_id_seq'::regclass);
3672
3673
3674--
3675-- Name: healthproviders healthproviders_id; Type: DEFAULT; Schema: public; Owner: hospital
3676--
3677
3678ALTER TABLE ONLY healthproviders ALTER COLUMN healthproviders_id SET DEFAULT nextval('healthproviders_healthproviders_id_seq'::regclass);
3679
3680
3681--
3682-- Name: healthproviders_speciality healthproviders_speciality_id; Type: DEFAULT; Schema: public; Owner: hospital
3683--
3684
3685ALTER TABLE ONLY healthproviders_speciality ALTER COLUMN healthproviders_speciality_id SET DEFAULT nextval('healthproviders_speciality_healthproviders_speciality_id_seq'::regclass);
3686
3687
3688--
3689-- Name: healthrecords healthrecords_id; Type: DEFAULT; Schema: public; Owner: hospital
3690--
3691
3692ALTER TABLE ONLY healthrecords ALTER COLUMN healthrecords_id SET DEFAULT nextval('healthrecords_healthrecords_id_seq'::regclass);
3693
3694
3695--
3696-- Name: healthseeker healthseeker_id; Type: DEFAULT; Schema: public; Owner: hospital
3697--
3698
3699ALTER TABLE ONLY healthseeker ALTER COLUMN healthseeker_id SET DEFAULT nextval('healthseeker_healthseeker_id_seq'::regclass);
3700
3701
3702--
3703-- Name: healthseeker_alerts healthseeker_alerts_id; Type: DEFAULT; Schema: public; Owner: hospital
3704--
3705
3706ALTER TABLE ONLY healthseeker_alerts ALTER COLUMN healthseeker_alerts_id SET DEFAULT nextval('healthseeker_alerts_healthseeker_alerts_id_seq'::regclass);
3707
3708
3709--
3710-- Name: healthseeker_availabilities healthseeker_availabilities_id; Type: DEFAULT; Schema: public; Owner: hospital
3711--
3712
3713ALTER TABLE ONLY healthseeker_availabilities ALTER COLUMN healthseeker_availabilities_id SET DEFAULT nextval('healthseeker_availabilities_healthseeker_availabilities_id_seq'::regclass);
3714
3715
3716--
3717-- Name: healthseeker_healthrecords healthseeker_healthrecords_id; Type: DEFAULT; Schema: public; Owner: hospital
3718--
3719
3720ALTER TABLE ONLY healthseeker_healthrecords ALTER COLUMN healthseeker_healthrecords_id SET DEFAULT nextval('healthseeker_healthrecords_healthseeker_healthrecords_id_seq'::regclass);
3721
3722
3723--
3724-- Name: healthseeker_type healthseeker_type_id; Type: DEFAULT; Schema: public; Owner: hospital
3725--
3726
3727ALTER TABLE ONLY healthseeker_type ALTER COLUMN healthseeker_type_id SET DEFAULT nextval('healthseeker_type_healthseeker_type_id_seq'::regclass);
3728
3729
3730--
3731-- Name: interest interest_id; Type: DEFAULT; Schema: public; Owner: hospital
3732--
3733
3734ALTER TABLE ONLY interest ALTER COLUMN interest_id SET DEFAULT nextval('interest_interest_id_seq'::regclass);
3735
3736
3737--
3738-- Name: languages languages_id; Type: DEFAULT; Schema: public; Owner: hospital
3739--
3740
3741ALTER TABLE ONLY languages ALTER COLUMN languages_id SET DEFAULT nextval('languages_languages_id_seq'::regclass);
3742
3743
3744--
3745-- Name: photoalbum photoalbum_id; Type: DEFAULT; Schema: public; Owner: hospital
3746--
3747
3748ALTER TABLE ONLY photoalbum ALTER COLUMN photoalbum_id SET DEFAULT nextval('photoalbum_photoalbum_id_seq'::regclass);
3749
3750
3751--
3752-- Name: plans plans_id; Type: DEFAULT; Schema: public; Owner: hospital
3753--
3754
3755ALTER TABLE ONLY plans ALTER COLUMN plans_id SET DEFAULT nextval('plans_plans_id_seq'::regclass);
3756
3757
3758--
3759-- Name: plans_groups plans_groups_id; Type: DEFAULT; Schema: public; Owner: hospital
3760--
3761
3762ALTER TABLE ONLY plans_groups ALTER COLUMN plans_groups_id SET DEFAULT nextval('plans_groups_plans_groups_id_seq'::regclass);
3763
3764
3765--
3766-- Name: plans_groups_specialities plans_groups_specialities_id; Type: DEFAULT; Schema: public; Owner: hospital
3767--
3768
3769ALTER TABLE ONLY plans_groups_specialities ALTER COLUMN plans_groups_specialities_id SET DEFAULT nextval('plans_groups_specialities_plans_groups_specialities_id_seq'::regclass);
3770
3771
3772--
3773-- Name: priyority priyority_id; Type: DEFAULT; Schema: public; Owner: hospital
3774--
3775
3776ALTER TABLE ONLY priyority ALTER COLUMN priyority_id SET DEFAULT nextval('priyority_priyority_id_seq'::regclass);
3777
3778
3779--
3780-- Name: profession profession_id; Type: DEFAULT; Schema: public; Owner: hospital
3781--
3782
3783ALTER TABLE ONLY profession ALTER COLUMN profession_id SET DEFAULT nextval('profession_profession_id_seq'::regclass);
3784
3785
3786--
3787-- Name: qualification qualification_id; Type: DEFAULT; Schema: public; Owner: hospital
3788--
3789
3790ALTER TABLE ONLY qualification ALTER COLUMN qualification_id SET DEFAULT nextval('qualification_qualification_id_seq'::regclass);
3791
3792
3793--
3794-- Name: referrels referrels_id; Type: DEFAULT; Schema: public; Owner: hospital
3795--
3796
3797ALTER TABLE ONLY referrels ALTER COLUMN referrels_id SET DEFAULT nextval('referrels_referrels_id_seq'::regclass);
3798
3799
3800--
3801-- Name: referrelscheme referrelscheme_id; Type: DEFAULT; Schema: public; Owner: hospital
3802--
3803
3804ALTER TABLE ONLY referrelscheme ALTER COLUMN referrelscheme_id SET DEFAULT nextval('referrelscheme_referrelscheme_id_seq'::regclass);
3805
3806
3807--
3808-- Name: registration_welcome_message registration_welcome_message_id; Type: DEFAULT; Schema: public; Owner: hospital
3809--
3810
3811ALTER TABLE ONLY registration_welcome_message ALTER COLUMN registration_welcome_message_id SET DEFAULT nextval('registration_welcome_message_registration_welcome_message_i_seq'::regclass);
3812
3813
3814--
3815-- Name: resellerpackages resellerpackages_id; Type: DEFAULT; Schema: public; Owner: hospital
3816--
3817
3818ALTER TABLE ONLY resellerpackages ALTER COLUMN resellerpackages_id SET DEFAULT nextval('resellerpackages_resellerpackages_id_seq'::regclass);
3819
3820
3821--
3822-- Name: resellers resellers_id; Type: DEFAULT; Schema: public; Owner: hospital
3823--
3824
3825ALTER TABLE ONLY resellers ALTER COLUMN resellers_id SET DEFAULT nextval('resellers_resellers_id_seq'::regclass);
3826
3827
3828--
3829-- Name: role role_id; Type: DEFAULT; Schema: public; Owner: hospital
3830--
3831
3832ALTER TABLE ONLY role ALTER COLUMN role_id SET DEFAULT nextval('role_role_id_seq'::regclass);
3833
3834
3835--
3836-- Name: salesagentpackages salesagentpackages_id; Type: DEFAULT; Schema: public; Owner: hospital
3837--
3838
3839ALTER TABLE ONLY salesagentpackages ALTER COLUMN salesagentpackages_id SET DEFAULT nextval('salesagentpackages_salesagentpackages_id_seq'::regclass);
3840
3841
3842--
3843-- Name: salesagents salesagents_id; Type: DEFAULT; Schema: public; Owner: hospital
3844--
3845
3846ALTER TABLE ONLY salesagents ALTER COLUMN salesagents_id SET DEFAULT nextval('salesagents_salesagents_id_seq'::regclass);
3847
3848
3849--
3850-- Name: salestarget salestarget_id; Type: DEFAULT; Schema: public; Owner: hospital
3851--
3852
3853ALTER TABLE ONLY salestarget ALTER COLUMN salestarget_id SET DEFAULT nextval('salestarget_salestarget_id_seq'::regclass);
3854
3855
3856--
3857-- Name: secretquestions secretquestions_id; Type: DEFAULT; Schema: public; Owner: hospital
3858--
3859
3860ALTER TABLE ONLY secretquestions ALTER COLUMN secretquestions_id SET DEFAULT nextval('secretquestions_secretquestions_id_seq'::regclass);
3861
3862
3863--
3864-- Name: speciality speciality_id; Type: DEFAULT; Schema: public; Owner: hospital
3865--
3866
3867ALTER TABLE ONLY speciality ALTER COLUMN speciality_id SET DEFAULT nextval('speciality_speciality_id_seq'::regclass);
3868
3869
3870--
3871-- Name: speciality_type speciality_type_id; Type: DEFAULT; Schema: public; Owner: hospital
3872--
3873
3874ALTER TABLE ONLY speciality_type ALTER COLUMN speciality_type_id SET DEFAULT nextval('speciality_type_speciality_type_id_seq'::regclass);
3875
3876
3877--
3878-- Name: sponsors sponsors_id; Type: DEFAULT; Schema: public; Owner: hospital
3879--
3880
3881ALTER TABLE ONLY sponsors ALTER COLUMN sponsors_id SET DEFAULT nextval('sponsors_sponsors_id_seq'::regclass);
3882
3883
3884--
3885-- Name: sponsors_group sponsors_group_id; Type: DEFAULT; Schema: public; Owner: hospital
3886--
3887
3888ALTER TABLE ONLY sponsors_group ALTER COLUMN sponsors_group_id SET DEFAULT nextval('sponsors_group_sponsors_group_id_seq'::regclass);
3889
3890
3891--
3892-- Name: state state_id; Type: DEFAULT; Schema: public; Owner: hospital
3893--
3894
3895ALTER TABLE ONLY state ALTER COLUMN state_id SET DEFAULT nextval('state_state_id_seq'::regclass);
3896
3897
3898--
3899-- Name: symptoms symptoms_id; Type: DEFAULT; Schema: public; Owner: hospital
3900--
3901
3902ALTER TABLE ONLY symptoms ALTER COLUMN symptoms_id SET DEFAULT nextval('symptoms_symptoms_id_seq'::regclass);
3903
3904
3905--
3906-- Name: telephone telephone_id; Type: DEFAULT; Schema: public; Owner: hospital
3907--
3908
3909ALTER TABLE ONLY telephone ALTER COLUMN telephone_id SET DEFAULT nextval('telephone_telephone_id_seq'::regclass);
3910
3911
3912--
3913-- Name: test test_id; Type: DEFAULT; Schema: public; Owner: hospital
3914--
3915
3916ALTER TABLE ONLY test ALTER COLUMN test_id SET DEFAULT nextval('test_test_id_seq'::regclass);
3917
3918
3919--
3920-- Name: test_category test_category_id; Type: DEFAULT; Schema: public; Owner: hospital
3921--
3922
3923ALTER TABLE ONLY test_category ALTER COLUMN test_category_id SET DEFAULT nextval('test_category_test_category_id_seq'::regclass);
3924
3925
3926--
3927-- Name: test_subcategory test_subcategory_id; Type: DEFAULT; Schema: public; Owner: hospital
3928--
3929
3930ALTER TABLE ONLY test_subcategory ALTER COLUMN test_subcategory_id SET DEFAULT nextval('test_subcategory_test_subcategory_id_seq'::regclass);
3931
3932
3933--
3934-- Name: testimonials testimonials_id; Type: DEFAULT; Schema: public; Owner: hospital
3935--
3936
3937ALTER TABLE ONLY testimonials ALTER COLUMN testimonials_id SET DEFAULT nextval('testimonials_testimonials_id_seq'::regclass);
3938
3939
3940--
3941-- Name: timeslots timeslots_id; Type: DEFAULT; Schema: public; Owner: hospital
3942--
3943
3944ALTER TABLE ONLY timeslots ALTER COLUMN timeslots_id SET DEFAULT nextval('timeslots_timeslots_id_seq'::regclass);
3945
3946
3947--
3948-- Name: trxn_appointmentbookings trxn_appointmentbookings_id; Type: DEFAULT; Schema: public; Owner: hospital
3949--
3950
3951ALTER TABLE ONLY trxn_appointmentbookings ALTER COLUMN trxn_appointmentbookings_id SET DEFAULT nextval('trxn_appointmentbookings_trxn_appointmentbookings_id_seq'::regclass);
3952
3953
3954--
3955-- Name: trxn_coupons trxn_coupons_id; Type: DEFAULT; Schema: public; Owner: hospital
3956--
3957
3958ALTER TABLE ONLY trxn_coupons ALTER COLUMN trxn_coupons_id SET DEFAULT nextval('trxn_coupons_trxn_coupons_id_seq'::regclass);
3959
3960
3961--
3962-- Name: trxn_discountcard trxn_discountcard_id; Type: DEFAULT; Schema: public; Owner: hospital
3963--
3964
3965ALTER TABLE ONLY trxn_discountcard ALTER COLUMN trxn_discountcard_id SET DEFAULT nextval('trxn_discountcard_trxn_discountcard_id_seq'::regclass);
3966
3967
3968--
3969-- Name: trxn_healthcheckbooking trxn_healthcheckbooking_id; Type: DEFAULT; Schema: public; Owner: hospital
3970--
3971
3972ALTER TABLE ONLY trxn_healthcheckbooking ALTER COLUMN trxn_healthcheckbooking_id SET DEFAULT nextval('trxn_healthcheckbooking_trxn_healthcheckbooking_id_seq'::regclass);
3973
3974
3975--
3976-- Name: trxn_payments trxn_payments_id; Type: DEFAULT; Schema: public; Owner: hospital
3977--
3978
3979ALTER TABLE ONLY trxn_payments ALTER COLUMN trxn_payments_id SET DEFAULT nextval('trxn_payments_trxn_payments_id_seq'::regclass);
3980
3981
3982--
3983-- Name: users users_id; Type: DEFAULT; Schema: public; Owner: hospital
3984--
3985
3986ALTER TABLE ONLY users ALTER COLUMN users_id SET DEFAULT nextval('users_users_id_seq'::regclass);
3987
3988
3989--
3990-- Name: week week_id; Type: DEFAULT; Schema: public; Owner: hospital
3991--
3992
3993ALTER TABLE ONLY week ALTER COLUMN week_id SET DEFAULT nextval('week_week_id_seq'::regclass);
3994
3995
3996--
3997-- Name: wellnessplan wellnessplan_id; Type: DEFAULT; Schema: public; Owner: hospital
3998--
3999
4000ALTER TABLE ONLY wellnessplan ALTER COLUMN wellnessplan_id SET DEFAULT nextval('wellnessplan_wellnessplan_id_seq'::regclass);
4001
4002
4003--
4004-- Name: wellnessplan_profession wellnessplan_profession_id; Type: DEFAULT; Schema: public; Owner: hospital
4005--
4006
4007ALTER TABLE ONLY wellnessplan_profession ALTER COLUMN wellnessplan_profession_id SET DEFAULT nextval('wellnessplan_profession_wellnessplan_profession_id_seq'::regclass);
4008
4009
4010--
4011-- Name: wellnessplan_socialhistory wellnessplan_socialhistory_id; Type: DEFAULT; Schema: public; Owner: hospital
4012--
4013
4014ALTER TABLE ONLY wellnessplan_socialhistory ALTER COLUMN wellnessplan_socialhistory_id SET DEFAULT nextval('wellnessplan_socialhistory_wellnessplan_socialhistory_id_seq'::regclass);
4015
4016
4017--
4018-- Data for Name: address; Type: TABLE DATA; Schema: public; Owner: hospital
4019--
4020
4021COPY address (address_id, district_id, country_id, state_id, city_id, latlong, doorno, landmark, pincode, fax, contactperson) FROM stdin;
4022\.
4023
4024
4025--
4026-- Name: address_address_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
4027--
4028
4029SELECT pg_catalog.setval('address_address_id_seq', 1, false);
4030
4031
4032--
4033-- Data for Name: agegroup; Type: TABLE DATA; Schema: public; Owner: hospital
4034--
4035
4036COPY agegroup (agegroup_id, agegroup, sort_by, status_2) FROM stdin;
4037\.
4038
4039
4040--
4041-- Name: agegroup_agegroup_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
4042--
4043
4044SELECT pg_catalog.setval('agegroup_agegroup_id_seq', 1, false);
4045
4046
4047--
4048-- Data for Name: alertsources; Type: TABLE DATA; Schema: public; Owner: hospital
4049--
4050
4051COPY alertsources (alertsources_id, alertsource, sort_by, status_2) FROM stdin;
4052\.
4053
4054
4055--
4056-- Name: alertsources_alertsources_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
4057--
4058
4059SELECT pg_catalog.setval('alertsources_alertsources_id_seq', 1, false);
4060
4061
4062--
4063-- Data for Name: alerttype; Type: TABLE DATA; Schema: public; Owner: hospital
4064--
4065
4066COPY alerttype (alerttype_id, alerttype, sort_by, status_2) FROM stdin;
4067\.
4068
4069
4070--
4071-- Name: alerttype_alerttype_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
4072--
4073
4074SELECT pg_catalog.setval('alerttype_alerttype_id_seq', 1, false);
4075
4076
4077--
4078-- Data for Name: appointmentbooking; Type: TABLE DATA; Schema: public; Owner: hospital
4079--
4080
4081COPY appointmentbooking (appointmentbooking_id, date, priyority_id, speciality_id, healthseeker_id, clinicians_id, bookingsources_id, "time", reg_date, ipaddress, macaddress, isnew, visittype) FROM stdin;
4082\.
4083
4084
4085--
4086-- Name: appointmentbooking_appointmentbooking_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
4087--
4088
4089SELECT pg_catalog.setval('appointmentbooking_appointmentbooking_id_seq', 1, false);
4090
4091
4092--
4093-- Data for Name: auth_group; Type: TABLE DATA; Schema: public; Owner: hospital
4094--
4095
4096COPY auth_group (id, name) FROM stdin;
4097\.
4098
4099
4100--
4101-- Name: auth_group_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
4102--
4103
4104SELECT pg_catalog.setval('auth_group_id_seq', 1, false);
4105
4106
4107--
4108-- Data for Name: auth_group_permissions; Type: TABLE DATA; Schema: public; Owner: hospital
4109--
4110
4111COPY auth_group_permissions (id, group_id, permission_id) FROM stdin;
4112\.
4113
4114
4115--
4116-- Name: auth_group_permissions_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
4117--
4118
4119SELECT pg_catalog.setval('auth_group_permissions_id_seq', 1, false);
4120
4121
4122--
4123-- Data for Name: auth_permission; Type: TABLE DATA; Schema: public; Owner: hospital
4124--
4125
4126COPY auth_permission (id, name, content_type_id, codename) FROM stdin;
41271	Can add log entry	1	add_logentry
41282	Can change log entry	1	change_logentry
41293	Can delete log entry	1	delete_logentry
41304	Can add permission	2	add_permission
41315	Can change permission	2	change_permission
41326	Can delete permission	2	delete_permission
41337	Can add group	3	add_group
41348	Can change group	3	change_group
41359	Can delete group	3	delete_group
413610	Can add user	4	add_user
413711	Can change user	4	change_user
413812	Can delete user	4	delete_user
413913	Can add content type	5	add_contenttype
414014	Can change content type	5	change_contenttype
414115	Can delete content type	5	delete_contenttype
414216	Can add session	6	add_session
414317	Can change session	6	change_session
414418	Can delete session	6	delete_session
414519	Can add address	7	add_address
414620	Can change address	7	change_address
414721	Can delete address	7	delete_address
414822	Can add agegroup	8	add_agegroup
414923	Can change agegroup	8	change_agegroup
415024	Can delete agegroup	8	delete_agegroup
415125	Can add alertsources	9	add_alertsources
415226	Can change alertsources	9	change_alertsources
415327	Can delete alertsources	9	delete_alertsources
415428	Can add alerttype	10	add_alerttype
415529	Can change alerttype	10	change_alerttype
415630	Can delete alerttype	10	delete_alerttype
415731	Can add appointmentbooking	11	add_appointmentbooking
415832	Can change appointmentbooking	11	change_appointmentbooking
415933	Can delete appointmentbooking	11	delete_appointmentbooking
416034	Can add auth group	12	add_authgroup
416135	Can change auth group	12	change_authgroup
416236	Can delete auth group	12	delete_authgroup
416337	Can add auth group permissions	13	add_authgrouppermissions
416438	Can change auth group permissions	13	change_authgrouppermissions
416539	Can delete auth group permissions	13	delete_authgrouppermissions
416640	Can add auth permission	14	add_authpermission
416741	Can change auth permission	14	change_authpermission
416842	Can delete auth permission	14	delete_authpermission
416943	Can add auth user	15	add_authuser
417044	Can change auth user	15	change_authuser
417145	Can delete auth user	15	delete_authuser
417246	Can add auth user groups	16	add_authusergroups
417347	Can change auth user groups	16	change_authusergroups
417448	Can delete auth user groups	16	delete_authusergroups
417549	Can add auth user user permissions	17	add_authuseruserpermissions
417650	Can change auth user user permissions	17	change_authuseruserpermissions
417751	Can delete auth user user permissions	17	delete_authuseruserpermissions
417852	Can add availablefacilities	18	add_availablefacilities
417953	Can change availablefacilities	18	change_availablefacilities
418054	Can delete availablefacilities	18	delete_availablefacilities
418155	Can add bookingsources	19	add_bookingsources
418256	Can change bookingsources	19	change_bookingsources
418357	Can delete bookingsources	19	delete_bookingsources
418458	Can add businessregtype	20	add_businessregtype
418559	Can change businessregtype	20	change_businessregtype
418660	Can delete businessregtype	20	delete_businessregtype
418761	Can add city	21	add_city
418862	Can change city	21	change_city
418963	Can delete city	21	delete_city
419064	Can add clinician memberships	22	add_clinicianmemberships
419165	Can change clinician memberships	22	change_clinicianmemberships
419266	Can delete clinician memberships	22	delete_clinicianmemberships
419367	Can add clinicians	23	add_clinicians
419468	Can change clinicians	23	change_clinicians
419569	Can delete clinicians	23	delete_clinicians
419670	Can add clinicians dates	24	add_cliniciansdates
419771	Can change clinicians dates	24	change_cliniciansdates
419872	Can delete clinicians dates	24	delete_cliniciansdates
419973	Can add clinicians education	25	add_clinicianseducation
420074	Can change clinicians education	25	change_clinicianseducation
420175	Can delete clinicians education	25	delete_clinicianseducation
420276	Can add clinicians experience	26	add_cliniciansexperience
420377	Can change clinicians experience	26	change_cliniciansexperience
420478	Can delete clinicians experience	26	delete_cliniciansexperience
420579	Can add conditions	27	add_conditions
420680	Can change conditions	27	change_conditions
420781	Can delete conditions	27	delete_conditions
420882	Can add country	28	add_country
420983	Can change country	28	change_country
421084	Can delete country	28	delete_country
421185	Can add couponaccept	29	add_couponaccept
421286	Can change couponaccept	29	change_couponaccept
421387	Can delete couponaccept	29	delete_couponaccept
421488	Can add coupons	30	add_coupons
421589	Can change coupons	30	change_coupons
421690	Can delete coupons	30	delete_coupons
421791	Can add discountcard	31	add_discountcard
421892	Can change discountcard	31	change_discountcard
421993	Can delete discountcard	31	delete_discountcard
422094	Can add discountcard family	32	add_discountcardfamily
422195	Can change discountcard family	32	change_discountcardfamily
422296	Can delete discountcard family	32	delete_discountcardfamily
422397	Can add discountcard family extra	33	add_discountcardfamilyextra
422498	Can change discountcard family extra	33	change_discountcardfamilyextra
422599	Can delete discountcard family extra	33	delete_discountcardfamilyextra
4226100	Can add district	34	add_district
4227101	Can change district	34	change_district
4228102	Can delete district	34	delete_district
4229103	Can add django admin log	35	add_djangoadminlog
4230104	Can change django admin log	35	change_djangoadminlog
4231105	Can delete django admin log	35	delete_djangoadminlog
4232106	Can add django content type	36	add_djangocontenttype
4233107	Can change django content type	36	change_djangocontenttype
4234108	Can delete django content type	36	delete_djangocontenttype
4235109	Can add django migrations	37	add_djangomigrations
4236110	Can change django migrations	37	change_djangomigrations
4237111	Can delete django migrations	37	delete_djangomigrations
4238112	Can add django session	38	add_djangosession
4239113	Can change django session	38	change_djangosession
4240114	Can delete django session	38	delete_djangosession
4241115	Can add facilities	39	add_facilities
4242116	Can change facilities	39	change_facilities
4243117	Can delete facilities	39	delete_facilities
4244118	Can add facilities services	40	add_facilitiesservices
4245119	Can change facilities services	40	change_facilitiesservices
4246120	Can delete facilities services	40	delete_facilitiesservices
4247121	Can add family	41	add_family
4248122	Can change family	41	change_family
4249123	Can delete family	41	delete_family
4250124	Can add feedback	42	add_feedback
4251125	Can change feedback	42	change_feedback
4252126	Can delete feedback	42	delete_feedback
4253127	Can add gender	43	add_gender
4254128	Can change gender	43	change_gender
4255129	Can delete gender	43	delete_gender
4256130	Can add healthcheckbookibg	44	add_healthcheckbookibg
4257131	Can change healthcheckbookibg	44	change_healthcheckbookibg
4258132	Can delete healthcheckbookibg	44	delete_healthcheckbookibg
4259133	Can add healthchecks	45	add_healthchecks
4260134	Can change healthchecks	45	change_healthchecks
4261135	Can delete healthchecks	45	delete_healthchecks
4262136	Can add healthchecks inclusion	46	add_healthchecksinclusion
4263137	Can change healthchecks inclusion	46	change_healthchecksinclusion
4264138	Can delete healthchecks inclusion	46	delete_healthchecksinclusion
4265139	Can add healthproviders	47	add_healthproviders
4266140	Can change healthproviders	47	change_healthproviders
4267141	Can delete healthproviders	47	delete_healthproviders
4268142	Can add healthrecords	48	add_healthrecords
4269143	Can change healthrecords	48	change_healthrecords
4270144	Can delete healthrecords	48	delete_healthrecords
4271145	Can add healthseeker	49	add_healthseeker
4272146	Can change healthseeker	49	change_healthseeker
4273147	Can delete healthseeker	49	delete_healthseeker
4274148	Can add healthseeker availabilities	50	add_healthseekeravailabilities
4275149	Can change healthseeker availabilities	50	change_healthseekeravailabilities
4276150	Can delete healthseeker availabilities	50	delete_healthseekeravailabilities
4277151	Can add healthseeker healthrecords	51	add_healthseekerhealthrecords
4278152	Can change healthseeker healthrecords	51	change_healthseekerhealthrecords
4279153	Can delete healthseeker healthrecords	51	delete_healthseekerhealthrecords
4280154	Can add interest	52	add_interest
4281155	Can change interest	52	change_interest
4282156	Can delete interest	52	delete_interest
4283157	Can add languages	53	add_languages
4284158	Can change languages	53	change_languages
4285159	Can delete languages	53	delete_languages
4286160	Can add photoalbum	54	add_photoalbum
4287161	Can change photoalbum	54	change_photoalbum
4288162	Can delete photoalbum	54	delete_photoalbum
4289163	Can add plans	55	add_plans
4290164	Can change plans	55	change_plans
4291165	Can delete plans	55	delete_plans
4292166	Can add plans groups	56	add_plansgroups
4293167	Can change plans groups	56	change_plansgroups
4294168	Can delete plans groups	56	delete_plansgroups
4295169	Can add plans groups specialities	57	add_plansgroupsspecialities
4296170	Can change plans groups specialities	57	change_plansgroupsspecialities
4297171	Can delete plans groups specialities	57	delete_plansgroupsspecialities
4298172	Can add profession	58	add_profession
4299173	Can change profession	58	change_profession
4300174	Can delete profession	58	delete_profession
4301175	Can add qualification	59	add_qualification
4302176	Can change qualification	59	change_qualification
4303177	Can delete qualification	59	delete_qualification
4304178	Can add referrelscheme	60	add_referrelscheme
4305179	Can change referrelscheme	60	change_referrelscheme
4306180	Can delete referrelscheme	60	delete_referrelscheme
4307181	Can add registration welcome message	61	add_registrationwelcomemessage
4308182	Can change registration welcome message	61	change_registrationwelcomemessage
4309183	Can delete registration welcome message	61	delete_registrationwelcomemessage
4310184	Can add resellerpackages	62	add_resellerpackages
4311185	Can change resellerpackages	62	change_resellerpackages
4312186	Can delete resellerpackages	62	delete_resellerpackages
4313187	Can add resellers	63	add_resellers
4314188	Can change resellers	63	change_resellers
4315189	Can delete resellers	63	delete_resellers
4316190	Can add role	64	add_role
4317191	Can change role	64	change_role
4318192	Can delete role	64	delete_role
4319193	Can add salesagentpackages	65	add_salesagentpackages
4320194	Can change salesagentpackages	65	change_salesagentpackages
4321195	Can delete salesagentpackages	65	delete_salesagentpackages
4322196	Can add salesagents	66	add_salesagents
4323197	Can change salesagents	66	change_salesagents
4324198	Can delete salesagents	66	delete_salesagents
4325199	Can add salestarget	67	add_salestarget
4326200	Can change salestarget	67	change_salestarget
4327201	Can delete salestarget	67	delete_salestarget
4328202	Can add speciality	68	add_speciality
4329203	Can change speciality	68	change_speciality
4330204	Can delete speciality	68	delete_speciality
4331205	Can add sponsors	69	add_sponsors
4332206	Can change sponsors	69	change_sponsors
4333207	Can delete sponsors	69	delete_sponsors
4334208	Can add sponsors group	70	add_sponsorsgroup
4335209	Can change sponsors group	70	change_sponsorsgroup
4336210	Can delete sponsors group	70	delete_sponsorsgroup
4337211	Can add state	71	add_state
4338212	Can change state	71	change_state
4339213	Can delete state	71	delete_state
4340214	Can add subrole	72	add_subrole
4341215	Can change subrole	72	change_subrole
4342216	Can delete subrole	72	delete_subrole
4343217	Can add symptoms	73	add_symptoms
4344218	Can change symptoms	73	change_symptoms
4345219	Can delete symptoms	73	delete_symptoms
4346220	Can add telephone	74	add_telephone
4347221	Can change telephone	74	change_telephone
4348222	Can delete telephone	74	delete_telephone
4349223	Can add test	75	add_test
4350224	Can change test	75	change_test
4351225	Can delete test	75	delete_test
4352226	Can add test category	76	add_testcategory
4353227	Can change test category	76	change_testcategory
4354228	Can delete test category	76	delete_testcategory
4355229	Can add testimonials	77	add_testimonials
4356230	Can change testimonials	77	change_testimonials
4357231	Can delete testimonials	77	delete_testimonials
4358232	Can add test subcategory	78	add_testsubcategory
4359233	Can change test subcategory	78	change_testsubcategory
4360234	Can delete test subcategory	78	delete_testsubcategory
4361235	Can add timeslots	79	add_timeslots
4362236	Can change timeslots	79	change_timeslots
4363237	Can delete timeslots	79	delete_timeslots
4364238	Can add users	80	add_users
4365239	Can change users	80	change_users
4366240	Can delete users	80	delete_users
4367241	Can add week	81	add_week
4368242	Can change week	81	change_week
4369243	Can delete week	81	delete_week
4370244	Can add wellnessplan	82	add_wellnessplan
4371245	Can change wellnessplan	82	change_wellnessplan
4372246	Can delete wellnessplan	82	delete_wellnessplan
4373247	Can add wellnessplan profession	83	add_wellnessplanprofession
4374248	Can change wellnessplan profession	83	change_wellnessplanprofession
4375249	Can delete wellnessplan profession	83	delete_wellnessplanprofession
4376250	Can add wellnessplan socialhistory	84	add_wellnessplansocialhistory
4377251	Can change wellnessplan socialhistory	84	change_wellnessplansocialhistory
4378252	Can delete wellnessplan socialhistory	84	delete_wellnessplansocialhistory
4379253	Can add clinicians speciality	85	add_cliniciansspeciality
4380254	Can change clinicians speciality	85	change_cliniciansspeciality
4381255	Can delete clinicians speciality	85	delete_cliniciansspeciality
4382256	Can add designation	86	add_designation
4383257	Can change designation	86	change_designation
4384258	Can delete designation	86	delete_designation
4385259	Can add healthcheckbooking	87	add_healthcheckbooking
4386260	Can change healthcheckbooking	87	change_healthcheckbooking
4387261	Can delete healthcheckbooking	87	delete_healthcheckbooking
4388262	Can add healthproviders speciality	88	add_healthprovidersspeciality
4389263	Can change healthproviders speciality	88	change_healthprovidersspeciality
4390264	Can delete healthproviders speciality	88	delete_healthprovidersspeciality
4391265	Can add healthseeker alerts	89	add_healthseekeralerts
4392266	Can change healthseeker alerts	89	change_healthseekeralerts
4393267	Can delete healthseeker alerts	89	delete_healthseekeralerts
4394268	Can add healthseeker type	90	add_healthseekertype
4395269	Can change healthseeker type	90	change_healthseekertype
4396270	Can delete healthseeker type	90	delete_healthseekertype
4397271	Can add priyority	91	add_priyority
4398272	Can change priyority	91	change_priyority
4399273	Can delete priyority	91	delete_priyority
4400274	Can add referrels	92	add_referrels
4401275	Can change referrels	92	change_referrels
4402276	Can delete referrels	92	delete_referrels
4403277	Can add secretquestions	93	add_secretquestions
4404278	Can change secretquestions	93	change_secretquestions
4405279	Can delete secretquestions	93	delete_secretquestions
4406280	Can add speciality type	94	add_specialitytype
4407281	Can change speciality type	94	change_specialitytype
4408282	Can delete speciality type	94	delete_specialitytype
4409283	Can add trxn appointmentbookings	95	add_trxnappointmentbookings
4410284	Can change trxn appointmentbookings	95	change_trxnappointmentbookings
4411285	Can delete trxn appointmentbookings	95	delete_trxnappointmentbookings
4412286	Can add trxn coupons	96	add_trxncoupons
4413287	Can change trxn coupons	96	change_trxncoupons
4414288	Can delete trxn coupons	96	delete_trxncoupons
4415289	Can add trxn discountcard	97	add_trxndiscountcard
4416290	Can change trxn discountcard	97	change_trxndiscountcard
4417291	Can delete trxn discountcard	97	delete_trxndiscountcard
4418292	Can add trxn healthcheckbooking	98	add_trxnhealthcheckbooking
4419293	Can change trxn healthcheckbooking	98	change_trxnhealthcheckbooking
4420294	Can delete trxn healthcheckbooking	98	delete_trxnhealthcheckbooking
4421295	Can add trxn payments	99	add_trxnpayments
4422296	Can change trxn payments	99	change_trxnpayments
4423297	Can delete trxn payments	99	delete_trxnpayments
4424\.
4425
4426
4427--
4428-- Name: auth_permission_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
4429--
4430
4431SELECT pg_catalog.setval('auth_permission_id_seq', 297, true);
4432
4433
4434--
4435-- Data for Name: auth_user; Type: TABLE DATA; Schema: public; Owner: hospital
4436--
4437
4438COPY auth_user (id, password, last_login, is_superuser, username, first_name, last_name, email, is_staff, is_active, date_joined) FROM stdin;
44391	pbkdf2_sha256$100000$vknRXiMVPqos$xnVnkiUMuFfF5yQkyeDF0QgiFSmbCr6oKiL5/XsGHzg=	2018-01-12 06:00:02.875008+05:30	t	pratik			pratik@gmail.com	t	t	2018-01-12 05:59:53.636119+05:30
4440\.
4441
4442
4443--
4444-- Data for Name: auth_user_groups; Type: TABLE DATA; Schema: public; Owner: hospital
4445--
4446
4447COPY auth_user_groups (id, user_id, group_id) FROM stdin;
4448\.
4449
4450
4451--
4452-- Name: auth_user_groups_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
4453--
4454
4455SELECT pg_catalog.setval('auth_user_groups_id_seq', 1, false);
4456
4457
4458--
4459-- Name: auth_user_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
4460--
4461
4462SELECT pg_catalog.setval('auth_user_id_seq', 1, true);
4463
4464
4465--
4466-- Data for Name: auth_user_user_permissions; Type: TABLE DATA; Schema: public; Owner: hospital
4467--
4468
4469COPY auth_user_user_permissions (id, user_id, permission_id) FROM stdin;
4470\.
4471
4472
4473--
4474-- Name: auth_user_user_permissions_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
4475--
4476
4477SELECT pg_catalog.setval('auth_user_user_permissions_id_seq', 1, false);
4478
4479
4480--
4481-- Data for Name: availablefacilities; Type: TABLE DATA; Schema: public; Owner: hospital
4482--
4483
4484COPY availablefacilities (availablefacilities_id, facilities_services_id, healthproviders_id, facilities_id, sort_by, status_2) FROM stdin;
4485\.
4486
4487
4488--
4489-- Name: availablefacilities_availablefacilities_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
4490--
4491
4492SELECT pg_catalog.setval('availablefacilities_availablefacilities_id_seq', 1, false);
4493
4494
4495--
4496-- Data for Name: bookingsources; Type: TABLE DATA; Schema: public; Owner: hospital
4497--
4498
4499COPY bookingsources (bookingsources_id, sourcename, sort_by, status_2) FROM stdin;
4500\.
4501
4502
4503--
4504-- Name: bookingsources_bookingsources_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
4505--
4506
4507SELECT pg_catalog.setval('bookingsources_bookingsources_id_seq', 1, false);
4508
4509
4510--
4511-- Data for Name: businessregtype; Type: TABLE DATA; Schema: public; Owner: hospital
4512--
4513
4514COPY businessregtype (businessregtype_id, businessregtype, sort_by, status_2) FROM stdin;
4515\.
4516
4517
4518--
4519-- Name: businessregtype_businessregtype_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
4520--
4521
4522SELECT pg_catalog.setval('businessregtype_businessregtype_id_seq', 1, false);
4523
4524
4525--
4526-- Data for Name: city; Type: TABLE DATA; Schema: public; Owner: hospital
4527--
4528
4529COPY city (city_id, city, sort_by, status_2) FROM stdin;
4530\.
4531
4532
4533--
4534-- Name: city_city_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
4535--
4536
4537SELECT pg_catalog.setval('city_city_id_seq', 1, false);
4538
4539
4540--
4541-- Data for Name: clinician_memberships; Type: TABLE DATA; Schema: public; Owner: hospital
4542--
4543
4544COPY clinician_memberships (clinician_memberships_id, city_id, country_id, association, reg_date) FROM stdin;
4545\.
4546
4547
4548--
4549-- Name: clinician_memberships_clinician_memberships_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
4550--
4551
4552SELECT pg_catalog.setval('clinician_memberships_clinician_memberships_id_seq', 1, false);
4553
4554
4555--
4556-- Data for Name: clinicians; Type: TABLE DATA; Schema: public; Owner: hospital
4557--
4558
4559COPY clinicians (clinicians_id, languages_id, gender_id, users_id, dob, image) FROM stdin;
4560\.
4561
4562
4563--
4564-- Name: clinicians_clinicians_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
4565--
4566
4567SELECT pg_catalog.setval('clinicians_clinicians_id_seq', 1, false);
4568
4569
4570--
4571-- Data for Name: clinicians_dates; Type: TABLE DATA; Schema: public; Owner: hospital
4572--
4573
4574COPY clinicians_dates (clinicians_dates_id, clinicians_id, timeslots_id, week_id, alldays) FROM stdin;
4575\.
4576
4577
4578--
4579-- Name: clinicians_dates_clinicians_dates_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
4580--
4581
4582SELECT pg_catalog.setval('clinicians_dates_clinicians_dates_id_seq', 1, false);
4583
4584
4585--
4586-- Data for Name: clinicians_education; Type: TABLE DATA; Schema: public; Owner: hospital
4587--
4588
4589COPY clinicians_education (clinicians_education_id, qualification_id, clinicians_id, registrationno, college) FROM stdin;
4590\.
4591
4592
4593--
4594-- Name: clinicians_education_clinicians_education_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
4595--
4596
4597SELECT pg_catalog.setval('clinicians_education_clinicians_education_id_seq', 1, false);
4598
4599
4600--
4601-- Data for Name: clinicians_experience; Type: TABLE DATA; Schema: public; Owner: hospital
4602--
4603
4604COPY clinicians_experience (clinicians_experience_id, designation_id, clinicians_id, institution, workfrom, workto, reg_date) FROM stdin;
4605\.
4606
4607
4608--
4609-- Name: clinicians_experience_clinicians_experience_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
4610--
4611
4612SELECT pg_catalog.setval('clinicians_experience_clinicians_experience_id_seq', 1, false);
4613
4614
4615--
4616-- Data for Name: clinicians_speciality; Type: TABLE DATA; Schema: public; Owner: hospital
4617--
4618
4619COPY clinicians_speciality (clinicians_speciality_id, symptoms_id, healthproviders_speciality_id, clinicians_id, activefrom, activeto, reg_date) FROM stdin;
4620\.
4621
4622
4623--
4624-- Name: clinicians_speciality_clinicians_speciality_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
4625--
4626
4627SELECT pg_catalog.setval('clinicians_speciality_clinicians_speciality_id_seq', 1, false);
4628
4629
4630--
4631-- Data for Name: conditions; Type: TABLE DATA; Schema: public; Owner: hospital
4632--
4633
4634COPY conditions (conditions_id, conditionname, sort_by, status_2) FROM stdin;
4635\.
4636
4637
4638--
4639-- Name: conditions_conditions_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
4640--
4641
4642SELECT pg_catalog.setval('conditions_conditions_id_seq', 1, false);
4643
4644
4645--
4646-- Data for Name: country; Type: TABLE DATA; Schema: public; Owner: hospital
4647--
4648
4649COPY country (country_id, country, sort_by, status_2) FROM stdin;
4650\.
4651
4652
4653--
4654-- Name: country_country_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
4655--
4656
4657SELECT pg_catalog.setval('country_country_id_seq', 1, false);
4658
4659
4660--
4661-- Data for Name: couponaccept; Type: TABLE DATA; Schema: public; Owner: hospital
4662--
4663
4664COPY couponaccept (couponaccept_id, couponaccept, sort_by, status_2) FROM stdin;
4665\.
4666
4667
4668--
4669-- Name: couponaccept_couponaccept_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
4670--
4671
4672SELECT pg_catalog.setval('couponaccept_couponaccept_id_seq', 1, false);
4673
4674
4675--
4676-- Data for Name: coupons; Type: TABLE DATA; Schema: public; Owner: hospital
4677--
4678
4679COPY coupons (coupons_id, coupon, applicablesponsor, uniquecode, validity, timevalidity, couponstatus) FROM stdin;
4680\.
4681
4682
4683--
4684-- Name: coupons_coupons_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
4685--
4686
4687SELECT pg_catalog.setval('coupons_coupons_id_seq', 1, false);
4688
4689
4690--
4691-- Data for Name: designation; Type: TABLE DATA; Schema: public; Owner: hospital
4692--
4693
4694COPY designation (designation_id, designation, sort_by, status_2) FROM stdin;
4695\.
4696
4697
4698--
4699-- Name: designation_designation_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
4700--
4701
4702SELECT pg_catalog.setval('designation_designation_id_seq', 1, false);
4703
4704
4705--
4706-- Data for Name: discountcard; Type: TABLE DATA; Schema: public; Owner: hospital
4707--
4708
4709COPY discountcard (discountcard_id, healthchecks_id, discountcard, description, eligibility, familyrestriction, addfamilyrestriction, applicablesponser, otherbenfits) FROM stdin;
4710\.
4711
4712
4713--
4714-- Name: discountcard_discountcard_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
4715--
4716
4717SELECT pg_catalog.setval('discountcard_discountcard_id_seq', 1, false);
4718
4719
4720--
4721-- Data for Name: discountcard_family; Type: TABLE DATA; Schema: public; Owner: hospital
4722--
4723
4724COPY discountcard_family (discountcard_family_id, discountcard_id, family_id, price) FROM stdin;
4725\.
4726
4727
4728--
4729-- Name: discountcard_family_discountcard_family_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
4730--
4731
4732SELECT pg_catalog.setval('discountcard_family_discountcard_family_id_seq', 1, false);
4733
4734
4735--
4736-- Data for Name: discountcard_family_extra; Type: TABLE DATA; Schema: public; Owner: hospital
4737--
4738
4739COPY discountcard_family_extra (discountcard_family_extra_id, family_id, discountcard_id, price) FROM stdin;
4740\.
4741
4742
4743--
4744-- Name: discountcard_family_extra_discountcard_family_extra_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
4745--
4746
4747SELECT pg_catalog.setval('discountcard_family_extra_discountcard_family_extra_id_seq', 1, false);
4748
4749
4750--
4751-- Data for Name: district; Type: TABLE DATA; Schema: public; Owner: hospital
4752--
4753
4754COPY district (district_id, district, sort_by, status_2) FROM stdin;
4755\.
4756
4757
4758--
4759-- Name: district_district_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
4760--
4761
4762SELECT pg_catalog.setval('district_district_id_seq', 1, false);
4763
4764
4765--
4766-- Data for Name: django_admin_log; Type: TABLE DATA; Schema: public; Owner: hospital
4767--
4768
4769COPY django_admin_log (id, action_time, object_id, object_repr, action_flag, change_message, content_type_id, user_id) FROM stdin;
4770\.
4771
4772
4773--
4774-- Name: django_admin_log_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
4775--
4776
4777SELECT pg_catalog.setval('django_admin_log_id_seq', 1, false);
4778
4779
4780--
4781-- Data for Name: django_content_type; Type: TABLE DATA; Schema: public; Owner: hospital
4782--
4783
4784COPY django_content_type (id, app_label, model) FROM stdin;
47851	admin	logentry
47862	auth	permission
47873	auth	group
47884	auth	user
47895	contenttypes	contenttype
47906	sessions	session
47917	api	address
47928	api	agegroup
47939	api	alertsources
479410	api	alerttype
479511	api	appointmentbooking
479612	api	authgroup
479713	api	authgrouppermissions
479814	api	authpermission
479915	api	authuser
480016	api	authusergroups
480117	api	authuseruserpermissions
480218	api	availablefacilities
480319	api	bookingsources
480420	api	businessregtype
480521	api	city
480622	api	clinicianmemberships
480723	api	clinicians
480824	api	cliniciansdates
480925	api	clinicianseducation
481026	api	cliniciansexperience
481127	api	conditions
481228	api	country
481329	api	couponaccept
481430	api	coupons
481531	api	discountcard
481632	api	discountcardfamily
481733	api	discountcardfamilyextra
481834	api	district
481935	api	djangoadminlog
482036	api	djangocontenttype
482137	api	djangomigrations
482238	api	djangosession
482339	api	facilities
482440	api	facilitiesservices
482541	api	family
482642	api	feedback
482743	api	gender
482844	api	healthcheckbookibg
482945	api	healthchecks
483046	api	healthchecksinclusion
483147	api	healthproviders
483248	api	healthrecords
483349	api	healthseeker
483450	api	healthseekeravailabilities
483551	api	healthseekerhealthrecords
483652	api	interest
483753	api	languages
483854	api	photoalbum
483955	api	plans
484056	api	plansgroups
484157	api	plansgroupsspecialities
484258	api	profession
484359	api	qualification
484460	api	referrelscheme
484561	api	registrationwelcomemessage
484662	api	resellerpackages
484763	api	resellers
484864	api	role
484965	api	salesagentpackages
485066	api	salesagents
485167	api	salestarget
485268	api	speciality
485369	api	sponsors
485470	api	sponsorsgroup
485571	api	state
485672	api	subrole
485773	api	symptoms
485874	api	telephone
485975	api	test
486076	api	testcategory
486177	api	testimonials
486278	api	testsubcategory
486379	api	timeslots
486480	api	users
486581	api	week
486682	api	wellnessplan
486783	api	wellnessplanprofession
486884	api	wellnessplansocialhistory
486985	api	cliniciansspeciality
487086	api	designation
487187	api	healthcheckbooking
487288	api	healthprovidersspeciality
487389	api	healthseekeralerts
487490	api	healthseekertype
487591	api	priyority
487692	api	referrels
487793	api	secretquestions
487894	api	specialitytype
487995	api	trxnappointmentbookings
488096	api	trxncoupons
488197	api	trxndiscountcard
488298	api	trxnhealthcheckbooking
488399	api	trxnpayments
4884\.
4885
4886
4887--
4888-- Name: django_content_type_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
4889--
4890
4891SELECT pg_catalog.setval('django_content_type_id_seq', 99, true);
4892
4893
4894--
4895-- Data for Name: django_migrations; Type: TABLE DATA; Schema: public; Owner: hospital
4896--
4897
4898COPY django_migrations (id, app, name, applied) FROM stdin;
48991	contenttypes	0001_initial	2018-01-12 05:56:51.975509+05:30
49002	auth	0001_initial	2018-01-12 05:56:52.918891+05:30
49013	admin	0001_initial	2018-01-12 05:56:53.118214+05:30
49024	admin	0002_logentry_remove_auto_add	2018-01-12 05:56:53.137038+05:30
49035	api	0001_initial	2018-01-12 05:56:53.313937+05:30
49046	api	0002_cliniciansspeciality_designation_healthcheckbooking_healthprovidersspeciality_healthseekeralerts_hea	2018-01-12 05:56:53.373395+05:30
49057	contenttypes	0002_remove_content_type_name	2018-01-12 05:56:53.47243+05:30
49068	auth	0002_alter_permission_name_max_length	2018-01-12 05:56:53.50552+05:30
49079	auth	0003_alter_user_email_max_length	2018-01-12 05:56:53.538742+05:30
490810	auth	0004_alter_user_username_opts	2018-01-12 05:56:53.563713+05:30
490911	auth	0005_alter_user_last_login_null	2018-01-12 05:56:53.594054+05:30
491012	auth	0006_require_contenttypes_0002	2018-01-12 05:56:53.605149+05:30
491113	auth	0007_alter_validators_add_error_messages	2018-01-12 05:56:53.628113+05:30
491214	auth	0008_alter_user_username_max_length	2018-01-12 05:56:53.716268+05:30
491315	auth	0009_alter_user_last_name_max_length	2018-01-12 05:56:53.749022+05:30
491416	sessions	0001_initial	2018-01-12 05:56:53.948736+05:30
4915\.
4916
4917
4918--
4919-- Name: django_migrations_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
4920--
4921
4922SELECT pg_catalog.setval('django_migrations_id_seq', 16, true);
4923
4924
4925--
4926-- Data for Name: django_session; Type: TABLE DATA; Schema: public; Owner: hospital
4927--
4928
4929COPY django_session (session_key, session_data, expire_date) FROM stdin;
493041rx0ewpqzsn6upalckcl738hwrioi7m	OTU1MmY5YWQyNDA5NWM1MGFjMGUxYzhhOTQ2NTRjMjI2MTgxZjJlMTp7Il9hdXRoX3VzZXJfaWQiOiIxIiwiX2F1dGhfdXNlcl9iYWNrZW5kIjoiZGphbmdvLmNvbnRyaWIuYXV0aC5iYWNrZW5kcy5Nb2RlbEJhY2tlbmQiLCJfYXV0aF91c2VyX2hhc2giOiJmNjFiMDAyYTIyZGJhYTdlY2Q5ODRlOTVlYjY3ZjQ3MjgxY2ViMTJkIn0=	2018-01-26 06:00:02.908946+05:30
4931\.
4932
4933
4934--
4935-- Data for Name: facilities; Type: TABLE DATA; Schema: public; Owner: hospital
4936--
4937
4938COPY facilities (facilities_id, facility, sort_by, status_2) FROM stdin;
4939\.
4940
4941
4942--
4943-- Name: facilities_facilities_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
4944--
4945
4946SELECT pg_catalog.setval('facilities_facilities_id_seq', 1, false);
4947
4948
4949--
4950-- Data for Name: facilities_services; Type: TABLE DATA; Schema: public; Owner: hospital
4951--
4952
4953COPY facilities_services (facilities_services_id, facilities_id, facilities_services, sort_by, status_2) FROM stdin;
4954\.
4955
4956
4957--
4958-- Name: facilities_services_facilities_services_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
4959--
4960
4961SELECT pg_catalog.setval('facilities_services_facilities_services_id_seq', 1, false);
4962
4963
4964--
4965-- Data for Name: family; Type: TABLE DATA; Schema: public; Owner: hospital
4966--
4967
4968COPY family (family_id, family, sort_by, status_2) FROM stdin;
4969\.
4970
4971
4972--
4973-- Name: family_family_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
4974--
4975
4976SELECT pg_catalog.setval('family_family_id_seq', 1, false);
4977
4978
4979--
4980-- Data for Name: feedback; Type: TABLE DATA; Schema: public; Owner: hospital
4981--
4982
4983COPY feedback (feedback_id, users_id, users_feedback, from_2, reg_date, feedbackstatus) FROM stdin;
4984\.
4985
4986
4987--
4988-- Name: feedback_feedback_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
4989--
4990
4991SELECT pg_catalog.setval('feedback_feedback_id_seq', 1, false);
4992
4993
4994--
4995-- Data for Name: gender; Type: TABLE DATA; Schema: public; Owner: hospital
4996--
4997
4998COPY gender (gender_id, gender, sort_by, status_2) FROM stdin;
4999\.
5000
5001
5002--
5003-- Name: gender_gender_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
5004--
5005
5006SELECT pg_catalog.setval('gender_gender_id_seq', 1, false);
5007
5008
5009--
5010-- Data for Name: healthcheckbooking; Type: TABLE DATA; Schema: public; Owner: hospital
5011--
5012
5013COPY healthcheckbooking (healthcheckbooking_id, healthseeker_id, healthproviders_id, bookingsources_id, date, "time", reg_date) FROM stdin;
5014\.
5015
5016
5017--
5018-- Name: healthcheckbooking_healthcheckbooking_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
5019--
5020
5021SELECT pg_catalog.setval('healthcheckbooking_healthcheckbooking_id_seq', 1, false);
5022
5023
5024--
5025-- Data for Name: healthchecks; Type: TABLE DATA; Schema: public; Owner: hospital
5026--
5027
5028COPY healthchecks (healthchecks_id, coupons_id, healthcheck, description, price, promoimage, applicable_sponser) FROM stdin;
5029\.
5030
5031
5032--
5033-- Name: healthchecks_healthchecks_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
5034--
5035
5036SELECT pg_catalog.setval('healthchecks_healthchecks_id_seq', 1, false);
5037
5038
5039--
5040-- Data for Name: healthchecks_inclusion; Type: TABLE DATA; Schema: public; Owner: hospital
5041--
5042
5043COPY healthchecks_inclusion (healthchecks_inclusion_id, test_id, healthchecks_id) FROM stdin;
5044\.
5045
5046
5047--
5048-- Name: healthchecks_inclusion_healthchecks_inclusion_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
5049--
5050
5051SELECT pg_catalog.setval('healthchecks_inclusion_healthchecks_inclusion_id_seq', 1, false);
5052
5053
5054--
5055-- Data for Name: healthproviders; Type: TABLE DATA; Schema: public; Owner: hospital
5056--
5057
5058COPY healthproviders (healthproviders_id, address_id, users_id, is_branch, under_healthproviders_id, display_cost, activefrom, activeto, m_date) FROM stdin;
5059\.
5060
5061
5062--
5063-- Name: healthproviders_healthproviders_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
5064--
5065
5066SELECT pg_catalog.setval('healthproviders_healthproviders_id_seq', 1, false);
5067
5068
5069--
5070-- Data for Name: healthproviders_speciality; Type: TABLE DATA; Schema: public; Owner: hospital
5071--
5072
5073COPY healthproviders_speciality (healthproviders_speciality_id, speciality_id, healthproviders_id, sort_by, speciality_name, speciality_description, price, discountpercentage, activefrom, activeto, status_2, reg_date) FROM stdin;
5074\.
5075
5076
5077--
5078-- Name: healthproviders_speciality_healthproviders_speciality_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
5079--
5080
5081SELECT pg_catalog.setval('healthproviders_speciality_healthproviders_speciality_id_seq', 1, false);
5082
5083
5084--
5085-- Data for Name: healthrecords; Type: TABLE DATA; Schema: public; Owner: hospital
5086--
5087
5088COPY healthrecords (healthrecords_id, healthrecord, sort_by, status_2) FROM stdin;
5089\.
5090
5091
5092--
5093-- Name: healthrecords_healthrecords_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
5094--
5095
5096SELECT pg_catalog.setval('healthrecords_healthrecords_id_seq', 1, false);
5097
5098
5099--
5100-- Data for Name: healthseeker; Type: TABLE DATA; Schema: public; Owner: hospital
5101--
5102
5103COPY healthseeker (healthseeker_id, healthseeker_type_id, profession_id, languages_id, gender_id, users_id, underfamily, undersponser, dob, image) FROM stdin;
5104\.
5105
5106
5107--
5108-- Data for Name: healthseeker_alerts; Type: TABLE DATA; Schema: public; Owner: hospital
5109--
5110
5111COPY healthseeker_alerts (healthseeker_alerts_id, alertsources_id, alerttype_id, healthseeker_id, activefrom, activeto, alert_to) FROM stdin;
5112\.
5113
5114
5115--
5116-- Name: healthseeker_alerts_healthseeker_alerts_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
5117--
5118
5119SELECT pg_catalog.setval('healthseeker_alerts_healthseeker_alerts_id_seq', 1, false);
5120
5121
5122--
5123-- Data for Name: healthseeker_availabilities; Type: TABLE DATA; Schema: public; Owner: hospital
5124--
5125
5126COPY healthseeker_availabilities (healthseeker_availabilities_id, healthchecks_id, discountcard_id, coupons_id, healthseeker_id, amount) FROM stdin;
5127\.
5128
5129
5130--
5131-- Name: healthseeker_availabilities_healthseeker_availabilities_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
5132--
5133
5134SELECT pg_catalog.setval('healthseeker_availabilities_healthseeker_availabilities_id_seq', 1, false);
5135
5136
5137--
5138-- Data for Name: healthseeker_healthrecords; Type: TABLE DATA; Schema: public; Owner: hospital
5139--
5140
5141COPY healthseeker_healthrecords (healthseeker_healthrecords_id, healthrecords_id, healthseeker_id, refdate, file_2, file3, reg_date, m_date) FROM stdin;
5142\.
5143
5144
5145--
5146-- Name: healthseeker_healthrecords_healthseeker_healthrecords_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
5147--
5148
5149SELECT pg_catalog.setval('healthseeker_healthrecords_healthseeker_healthrecords_id_seq', 1, false);
5150
5151
5152--
5153-- Name: healthseeker_healthseeker_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
5154--
5155
5156SELECT pg_catalog.setval('healthseeker_healthseeker_id_seq', 1, false);
5157
5158
5159--
5160-- Data for Name: healthseeker_type; Type: TABLE DATA; Schema: public; Owner: hospital
5161--
5162
5163COPY healthseeker_type (healthseeker_type_id, healthseeker_type) FROM stdin;
5164\.
5165
5166
5167--
5168-- Name: healthseeker_type_healthseeker_type_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
5169--
5170
5171SELECT pg_catalog.setval('healthseeker_type_healthseeker_type_id_seq', 1, false);
5172
5173
5174--
5175-- Data for Name: interest; Type: TABLE DATA; Schema: public; Owner: hospital
5176--
5177
5178COPY interest (interest_id, healthseeker_id, interest, sort_by, status_2) FROM stdin;
5179\.
5180
5181
5182--
5183-- Name: interest_interest_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
5184--
5185
5186SELECT pg_catalog.setval('interest_interest_id_seq', 1, false);
5187
5188
5189--
5190-- Data for Name: languages; Type: TABLE DATA; Schema: public; Owner: hospital
5191--
5192
5193COPY languages (languages_id, language, sort_by, status_2) FROM stdin;
5194\.
5195
5196
5197--
5198-- Name: languages_languages_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
5199--
5200
5201SELECT pg_catalog.setval('languages_languages_id_seq', 1, false);
5202
5203
5204--
5205-- Data for Name: photoalbum; Type: TABLE DATA; Schema: public; Owner: hospital
5206--
5207
5208COPY photoalbum (photoalbum_id, users_id, photo_title, image_path, forusage, sort_by, status_2) FROM stdin;
5209\.
5210
5211
5212--
5213-- Name: photoalbum_photoalbum_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
5214--
5215
5216SELECT pg_catalog.setval('photoalbum_photoalbum_id_seq', 1, false);
5217
5218
5219--
5220-- Data for Name: plans; Type: TABLE DATA; Schema: public; Owner: hospital
5221--
5222
5223COPY plans (plans_id, plans_groups_id, plan, description, price, noofpatients, benefits, share1stconsultation, sharenextconsultation, planworks, addbenfits, cmslicencevalidity, validity, discount1stconsultation, discountnextconsultation, promoimage, applicability, doctorscoupon, reg_date, activefrom, activeto) FROM stdin;
5224\.
5225
5226
5227--
5228-- Data for Name: plans_groups; Type: TABLE DATA; Schema: public; Owner: hospital
5229--
5230
5231COPY plans_groups (plans_groups_id, plans_groups_specialities_id, plans_group, activefrom, activeto) FROM stdin;
5232\.
5233
5234
5235--
5236-- Name: plans_groups_plans_groups_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
5237--
5238
5239SELECT pg_catalog.setval('plans_groups_plans_groups_id_seq', 1, false);
5240
5241
5242--
5243-- Data for Name: plans_groups_specialities; Type: TABLE DATA; Schema: public; Owner: hospital
5244--
5245
5246COPY plans_groups_specialities (plans_groups_specialities_id) FROM stdin;
5247\.
5248
5249
5250--
5251-- Name: plans_groups_specialities_plans_groups_specialities_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
5252--
5253
5254SELECT pg_catalog.setval('plans_groups_specialities_plans_groups_specialities_id_seq', 1, false);
5255
5256
5257--
5258-- Name: plans_plans_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
5259--
5260
5261SELECT pg_catalog.setval('plans_plans_id_seq', 1, false);
5262
5263
5264--
5265-- Data for Name: priyority; Type: TABLE DATA; Schema: public; Owner: hospital
5266--
5267
5268COPY priyority (priyority_id, priyority, sort_by, status_2) FROM stdin;
5269\.
5270
5271
5272--
5273-- Name: priyority_priyority_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
5274--
5275
5276SELECT pg_catalog.setval('priyority_priyority_id_seq', 1, false);
5277
5278
5279--
5280-- Data for Name: profession; Type: TABLE DATA; Schema: public; Owner: hospital
5281--
5282
5283COPY profession (profession_id, poorofession, sort_by, status_2) FROM stdin;
5284\.
5285
5286
5287--
5288-- Name: profession_profession_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
5289--
5290
5291SELECT pg_catalog.setval('profession_profession_id_seq', 1, false);
5292
5293
5294--
5295-- Data for Name: qualification; Type: TABLE DATA; Schema: public; Owner: hospital
5296--
5297
5298COPY qualification (qualification_id, qualification, sort_by, status_2) FROM stdin;
5299\.
5300
5301
5302--
5303-- Name: qualification_qualification_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
5304--
5305
5306SELECT pg_catalog.setval('qualification_qualification_id_seq', 1, false);
5307
5308
5309--
5310-- Data for Name: referrels; Type: TABLE DATA; Schema: public; Owner: hospital
5311--
5312
5313COPY referrels (referrels_id, fromusers_id, referredusers_id, cashback, source, reg_date) FROM stdin;
5314\.
5315
5316
5317--
5318-- Name: referrels_referrels_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
5319--
5320
5321SELECT pg_catalog.setval('referrels_referrels_id_seq', 1, false);
5322
5323
5324--
5325-- Data for Name: referrelscheme; Type: TABLE DATA; Schema: public; Owner: hospital
5326--
5327
5328COPY referrelscheme (referrelscheme_id, title, noofreferels, cashback) FROM stdin;
5329\.
5330
5331
5332--
5333-- Name: referrelscheme_referrelscheme_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
5334--
5335
5336SELECT pg_catalog.setval('referrelscheme_referrelscheme_id_seq', 1, false);
5337
5338
5339--
5340-- Data for Name: registration_welcome_message; Type: TABLE DATA; Schema: public; Owner: hospital
5341--
5342
5343COPY registration_welcome_message (registration_welcome_message_id, registration_welcome_message, sort_by, status_2, reg_date, activefrom, activeto, m_user, c_user, m_date) FROM stdin;
5344\.
5345
5346
5347--
5348-- Name: registration_welcome_message_registration_welcome_message_i_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
5349--
5350
5351SELECT pg_catalog.setval('registration_welcome_message_registration_welcome_message_i_seq', 1, false);
5352
5353
5354--
5355-- Data for Name: resellerpackages; Type: TABLE DATA; Schema: public; Owner: hospital
5356--
5357
5358COPY resellerpackages (resellerpackages_id, salestarget_id, packagename, price, noofdiscountcards, packagetype, validity, campaignvalidfrom, campaignvalidto) FROM stdin;
5359\.
5360
5361
5362--
5363-- Name: resellerpackages_resellerpackages_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
5364--
5365
5366SELECT pg_catalog.setval('resellerpackages_resellerpackages_id_seq', 1, false);
5367
5368
5369--
5370-- Data for Name: resellers; Type: TABLE DATA; Schema: public; Owner: hospital
5371--
5372
5373COPY resellers (resellers_id, users_id, fathername, relationofsalesagents, idproof, serviceoffered, seviceagreementimage) FROM stdin;
5374\.
5375
5376
5377--
5378-- Name: resellers_resellers_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
5379--
5380
5381SELECT pg_catalog.setval('resellers_resellers_id_seq', 1, false);
5382
5383
5384--
5385-- Data for Name: role; Type: TABLE DATA; Schema: public; Owner: hospital
5386--
5387
5388COPY role (role_id, role, sort_by, status_2, roleocode) FROM stdin;
5389\.
5390
5391
5392--
5393-- Name: role_role_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
5394--
5395
5396SELECT pg_catalog.setval('role_role_id_seq', 1, false);
5397
5398
5399--
5400-- Data for Name: salesagentpackages; Type: TABLE DATA; Schema: public; Owner: hospital
5401--
5402
5403COPY salesagentpackages (salesagentpackages_id, salestarget_id, packagename, price, noofdiscountcards, packagetype, validity, campaignvalidfrom, campaignvalidto) FROM stdin;
5404\.
5405
5406
5407--
5408-- Name: salesagentpackages_salesagentpackages_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
5409--
5410
5411SELECT pg_catalog.setval('salesagentpackages_salesagentpackages_id_seq', 1, false);
5412
5413
5414--
5415-- Data for Name: salesagents; Type: TABLE DATA; Schema: public; Owner: hospital
5416--
5417
5418COPY salesagents (salesagents_id, users_id, agencyname, registrationdate, registrationno, registrationproof, authorizedpersonproof, serviceoffered, minimumnoresellers, serviceproposal, ndaagreemert, ndaagreementproof, agreementstarts, agreementends, serviceagreementimage) FROM stdin;
5419\.
5420
5421
5422--
5423-- Name: salesagents_salesagents_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
5424--
5425
5426SELECT pg_catalog.setval('salesagents_salesagents_id_seq', 1, false);
5427
5428
5429--
5430-- Data for Name: salestarget; Type: TABLE DATA; Schema: public; Owner: hospital
5431--
5432
5433COPY salestarget (salestarget_id, salestarget, noofsales, days, addextracards) FROM stdin;
5434\.
5435
5436
5437--
5438-- Name: salestarget_salestarget_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
5439--
5440
5441SELECT pg_catalog.setval('salestarget_salestarget_id_seq', 1, false);
5442
5443
5444--
5445-- Data for Name: secretquestions; Type: TABLE DATA; Schema: public; Owner: hospital
5446--
5447
5448COPY secretquestions (secretquestions_id, secretquestion, sort_by, status_2) FROM stdin;
5449\.
5450
5451
5452--
5453-- Name: secretquestions_secretquestions_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
5454--
5455
5456SELECT pg_catalog.setval('secretquestions_secretquestions_id_seq', 1, false);
5457
5458
5459--
5460-- Data for Name: speciality; Type: TABLE DATA; Schema: public; Owner: hospital
5461--
5462
5463COPY speciality (speciality_id, speciality_type_id, qualification_id, speciality, sort_by, status_2) FROM stdin;
5464\.
5465
5466
5467--
5468-- Name: speciality_speciality_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
5469--
5470
5471SELECT pg_catalog.setval('speciality_speciality_id_seq', 1, false);
5472
5473
5474--
5475-- Data for Name: speciality_type; Type: TABLE DATA; Schema: public; Owner: hospital
5476--
5477
5478COPY speciality_type (speciality_type_id, speciality_type_name, sort_by, status_2) FROM stdin;
5479\.
5480
5481
5482--
5483-- Name: speciality_type_speciality_type_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
5484--
5485
5486SELECT pg_catalog.setval('speciality_type_speciality_type_id_seq', 1, false);
5487
5488
5489--
5490-- Data for Name: sponsors; Type: TABLE DATA; Schema: public; Owner: hospital
5491--
5492
5493COPY sponsors (sponsors_id, sponsors_group_id, users_id, businessregtype_id, organizationname, groupsize, designation, image, operatinghours, oprtainglocation, website, requiredlocation, activefrom, activeto) FROM stdin;
5494\.
5495
5496
5497--
5498-- Data for Name: sponsors_group; Type: TABLE DATA; Schema: public; Owner: hospital
5499--
5500
5501COPY sponsors_group (sponsors_group_id, sponsors_group, sort_by, status_2) FROM stdin;
5502\.
5503
5504
5505--
5506-- Name: sponsors_group_sponsors_group_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
5507--
5508
5509SELECT pg_catalog.setval('sponsors_group_sponsors_group_id_seq', 1, false);
5510
5511
5512--
5513-- Name: sponsors_sponsors_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
5514--
5515
5516SELECT pg_catalog.setval('sponsors_sponsors_id_seq', 1, false);
5517
5518
5519--
5520-- Data for Name: state; Type: TABLE DATA; Schema: public; Owner: hospital
5521--
5522
5523COPY state (state_id, state, sort_by, status_2) FROM stdin;
5524\.
5525
5526
5527--
5528-- Name: state_state_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
5529--
5530
5531SELECT pg_catalog.setval('state_state_id_seq', 1, false);
5532
5533
5534--
5535-- Data for Name: symptoms; Type: TABLE DATA; Schema: public; Owner: hospital
5536--
5537
5538COPY symptoms (symptoms_id, speciality_id, symptoms, sort_by, status_2) FROM stdin;
5539\.
5540
5541
5542--
5543-- Name: symptoms_symptoms_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
5544--
5545
5546SELECT pg_catalog.setval('symptoms_symptoms_id_seq', 1, false);
5547
5548
5549--
5550-- Data for Name: telephone; Type: TABLE DATA; Schema: public; Owner: hospital
5551--
5552
5553COPY telephone (telephone_id, address_id, phone, sort_by, status_2) FROM stdin;
5554\.
5555
5556
5557--
5558-- Name: telephone_telephone_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
5559--
5560
5561SELECT pg_catalog.setval('telephone_telephone_id_seq', 1, false);
5562
5563
5564--
5565-- Data for Name: test; Type: TABLE DATA; Schema: public; Owner: hospital
5566--
5567
5568COPY test (test_id, test_subcategory_id, test_category_id, test, description) FROM stdin;
5569\.
5570
5571
5572--
5573-- Data for Name: test_category; Type: TABLE DATA; Schema: public; Owner: hospital
5574--
5575
5576COPY test_category (test_category_id, test_category, description) FROM stdin;
5577\.
5578
5579
5580--
5581-- Name: test_category_test_category_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
5582--
5583
5584SELECT pg_catalog.setval('test_category_test_category_id_seq', 1, false);
5585
5586
5587--
5588-- Data for Name: test_subcategory; Type: TABLE DATA; Schema: public; Owner: hospital
5589--
5590
5591COPY test_subcategory (test_subcategory_id, test_category_id, subcategory, description) FROM stdin;
5592\.
5593
5594
5595--
5596-- Name: test_subcategory_test_subcategory_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
5597--
5598
5599SELECT pg_catalog.setval('test_subcategory_test_subcategory_id_seq', 1, false);
5600
5601
5602--
5603-- Name: test_test_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
5604--
5605
5606SELECT pg_catalog.setval('test_test_id_seq', 1, false);
5607
5608
5609--
5610-- Data for Name: testimonials; Type: TABLE DATA; Schema: public; Owner: hospital
5611--
5612
5613COPY testimonials (testimonials_id, users_id, testimonial, image, video, status_2, activefrom, activeto, reg_date) FROM stdin;
5614\.
5615
5616
5617--
5618-- Name: testimonials_testimonials_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
5619--
5620
5621SELECT pg_catalog.setval('testimonials_testimonials_id_seq', 1, false);
5622
5623
5624--
5625-- Data for Name: timeslots; Type: TABLE DATA; Schema: public; Owner: hospital
5626--
5627
5628COPY timeslots (timeslots_id, timeslots, fromslot, toslot, sort_by, status_2) FROM stdin;
5629\.
5630
5631
5632--
5633-- Name: timeslots_timeslots_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
5634--
5635
5636SELECT pg_catalog.setval('timeslots_timeslots_id_seq', 1, false);
5637
5638
5639--
5640-- Data for Name: trxn_appointmentbookings; Type: TABLE DATA; Schema: public; Owner: hospital
5641--
5642
5643COPY trxn_appointmentbookings (trxn_appointmentbookings_id, appointmentbooking_date, appointmentbooking_id, status_2, session_activity, ip, trxn_by, reg_date) FROM stdin;
5644\.
5645
5646
5647--
5648-- Name: trxn_appointmentbookings_trxn_appointmentbookings_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
5649--
5650
5651SELECT pg_catalog.setval('trxn_appointmentbookings_trxn_appointmentbookings_id_seq', 1, false);
5652
5653
5654--
5655-- Data for Name: trxn_coupons; Type: TABLE DATA; Schema: public; Owner: hospital
5656--
5657
5658COPY trxn_coupons (trxn_coupons_id, coupons_id, status_2, sessionactivity, ip, trxn_by, reg_date) FROM stdin;
5659\.
5660
5661
5662--
5663-- Name: trxn_coupons_trxn_coupons_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
5664--
5665
5666SELECT pg_catalog.setval('trxn_coupons_trxn_coupons_id_seq', 1, false);
5667
5668
5669--
5670-- Data for Name: trxn_discountcard; Type: TABLE DATA; Schema: public; Owner: hospital
5671--
5672
5673COPY trxn_discountcard (trxn_discountcard_id, discountcard_id, status_2, sessionactivity, ip, trxn_by, reg_date) FROM stdin;
5674\.
5675
5676
5677--
5678-- Name: trxn_discountcard_trxn_discountcard_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
5679--
5680
5681SELECT pg_catalog.setval('trxn_discountcard_trxn_discountcard_id_seq', 1, false);
5682
5683
5684--
5685-- Data for Name: trxn_healthcheckbooking; Type: TABLE DATA; Schema: public; Owner: hospital
5686--
5687
5688COPY trxn_healthcheckbooking (trxn_healthcheckbooking_id, healthcheckbooking_id, status_2, sessionactivity, ip, trxn_by, reg_date) FROM stdin;
5689\.
5690
5691
5692--
5693-- Name: trxn_healthcheckbooking_trxn_healthcheckbooking_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
5694--
5695
5696SELECT pg_catalog.setval('trxn_healthcheckbooking_trxn_healthcheckbooking_id_seq', 1, false);
5697
5698
5699--
5700-- Data for Name: trxn_payments; Type: TABLE DATA; Schema: public; Owner: hospital
5701--
5702
5703COPY trxn_payments (trxn_payments_id, amount, status_2, paymentfor, for_id, ip, trxn_by, reg_date) FROM stdin;
5704\.
5705
5706
5707--
5708-- Name: trxn_payments_trxn_payments_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
5709--
5710
5711SELECT pg_catalog.setval('trxn_payments_trxn_payments_id_seq', 1, false);
5712
5713
5714--
5715-- Data for Name: users; Type: TABLE DATA; Schema: public; Owner: hospital
5716--
5717
5718COPY users (users_id, secretquestions_id, role_id, mobile, email, firstname, lastname, middlename, enc_password, verified, pw_request, user_status, reg_date, reg_by, m_date, m_by, failure_attempts, secretanswer, ipaddress, macaddress) FROM stdin;
5719\.
5720
5721
5722--
5723-- Name: users_users_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
5724--
5725
5726SELECT pg_catalog.setval('users_users_id_seq', 1, false);
5727
5728
5729--
5730-- Data for Name: week; Type: TABLE DATA; Schema: public; Owner: hospital
5731--
5732
5733COPY week (week_id, week, sort_by, status_2) FROM stdin;
5734\.
5735
5736
5737--
5738-- Name: week_week_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
5739--
5740
5741SELECT pg_catalog.setval('week_week_id_seq', 1, false);
5742
5743
5744--
5745-- Data for Name: wellnessplan; Type: TABLE DATA; Schema: public; Owner: hospital
5746--
5747
5748COPY wellnessplan (wellnessplan_id, wellnessplan_socialhistory_id, wellnessplan_profession_id, conditions_id, agegroup_id, medicalhistory, surgicalhistory) FROM stdin;
5749\.
5750
5751
5752--
5753-- Data for Name: wellnessplan_profession; Type: TABLE DATA; Schema: public; Owner: hospital
5754--
5755
5756COPY wellnessplan_profession (wellnessplan_profession_id, wellnessplan_profession, sort_by, status_2) FROM stdin;
5757\.
5758
5759
5760--
5761-- Name: wellnessplan_profession_wellnessplan_profession_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
5762--
5763
5764SELECT pg_catalog.setval('wellnessplan_profession_wellnessplan_profession_id_seq', 1, false);
5765
5766
5767--
5768-- Data for Name: wellnessplan_socialhistory; Type: TABLE DATA; Schema: public; Owner: hospital
5769--
5770
5771COPY wellnessplan_socialhistory (wellnessplan_socialhistory_id, wellnessplan_socialhistory, sort_by, status_2) FROM stdin;
5772\.
5773
5774
5775--
5776-- Name: wellnessplan_socialhistory_wellnessplan_socialhistory_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
5777--
5778
5779SELECT pg_catalog.setval('wellnessplan_socialhistory_wellnessplan_socialhistory_id_seq', 1, false);
5780
5781
5782--
5783-- Name: wellnessplan_wellnessplan_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hospital
5784--
5785
5786SELECT pg_catalog.setval('wellnessplan_wellnessplan_id_seq', 1, false);
5787
5788
5789--
5790-- Name: address address_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
5791--
5792
5793ALTER TABLE ONLY address
5794    ADD CONSTRAINT address_pkey PRIMARY KEY (address_id);
5795
5796
5797--
5798-- Name: agegroup agegroup_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
5799--
5800
5801ALTER TABLE ONLY agegroup
5802    ADD CONSTRAINT agegroup_pkey PRIMARY KEY (agegroup_id);
5803
5804
5805--
5806-- Name: alertsources alertsources_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
5807--
5808
5809ALTER TABLE ONLY alertsources
5810    ADD CONSTRAINT alertsources_pkey PRIMARY KEY (alertsources_id);
5811
5812
5813--
5814-- Name: alerttype alerttype_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
5815--
5816
5817ALTER TABLE ONLY alerttype
5818    ADD CONSTRAINT alerttype_pkey PRIMARY KEY (alerttype_id);
5819
5820
5821--
5822-- Name: appointmentbooking appointmentbooking_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
5823--
5824
5825ALTER TABLE ONLY appointmentbooking
5826    ADD CONSTRAINT appointmentbooking_pkey PRIMARY KEY (appointmentbooking_id, date);
5827
5828
5829--
5830-- Name: auth_group auth_group_name_key; Type: CONSTRAINT; Schema: public; Owner: hospital
5831--
5832
5833ALTER TABLE ONLY auth_group
5834    ADD CONSTRAINT auth_group_name_key UNIQUE (name);
5835
5836
5837--
5838-- Name: auth_group_permissions auth_group_permissions_group_id_permission_id_0cd325b0_uniq; Type: CONSTRAINT; Schema: public; Owner: hospital
5839--
5840
5841ALTER TABLE ONLY auth_group_permissions
5842    ADD CONSTRAINT auth_group_permissions_group_id_permission_id_0cd325b0_uniq UNIQUE (group_id, permission_id);
5843
5844
5845--
5846-- Name: auth_group_permissions auth_group_permissions_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
5847--
5848
5849ALTER TABLE ONLY auth_group_permissions
5850    ADD CONSTRAINT auth_group_permissions_pkey PRIMARY KEY (id);
5851
5852
5853--
5854-- Name: auth_group auth_group_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
5855--
5856
5857ALTER TABLE ONLY auth_group
5858    ADD CONSTRAINT auth_group_pkey PRIMARY KEY (id);
5859
5860
5861--
5862-- Name: auth_permission auth_permission_content_type_id_codename_01ab375a_uniq; Type: CONSTRAINT; Schema: public; Owner: hospital
5863--
5864
5865ALTER TABLE ONLY auth_permission
5866    ADD CONSTRAINT auth_permission_content_type_id_codename_01ab375a_uniq UNIQUE (content_type_id, codename);
5867
5868
5869--
5870-- Name: auth_permission auth_permission_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
5871--
5872
5873ALTER TABLE ONLY auth_permission
5874    ADD CONSTRAINT auth_permission_pkey PRIMARY KEY (id);
5875
5876
5877--
5878-- Name: auth_user_groups auth_user_groups_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
5879--
5880
5881ALTER TABLE ONLY auth_user_groups
5882    ADD CONSTRAINT auth_user_groups_pkey PRIMARY KEY (id);
5883
5884
5885--
5886-- Name: auth_user_groups auth_user_groups_user_id_group_id_94350c0c_uniq; Type: CONSTRAINT; Schema: public; Owner: hospital
5887--
5888
5889ALTER TABLE ONLY auth_user_groups
5890    ADD CONSTRAINT auth_user_groups_user_id_group_id_94350c0c_uniq UNIQUE (user_id, group_id);
5891
5892
5893--
5894-- Name: auth_user auth_user_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
5895--
5896
5897ALTER TABLE ONLY auth_user
5898    ADD CONSTRAINT auth_user_pkey PRIMARY KEY (id);
5899
5900
5901--
5902-- Name: auth_user_user_permissions auth_user_user_permissions_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
5903--
5904
5905ALTER TABLE ONLY auth_user_user_permissions
5906    ADD CONSTRAINT auth_user_user_permissions_pkey PRIMARY KEY (id);
5907
5908
5909--
5910-- Name: auth_user_user_permissions auth_user_user_permissions_user_id_permission_id_14a6b632_uniq; Type: CONSTRAINT; Schema: public; Owner: hospital
5911--
5912
5913ALTER TABLE ONLY auth_user_user_permissions
5914    ADD CONSTRAINT auth_user_user_permissions_user_id_permission_id_14a6b632_uniq UNIQUE (user_id, permission_id);
5915
5916
5917--
5918-- Name: auth_user auth_user_username_key; Type: CONSTRAINT; Schema: public; Owner: hospital
5919--
5920
5921ALTER TABLE ONLY auth_user
5922    ADD CONSTRAINT auth_user_username_key UNIQUE (username);
5923
5924
5925--
5926-- Name: availablefacilities availablefacilities_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
5927--
5928
5929ALTER TABLE ONLY availablefacilities
5930    ADD CONSTRAINT availablefacilities_pkey PRIMARY KEY (availablefacilities_id);
5931
5932
5933--
5934-- Name: bookingsources bookingsources_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
5935--
5936
5937ALTER TABLE ONLY bookingsources
5938    ADD CONSTRAINT bookingsources_pkey PRIMARY KEY (bookingsources_id);
5939
5940
5941--
5942-- Name: businessregtype businessregtype_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
5943--
5944
5945ALTER TABLE ONLY businessregtype
5946    ADD CONSTRAINT businessregtype_pkey PRIMARY KEY (businessregtype_id);
5947
5948
5949--
5950-- Name: city city_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
5951--
5952
5953ALTER TABLE ONLY city
5954    ADD CONSTRAINT city_pkey PRIMARY KEY (city_id);
5955
5956
5957--
5958-- Name: clinician_memberships clinician_memberships_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
5959--
5960
5961ALTER TABLE ONLY clinician_memberships
5962    ADD CONSTRAINT clinician_memberships_pkey PRIMARY KEY (clinician_memberships_id);
5963
5964
5965--
5966-- Name: clinicians_dates clinicians_dates_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
5967--
5968
5969ALTER TABLE ONLY clinicians_dates
5970    ADD CONSTRAINT clinicians_dates_pkey PRIMARY KEY (clinicians_dates_id);
5971
5972
5973--
5974-- Name: clinicians_education clinicians_education_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
5975--
5976
5977ALTER TABLE ONLY clinicians_education
5978    ADD CONSTRAINT clinicians_education_pkey PRIMARY KEY (clinicians_education_id);
5979
5980
5981--
5982-- Name: clinicians_experience clinicians_experience_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
5983--
5984
5985ALTER TABLE ONLY clinicians_experience
5986    ADD CONSTRAINT clinicians_experience_pkey PRIMARY KEY (clinicians_experience_id);
5987
5988
5989--
5990-- Name: clinicians clinicians_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
5991--
5992
5993ALTER TABLE ONLY clinicians
5994    ADD CONSTRAINT clinicians_pkey PRIMARY KEY (clinicians_id);
5995
5996
5997--
5998-- Name: clinicians_speciality clinicians_speciality_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
5999--
6000
6001ALTER TABLE ONLY clinicians_speciality
6002    ADD CONSTRAINT clinicians_speciality_pkey PRIMARY KEY (clinicians_speciality_id);
6003
6004
6005--
6006-- Name: conditions conditions_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
6007--
6008
6009ALTER TABLE ONLY conditions
6010    ADD CONSTRAINT conditions_pkey PRIMARY KEY (conditions_id);
6011
6012
6013--
6014-- Name: country country_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
6015--
6016
6017ALTER TABLE ONLY country
6018    ADD CONSTRAINT country_pkey PRIMARY KEY (country_id);
6019
6020
6021--
6022-- Name: couponaccept couponaccept_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
6023--
6024
6025ALTER TABLE ONLY couponaccept
6026    ADD CONSTRAINT couponaccept_pkey PRIMARY KEY (couponaccept_id);
6027
6028
6029--
6030-- Name: coupons coupons_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
6031--
6032
6033ALTER TABLE ONLY coupons
6034    ADD CONSTRAINT coupons_pkey PRIMARY KEY (coupons_id);
6035
6036
6037--
6038-- Name: designation designation_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
6039--
6040
6041ALTER TABLE ONLY designation
6042    ADD CONSTRAINT designation_pkey PRIMARY KEY (designation_id);
6043
6044
6045--
6046-- Name: discountcard_family_extra discountcard_family_extra_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
6047--
6048
6049ALTER TABLE ONLY discountcard_family_extra
6050    ADD CONSTRAINT discountcard_family_extra_pkey PRIMARY KEY (discountcard_family_extra_id);
6051
6052
6053--
6054-- Name: discountcard_family discountcard_family_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
6055--
6056
6057ALTER TABLE ONLY discountcard_family
6058    ADD CONSTRAINT discountcard_family_pkey PRIMARY KEY (discountcard_family_id);
6059
6060
6061--
6062-- Name: discountcard discountcard_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
6063--
6064
6065ALTER TABLE ONLY discountcard
6066    ADD CONSTRAINT discountcard_pkey PRIMARY KEY (discountcard_id);
6067
6068
6069--
6070-- Name: district district_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
6071--
6072
6073ALTER TABLE ONLY district
6074    ADD CONSTRAINT district_pkey PRIMARY KEY (district_id);
6075
6076
6077--
6078-- Name: django_admin_log django_admin_log_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
6079--
6080
6081ALTER TABLE ONLY django_admin_log
6082    ADD CONSTRAINT django_admin_log_pkey PRIMARY KEY (id);
6083
6084
6085--
6086-- Name: django_content_type django_content_type_app_label_model_76bd3d3b_uniq; Type: CONSTRAINT; Schema: public; Owner: hospital
6087--
6088
6089ALTER TABLE ONLY django_content_type
6090    ADD CONSTRAINT django_content_type_app_label_model_76bd3d3b_uniq UNIQUE (app_label, model);
6091
6092
6093--
6094-- Name: django_content_type django_content_type_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
6095--
6096
6097ALTER TABLE ONLY django_content_type
6098    ADD CONSTRAINT django_content_type_pkey PRIMARY KEY (id);
6099
6100
6101--
6102-- Name: django_migrations django_migrations_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
6103--
6104
6105ALTER TABLE ONLY django_migrations
6106    ADD CONSTRAINT django_migrations_pkey PRIMARY KEY (id);
6107
6108
6109--
6110-- Name: django_session django_session_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
6111--
6112
6113ALTER TABLE ONLY django_session
6114    ADD CONSTRAINT django_session_pkey PRIMARY KEY (session_key);
6115
6116
6117--
6118-- Name: facilities facilities_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
6119--
6120
6121ALTER TABLE ONLY facilities
6122    ADD CONSTRAINT facilities_pkey PRIMARY KEY (facilities_id);
6123
6124
6125--
6126-- Name: facilities_services facilities_services_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
6127--
6128
6129ALTER TABLE ONLY facilities_services
6130    ADD CONSTRAINT facilities_services_pkey PRIMARY KEY (facilities_services_id);
6131
6132
6133--
6134-- Name: family family_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
6135--
6136
6137ALTER TABLE ONLY family
6138    ADD CONSTRAINT family_pkey PRIMARY KEY (family_id);
6139
6140
6141--
6142-- Name: feedback feedback_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
6143--
6144
6145ALTER TABLE ONLY feedback
6146    ADD CONSTRAINT feedback_pkey PRIMARY KEY (feedback_id);
6147
6148
6149--
6150-- Name: gender gender_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
6151--
6152
6153ALTER TABLE ONLY gender
6154    ADD CONSTRAINT gender_pkey PRIMARY KEY (gender_id);
6155
6156
6157--
6158-- Name: healthcheckbooking healthcheckbooking_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
6159--
6160
6161ALTER TABLE ONLY healthcheckbooking
6162    ADD CONSTRAINT healthcheckbooking_pkey PRIMARY KEY (healthcheckbooking_id);
6163
6164
6165--
6166-- Name: healthchecks_inclusion healthchecks_inclusion_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
6167--
6168
6169ALTER TABLE ONLY healthchecks_inclusion
6170    ADD CONSTRAINT healthchecks_inclusion_pkey PRIMARY KEY (healthchecks_inclusion_id);
6171
6172
6173--
6174-- Name: healthchecks healthchecks_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
6175--
6176
6177ALTER TABLE ONLY healthchecks
6178    ADD CONSTRAINT healthchecks_pkey PRIMARY KEY (healthchecks_id);
6179
6180
6181--
6182-- Name: healthproviders healthproviders_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
6183--
6184
6185ALTER TABLE ONLY healthproviders
6186    ADD CONSTRAINT healthproviders_pkey PRIMARY KEY (healthproviders_id);
6187
6188
6189--
6190-- Name: healthproviders_speciality healthproviders_speciality_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
6191--
6192
6193ALTER TABLE ONLY healthproviders_speciality
6194    ADD CONSTRAINT healthproviders_speciality_pkey PRIMARY KEY (healthproviders_speciality_id);
6195
6196
6197--
6198-- Name: healthrecords healthrecords_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
6199--
6200
6201ALTER TABLE ONLY healthrecords
6202    ADD CONSTRAINT healthrecords_pkey PRIMARY KEY (healthrecords_id);
6203
6204
6205--
6206-- Name: healthseeker_alerts healthseeker_alerts_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
6207--
6208
6209ALTER TABLE ONLY healthseeker_alerts
6210    ADD CONSTRAINT healthseeker_alerts_pkey PRIMARY KEY (healthseeker_alerts_id);
6211
6212
6213--
6214-- Name: healthseeker_availabilities healthseeker_availabilities_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
6215--
6216
6217ALTER TABLE ONLY healthseeker_availabilities
6218    ADD CONSTRAINT healthseeker_availabilities_pkey PRIMARY KEY (healthseeker_availabilities_id);
6219
6220
6221--
6222-- Name: healthseeker_healthrecords healthseeker_healthrecords_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
6223--
6224
6225ALTER TABLE ONLY healthseeker_healthrecords
6226    ADD CONSTRAINT healthseeker_healthrecords_pkey PRIMARY KEY (healthseeker_healthrecords_id);
6227
6228
6229--
6230-- Name: healthseeker healthseeker_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
6231--
6232
6233ALTER TABLE ONLY healthseeker
6234    ADD CONSTRAINT healthseeker_pkey PRIMARY KEY (healthseeker_id);
6235
6236
6237--
6238-- Name: healthseeker_type healthseeker_type_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
6239--
6240
6241ALTER TABLE ONLY healthseeker_type
6242    ADD CONSTRAINT healthseeker_type_pkey PRIMARY KEY (healthseeker_type_id);
6243
6244
6245--
6246-- Name: interest interest_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
6247--
6248
6249ALTER TABLE ONLY interest
6250    ADD CONSTRAINT interest_pkey PRIMARY KEY (interest_id);
6251
6252
6253--
6254-- Name: languages languages_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
6255--
6256
6257ALTER TABLE ONLY languages
6258    ADD CONSTRAINT languages_pkey PRIMARY KEY (languages_id);
6259
6260
6261--
6262-- Name: photoalbum photoalbum_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
6263--
6264
6265ALTER TABLE ONLY photoalbum
6266    ADD CONSTRAINT photoalbum_pkey PRIMARY KEY (photoalbum_id);
6267
6268
6269--
6270-- Name: plans_groups plans_groups_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
6271--
6272
6273ALTER TABLE ONLY plans_groups
6274    ADD CONSTRAINT plans_groups_pkey PRIMARY KEY (plans_groups_id);
6275
6276
6277--
6278-- Name: plans_groups_specialities plans_groups_specialities_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
6279--
6280
6281ALTER TABLE ONLY plans_groups_specialities
6282    ADD CONSTRAINT plans_groups_specialities_pkey PRIMARY KEY (plans_groups_specialities_id);
6283
6284
6285--
6286-- Name: plans plans_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
6287--
6288
6289ALTER TABLE ONLY plans
6290    ADD CONSTRAINT plans_pkey PRIMARY KEY (plans_id);
6291
6292
6293--
6294-- Name: priyority priyority_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
6295--
6296
6297ALTER TABLE ONLY priyority
6298    ADD CONSTRAINT priyority_pkey PRIMARY KEY (priyority_id);
6299
6300
6301--
6302-- Name: profession profession_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
6303--
6304
6305ALTER TABLE ONLY profession
6306    ADD CONSTRAINT profession_pkey PRIMARY KEY (profession_id);
6307
6308
6309--
6310-- Name: qualification qualification_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
6311--
6312
6313ALTER TABLE ONLY qualification
6314    ADD CONSTRAINT qualification_pkey PRIMARY KEY (qualification_id);
6315
6316
6317--
6318-- Name: referrels referrels_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
6319--
6320
6321ALTER TABLE ONLY referrels
6322    ADD CONSTRAINT referrels_pkey PRIMARY KEY (referrels_id);
6323
6324
6325--
6326-- Name: referrelscheme referrelscheme_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
6327--
6328
6329ALTER TABLE ONLY referrelscheme
6330    ADD CONSTRAINT referrelscheme_pkey PRIMARY KEY (referrelscheme_id);
6331
6332
6333--
6334-- Name: registration_welcome_message registration_welcome_message_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
6335--
6336
6337ALTER TABLE ONLY registration_welcome_message
6338    ADD CONSTRAINT registration_welcome_message_pkey PRIMARY KEY (registration_welcome_message_id);
6339
6340
6341--
6342-- Name: resellerpackages resellerpackages_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
6343--
6344
6345ALTER TABLE ONLY resellerpackages
6346    ADD CONSTRAINT resellerpackages_pkey PRIMARY KEY (resellerpackages_id);
6347
6348
6349--
6350-- Name: resellers resellers_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
6351--
6352
6353ALTER TABLE ONLY resellers
6354    ADD CONSTRAINT resellers_pkey PRIMARY KEY (resellers_id);
6355
6356
6357--
6358-- Name: role role_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
6359--
6360
6361ALTER TABLE ONLY role
6362    ADD CONSTRAINT role_pkey PRIMARY KEY (role_id);
6363
6364
6365--
6366-- Name: salesagentpackages salesagentpackages_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
6367--
6368
6369ALTER TABLE ONLY salesagentpackages
6370    ADD CONSTRAINT salesagentpackages_pkey PRIMARY KEY (salesagentpackages_id);
6371
6372
6373--
6374-- Name: salesagents salesagents_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
6375--
6376
6377ALTER TABLE ONLY salesagents
6378    ADD CONSTRAINT salesagents_pkey PRIMARY KEY (salesagents_id);
6379
6380
6381--
6382-- Name: salestarget salestarget_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
6383--
6384
6385ALTER TABLE ONLY salestarget
6386    ADD CONSTRAINT salestarget_pkey PRIMARY KEY (salestarget_id);
6387
6388
6389--
6390-- Name: secretquestions secretquestions_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
6391--
6392
6393ALTER TABLE ONLY secretquestions
6394    ADD CONSTRAINT secretquestions_pkey PRIMARY KEY (secretquestions_id);
6395
6396
6397--
6398-- Name: speciality speciality_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
6399--
6400
6401ALTER TABLE ONLY speciality
6402    ADD CONSTRAINT speciality_pkey PRIMARY KEY (speciality_id);
6403
6404
6405--
6406-- Name: speciality_type speciality_type_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
6407--
6408
6409ALTER TABLE ONLY speciality_type
6410    ADD CONSTRAINT speciality_type_pkey PRIMARY KEY (speciality_type_id);
6411
6412
6413--
6414-- Name: sponsors_group sponsors_group_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
6415--
6416
6417ALTER TABLE ONLY sponsors_group
6418    ADD CONSTRAINT sponsors_group_pkey PRIMARY KEY (sponsors_group_id);
6419
6420
6421--
6422-- Name: sponsors sponsors_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
6423--
6424
6425ALTER TABLE ONLY sponsors
6426    ADD CONSTRAINT sponsors_pkey PRIMARY KEY (sponsors_id);
6427
6428
6429--
6430-- Name: state state_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
6431--
6432
6433ALTER TABLE ONLY state
6434    ADD CONSTRAINT state_pkey PRIMARY KEY (state_id);
6435
6436
6437--
6438-- Name: symptoms symptoms_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
6439--
6440
6441ALTER TABLE ONLY symptoms
6442    ADD CONSTRAINT symptoms_pkey PRIMARY KEY (symptoms_id);
6443
6444
6445--
6446-- Name: telephone telephone_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
6447--
6448
6449ALTER TABLE ONLY telephone
6450    ADD CONSTRAINT telephone_pkey PRIMARY KEY (telephone_id);
6451
6452
6453--
6454-- Name: test_category test_category_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
6455--
6456
6457ALTER TABLE ONLY test_category
6458    ADD CONSTRAINT test_category_pkey PRIMARY KEY (test_category_id);
6459
6460
6461--
6462-- Name: test test_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
6463--
6464
6465ALTER TABLE ONLY test
6466    ADD CONSTRAINT test_pkey PRIMARY KEY (test_id);
6467
6468
6469--
6470-- Name: test_subcategory test_subcategory_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
6471--
6472
6473ALTER TABLE ONLY test_subcategory
6474    ADD CONSTRAINT test_subcategory_pkey PRIMARY KEY (test_subcategory_id);
6475
6476
6477--
6478-- Name: testimonials testimonials_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
6479--
6480
6481ALTER TABLE ONLY testimonials
6482    ADD CONSTRAINT testimonials_pkey PRIMARY KEY (testimonials_id);
6483
6484
6485--
6486-- Name: timeslots timeslots_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
6487--
6488
6489ALTER TABLE ONLY timeslots
6490    ADD CONSTRAINT timeslots_pkey PRIMARY KEY (timeslots_id);
6491
6492
6493--
6494-- Name: trxn_appointmentbookings trxn_appointmentbookings_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
6495--
6496
6497ALTER TABLE ONLY trxn_appointmentbookings
6498    ADD CONSTRAINT trxn_appointmentbookings_pkey PRIMARY KEY (trxn_appointmentbookings_id);
6499
6500
6501--
6502-- Name: trxn_coupons trxn_coupons_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
6503--
6504
6505ALTER TABLE ONLY trxn_coupons
6506    ADD CONSTRAINT trxn_coupons_pkey PRIMARY KEY (trxn_coupons_id);
6507
6508
6509--
6510-- Name: trxn_discountcard trxn_discountcard_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
6511--
6512
6513ALTER TABLE ONLY trxn_discountcard
6514    ADD CONSTRAINT trxn_discountcard_pkey PRIMARY KEY (trxn_discountcard_id);
6515
6516
6517--
6518-- Name: trxn_healthcheckbooking trxn_healthcheckbooking_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
6519--
6520
6521ALTER TABLE ONLY trxn_healthcheckbooking
6522    ADD CONSTRAINT trxn_healthcheckbooking_pkey PRIMARY KEY (trxn_healthcheckbooking_id);
6523
6524
6525--
6526-- Name: trxn_payments trxn_payments_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
6527--
6528
6529ALTER TABLE ONLY trxn_payments
6530    ADD CONSTRAINT trxn_payments_pkey PRIMARY KEY (trxn_payments_id);
6531
6532
6533--
6534-- Name: users users_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
6535--
6536
6537ALTER TABLE ONLY users
6538    ADD CONSTRAINT users_pkey PRIMARY KEY (users_id);
6539
6540
6541--
6542-- Name: week week_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
6543--
6544
6545ALTER TABLE ONLY week
6546    ADD CONSTRAINT week_pkey PRIMARY KEY (week_id);
6547
6548
6549--
6550-- Name: wellnessplan wellnessplan_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
6551--
6552
6553ALTER TABLE ONLY wellnessplan
6554    ADD CONSTRAINT wellnessplan_pkey PRIMARY KEY (wellnessplan_id);
6555
6556
6557--
6558-- Name: wellnessplan_profession wellnessplan_profession_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
6559--
6560
6561ALTER TABLE ONLY wellnessplan_profession
6562    ADD CONSTRAINT wellnessplan_profession_pkey PRIMARY KEY (wellnessplan_profession_id);
6563
6564
6565--
6566-- Name: wellnessplan_socialhistory wellnessplan_socialhistory_pkey; Type: CONSTRAINT; Schema: public; Owner: hospital
6567--
6568
6569ALTER TABLE ONLY wellnessplan_socialhistory
6570    ADD CONSTRAINT wellnessplan_socialhistory_pkey PRIMARY KEY (wellnessplan_socialhistory_id);
6571
6572
6573--
6574-- Name: address_fkindex1; Type: INDEX; Schema: public; Owner: hospital
6575--
6576
6577CREATE INDEX address_fkindex1 ON address USING btree (city_id);
6578
6579
6580--
6581-- Name: address_fkindex3; Type: INDEX; Schema: public; Owner: hospital
6582--
6583
6584CREATE INDEX address_fkindex3 ON address USING btree (state_id);
6585
6586
6587--
6588-- Name: address_fkindex4; Type: INDEX; Schema: public; Owner: hospital
6589--
6590
6591CREATE INDEX address_fkindex4 ON address USING btree (country_id);
6592
6593
6594--
6595-- Name: address_fkindex6; Type: INDEX; Schema: public; Owner: hospital
6596--
6597
6598CREATE INDEX address_fkindex6 ON address USING btree (district_id);
6599
6600
6601--
6602-- Name: appointmentbooking_fkindex1; Type: INDEX; Schema: public; Owner: hospital
6603--
6604
6605CREATE INDEX appointmentbooking_fkindex1 ON appointmentbooking USING btree (bookingsources_id);
6606
6607
6608--
6609-- Name: appointmentbooking_fkindex2; Type: INDEX; Schema: public; Owner: hospital
6610--
6611
6612CREATE INDEX appointmentbooking_fkindex2 ON appointmentbooking USING btree (clinicians_id);
6613
6614
6615--
6616-- Name: appointmentbooking_fkindex3; Type: INDEX; Schema: public; Owner: hospital
6617--
6618
6619CREATE INDEX appointmentbooking_fkindex3 ON appointmentbooking USING btree (healthseeker_id);
6620
6621
6622--
6623-- Name: appointmentbooking_fkindex4; Type: INDEX; Schema: public; Owner: hospital
6624--
6625
6626CREATE INDEX appointmentbooking_fkindex4 ON appointmentbooking USING btree (speciality_id);
6627
6628
6629--
6630-- Name: appointmentbooking_fkindex5; Type: INDEX; Schema: public; Owner: hospital
6631--
6632
6633CREATE INDEX appointmentbooking_fkindex5 ON appointmentbooking USING btree (priyority_id);
6634
6635
6636--
6637-- Name: auth_group_name_a6ea08ec_like; Type: INDEX; Schema: public; Owner: hospital
6638--
6639
6640CREATE INDEX auth_group_name_a6ea08ec_like ON auth_group USING btree (name varchar_pattern_ops);
6641
6642
6643--
6644-- Name: auth_group_permissions_group_id_b120cbf9; Type: INDEX; Schema: public; Owner: hospital
6645--
6646
6647CREATE INDEX auth_group_permissions_group_id_b120cbf9 ON auth_group_permissions USING btree (group_id);
6648
6649
6650--
6651-- Name: auth_group_permissions_permission_id_84c5c92e; Type: INDEX; Schema: public; Owner: hospital
6652--
6653
6654CREATE INDEX auth_group_permissions_permission_id_84c5c92e ON auth_group_permissions USING btree (permission_id);
6655
6656
6657--
6658-- Name: auth_permission_content_type_id_2f476e4b; Type: INDEX; Schema: public; Owner: hospital
6659--
6660
6661CREATE INDEX auth_permission_content_type_id_2f476e4b ON auth_permission USING btree (content_type_id);
6662
6663
6664--
6665-- Name: auth_user_groups_group_id_97559544; Type: INDEX; Schema: public; Owner: hospital
6666--
6667
6668CREATE INDEX auth_user_groups_group_id_97559544 ON auth_user_groups USING btree (group_id);
6669
6670
6671--
6672-- Name: auth_user_groups_user_id_6a12ed8b; Type: INDEX; Schema: public; Owner: hospital
6673--
6674
6675CREATE INDEX auth_user_groups_user_id_6a12ed8b ON auth_user_groups USING btree (user_id);
6676
6677
6678--
6679-- Name: auth_user_user_permissions_permission_id_1fbb5f2c; Type: INDEX; Schema: public; Owner: hospital
6680--
6681
6682CREATE INDEX auth_user_user_permissions_permission_id_1fbb5f2c ON auth_user_user_permissions USING btree (permission_id);
6683
6684
6685--
6686-- Name: auth_user_user_permissions_user_id_a95ead1b; Type: INDEX; Schema: public; Owner: hospital
6687--
6688
6689CREATE INDEX auth_user_user_permissions_user_id_a95ead1b ON auth_user_user_permissions USING btree (user_id);
6690
6691
6692--
6693-- Name: auth_user_username_6821ab7c_like; Type: INDEX; Schema: public; Owner: hospital
6694--
6695
6696CREATE INDEX auth_user_username_6821ab7c_like ON auth_user USING btree (username varchar_pattern_ops);
6697
6698
6699--
6700-- Name: availabledates_fkindex2; Type: INDEX; Schema: public; Owner: hospital
6701--
6702
6703CREATE INDEX availabledates_fkindex2 ON clinicians_dates USING btree (week_id);
6704
6705
6706--
6707-- Name: availabledates_fkindex3; Type: INDEX; Schema: public; Owner: hospital
6708--
6709
6710CREATE INDEX availabledates_fkindex3 ON clinicians_dates USING btree (timeslots_id);
6711
6712
6713--
6714-- Name: availablefacilities_fkindex1; Type: INDEX; Schema: public; Owner: hospital
6715--
6716
6717CREATE INDEX availablefacilities_fkindex1 ON availablefacilities USING btree (facilities_id);
6718
6719
6720--
6721-- Name: availablefacilities_fkindex2; Type: INDEX; Schema: public; Owner: hospital
6722--
6723
6724CREATE INDEX availablefacilities_fkindex2 ON availablefacilities USING btree (healthproviders_id);
6725
6726
6727--
6728-- Name: availablefacilities_fkindex3; Type: INDEX; Schema: public; Owner: hospital
6729--
6730
6731CREATE INDEX availablefacilities_fkindex3 ON availablefacilities USING btree (facilities_services_id);
6732
6733
6734--
6735-- Name: availablespeciality_fkindex1; Type: INDEX; Schema: public; Owner: hospital
6736--
6737
6738CREATE INDEX availablespeciality_fkindex1 ON healthproviders_speciality USING btree (healthproviders_id);
6739
6740
6741--
6742-- Name: availablespeciality_fkindex2; Type: INDEX; Schema: public; Owner: hospital
6743--
6744
6745CREATE INDEX availablespeciality_fkindex2 ON healthproviders_speciality USING btree (speciality_id);
6746
6747
6748--
6749-- Name: clinician_memberships_fkindex1; Type: INDEX; Schema: public; Owner: hospital
6750--
6751
6752CREATE INDEX clinician_memberships_fkindex1 ON clinician_memberships USING btree (country_id);
6753
6754
6755--
6756-- Name: clinician_memberships_fkindex2; Type: INDEX; Schema: public; Owner: hospital
6757--
6758
6759CREATE INDEX clinician_memberships_fkindex2 ON clinician_memberships USING btree (city_id);
6760
6761
6762--
6763-- Name: clinicians_dates_fkindex4; Type: INDEX; Schema: public; Owner: hospital
6764--
6765
6766CREATE INDEX clinicians_dates_fkindex4 ON clinicians_dates USING btree (clinicians_id);
6767
6768
6769--
6770-- Name: clinicians_education_fkindex1; Type: INDEX; Schema: public; Owner: hospital
6771--
6772
6773CREATE INDEX clinicians_education_fkindex1 ON clinicians_education USING btree (clinicians_id);
6774
6775
6776--
6777-- Name: clinicians_education_fkindex2; Type: INDEX; Schema: public; Owner: hospital
6778--
6779
6780CREATE INDEX clinicians_education_fkindex2 ON clinicians_education USING btree (qualification_id);
6781
6782
6783--
6784-- Name: clinicians_experience_fkindex1; Type: INDEX; Schema: public; Owner: hospital
6785--
6786
6787CREATE INDEX clinicians_experience_fkindex1 ON clinicians_experience USING btree (clinicians_id);
6788
6789
6790--
6791-- Name: clinicians_experience_fkindex2; Type: INDEX; Schema: public; Owner: hospital
6792--
6793
6794CREATE INDEX clinicians_experience_fkindex2 ON clinicians_experience USING btree (designation_id);
6795
6796
6797--
6798-- Name: clinicians_fkindex1; Type: INDEX; Schema: public; Owner: hospital
6799--
6800
6801CREATE INDEX clinicians_fkindex1 ON clinicians USING btree (users_id);
6802
6803
6804--
6805-- Name: clinicians_fkindex2; Type: INDEX; Schema: public; Owner: hospital
6806--
6807
6808CREATE INDEX clinicians_fkindex2 ON clinicians USING btree (gender_id);
6809
6810
6811--
6812-- Name: clinicians_fkindex3; Type: INDEX; Schema: public; Owner: hospital
6813--
6814
6815CREATE INDEX clinicians_fkindex3 ON clinicians USING btree (languages_id);
6816
6817
6818--
6819-- Name: clinicians_speciality_fkindex1; Type: INDEX; Schema: public; Owner: hospital
6820--
6821
6822CREATE INDEX clinicians_speciality_fkindex1 ON clinicians_speciality USING btree (clinicians_id);
6823
6824
6825--
6826-- Name: clinicians_speciality_fkindex2; Type: INDEX; Schema: public; Owner: hospital
6827--
6828
6829CREATE INDEX clinicians_speciality_fkindex2 ON clinicians_speciality USING btree (healthproviders_speciality_id);
6830
6831
6832--
6833-- Name: clinicians_speciality_fkindex3; Type: INDEX; Schema: public; Owner: hospital
6834--
6835
6836CREATE INDEX clinicians_speciality_fkindex3 ON clinicians_speciality USING btree (symptoms_id);
6837
6838
6839--
6840-- Name: discountcard_family_extra_fkindex1; Type: INDEX; Schema: public; Owner: hospital
6841--
6842
6843CREATE INDEX discountcard_family_extra_fkindex1 ON discountcard_family_extra USING btree (discountcard_id);
6844
6845
6846--
6847-- Name: discountcard_family_extra_fkindex2; Type: INDEX; Schema: public; Owner: hospital
6848--
6849
6850CREATE INDEX discountcard_family_extra_fkindex2 ON discountcard_family_extra USING btree (family_id);
6851
6852
6853--
6854-- Name: discountcard_family_fkindex1; Type: INDEX; Schema: public; Owner: hospital
6855--
6856
6857CREATE INDEX discountcard_family_fkindex1 ON discountcard_family USING btree (family_id);
6858
6859
6860--
6861-- Name: discountcard_family_fkindex2; Type: INDEX; Schema: public; Owner: hospital
6862--
6863
6864CREATE INDEX discountcard_family_fkindex2 ON discountcard_family USING btree (discountcard_id);
6865
6866
6867--
6868-- Name: discountcard_fkindex1; Type: INDEX; Schema: public; Owner: hospital
6869--
6870
6871CREATE INDEX discountcard_fkindex1 ON discountcard USING btree (healthchecks_id);
6872
6873
6874--
6875-- Name: django_admin_log_content_type_id_c4bce8eb; Type: INDEX; Schema: public; Owner: hospital
6876--
6877
6878CREATE INDEX django_admin_log_content_type_id_c4bce8eb ON django_admin_log USING btree (content_type_id);
6879
6880
6881--
6882-- Name: django_admin_log_user_id_c564eba6; Type: INDEX; Schema: public; Owner: hospital
6883--
6884
6885CREATE INDEX django_admin_log_user_id_c564eba6 ON django_admin_log USING btree (user_id);
6886
6887
6888--
6889-- Name: django_session_expire_date_a5c62663; Type: INDEX; Schema: public; Owner: hospital
6890--
6891
6892CREATE INDEX django_session_expire_date_a5c62663 ON django_session USING btree (expire_date);
6893
6894
6895--
6896-- Name: django_session_session_key_c0390e0f_like; Type: INDEX; Schema: public; Owner: hospital
6897--
6898
6899CREATE INDEX django_session_session_key_c0390e0f_like ON django_session USING btree (session_key varchar_pattern_ops);
6900
6901
6902--
6903-- Name: facilities_services_fkindex1; Type: INDEX; Schema: public; Owner: hospital
6904--
6905
6906CREATE INDEX facilities_services_fkindex1 ON facilities_services USING btree (facilities_id);
6907
6908
6909--
6910-- Name: healthcheckbookibg_fkindex1; Type: INDEX; Schema: public; Owner: hospital
6911--
6912
6913CREATE INDEX healthcheckbookibg_fkindex1 ON healthcheckbooking USING btree (bookingsources_id);
6914
6915
6916--
6917-- Name: healthcheckbookibg_fkindex2; Type: INDEX; Schema: public; Owner: hospital
6918--
6919
6920CREATE INDEX healthcheckbookibg_fkindex2 ON healthcheckbooking USING btree (healthproviders_id);
6921
6922
6923--
6924-- Name: healthcheckbookibg_fkindex3; Type: INDEX; Schema: public; Owner: hospital
6925--
6926
6927CREATE INDEX healthcheckbookibg_fkindex3 ON healthcheckbooking USING btree (healthseeker_id);
6928
6929
6930--
6931-- Name: healthchecks_fkindex1; Type: INDEX; Schema: public; Owner: hospital
6932--
6933
6934CREATE INDEX healthchecks_fkindex1 ON healthchecks USING btree (coupons_id);
6935
6936
6937--
6938-- Name: healthchecks_inclusion_fkindex1; Type: INDEX; Schema: public; Owner: hospital
6939--
6940
6941CREATE INDEX healthchecks_inclusion_fkindex1 ON healthchecks_inclusion USING btree (healthchecks_id);
6942
6943
6944--
6945-- Name: healthchecks_inclusion_fkindex2; Type: INDEX; Schema: public; Owner: hospital
6946--
6947
6948CREATE INDEX healthchecks_inclusion_fkindex2 ON healthchecks_inclusion USING btree (test_id);
6949
6950
6951--
6952-- Name: healthproviders_fkindex1; Type: INDEX; Schema: public; Owner: hospital
6953--
6954
6955CREATE INDEX healthproviders_fkindex1 ON healthproviders USING btree (users_id);
6956
6957
6958--
6959-- Name: healthproviders_fkindex2; Type: INDEX; Schema: public; Owner: hospital
6960--
6961
6962CREATE INDEX healthproviders_fkindex2 ON healthproviders USING btree (address_id);
6963
6964
6965--
6966-- Name: healthseeker_alerts_fkindex1; Type: INDEX; Schema: public; Owner: hospital
6967--
6968
6969CREATE INDEX healthseeker_alerts_fkindex1 ON healthseeker_alerts USING btree (healthseeker_id);
6970
6971
6972--
6973-- Name: healthseeker_alerts_fkindex2; Type: INDEX; Schema: public; Owner: hospital
6974--
6975
6976CREATE INDEX healthseeker_alerts_fkindex2 ON healthseeker_alerts USING btree (alerttype_id);
6977
6978
6979--
6980-- Name: healthseeker_alerts_fkindex3; Type: INDEX; Schema: public; Owner: hospital
6981--
6982
6983CREATE INDEX healthseeker_alerts_fkindex3 ON healthseeker_alerts USING btree (alertsources_id);
6984
6985
6986--
6987-- Name: healthseeker_availabilities_fkindex1; Type: INDEX; Schema: public; Owner: hospital
6988--
6989
6990CREATE INDEX healthseeker_availabilities_fkindex1 ON healthseeker_availabilities USING btree (healthseeker_id);
6991
6992
6993--
6994-- Name: healthseeker_availabilities_fkindex2; Type: INDEX; Schema: public; Owner: hospital
6995--
6996
6997CREATE INDEX healthseeker_availabilities_fkindex2 ON healthseeker_availabilities USING btree (coupons_id);
6998
6999
7000--
7001-- Name: healthseeker_availabilities_fkindex3; Type: INDEX; Schema: public; Owner: hospital
7002--
7003
7004CREATE INDEX healthseeker_availabilities_fkindex3 ON healthseeker_availabilities USING btree (discountcard_id);
7005
7006
7007--
7008-- Name: healthseeker_availabilities_fkindex4; Type: INDEX; Schema: public; Owner: hospital
7009--
7010
7011CREATE INDEX healthseeker_availabilities_fkindex4 ON healthseeker_availabilities USING btree (healthchecks_id);
7012
7013
7014--
7015-- Name: healthseeker_fkindex1; Type: INDEX; Schema: public; Owner: hospital
7016--
7017
7018CREATE INDEX healthseeker_fkindex1 ON healthseeker USING btree (users_id);
7019
7020
7021--
7022-- Name: healthseeker_fkindex2; Type: INDEX; Schema: public; Owner: hospital
7023--
7024
7025CREATE INDEX healthseeker_fkindex2 ON healthseeker USING btree (gender_id);
7026
7027
7028--
7029-- Name: healthseeker_fkindex3; Type: INDEX; Schema: public; Owner: hospital
7030--
7031
7032CREATE INDEX healthseeker_fkindex3 ON healthseeker USING btree (languages_id);
7033
7034
7035--
7036-- Name: healthseeker_fkindex4; Type: INDEX; Schema: public; Owner: hospital
7037--
7038
7039CREATE INDEX healthseeker_fkindex4 ON healthseeker USING btree (profession_id);
7040
7041
7042--
7043-- Name: healthseeker_fkindex5; Type: INDEX; Schema: public; Owner: hospital
7044--
7045
7046CREATE INDEX healthseeker_fkindex5 ON healthseeker USING btree (healthseeker_type_id);
7047
7048
7049--
7050-- Name: healthseeker_healthrecords_fkindex1; Type: INDEX; Schema: public; Owner: hospital
7051--
7052
7053CREATE INDEX healthseeker_healthrecords_fkindex1 ON healthseeker_healthrecords USING btree (healthseeker_id);
7054
7055
7056--
7057-- Name: healthseeker_healthrecords_fkindex2; Type: INDEX; Schema: public; Owner: hospital
7058--
7059
7060CREATE INDEX healthseeker_healthrecords_fkindex2 ON healthseeker_healthrecords USING btree (healthrecords_id);
7061
7062
7063--
7064-- Name: ifk_address_city; Type: INDEX; Schema: public; Owner: hospital
7065--
7066
7067CREATE INDEX ifk_address_city ON address USING btree (city_id);
7068
7069
7070--
7071-- Name: ifk_address_district; Type: INDEX; Schema: public; Owner: hospital
7072--
7073
7074CREATE INDEX ifk_address_district ON address USING btree (district_id);
7075
7076
7077--
7078-- Name: ifk_address_state; Type: INDEX; Schema: public; Owner: hospital
7079--
7080
7081CREATE INDEX ifk_address_state ON address USING btree (state_id);
7082
7083
7084--
7085-- Name: ifk_address_telephones; Type: INDEX; Schema: public; Owner: hospital
7086--
7087
7088CREATE INDEX ifk_address_telephones ON telephone USING btree (address_id);
7089
7090
7091--
7092-- Name: ifk_alert_type; Type: INDEX; Schema: public; Owner: hospital
7093--
7094
7095CREATE INDEX ifk_alert_type ON healthseeker_alerts USING btree (alerttype_id);
7096
7097
7098--
7099-- Name: ifk_appointmentbooking_healths; Type: INDEX; Schema: public; Owner: hospital
7100--
7101
7102CREATE INDEX ifk_appointmentbooking_healths ON appointmentbooking USING btree (healthseeker_id);
7103
7104
7105--
7106-- Name: ifk_appointmentbooking_priyori; Type: INDEX; Schema: public; Owner: hospital
7107--
7108
7109CREATE INDEX ifk_appointmentbooking_priyori ON appointmentbooking USING btree (priyority_id);
7110
7111
7112--
7113-- Name: ifk_appointmentbooking_special; Type: INDEX; Schema: public; Owner: hospital
7114--
7115
7116CREATE INDEX ifk_appointmentbooking_special ON appointmentbooking USING btree (speciality_id);
7117
7118
7119--
7120-- Name: ifk_appointmentsbooking_source; Type: INDEX; Schema: public; Owner: hospital
7121--
7122
7123CREATE INDEX ifk_appointmentsbooking_source ON appointmentbooking USING btree (bookingsources_id);
7124
7125
7126--
7127-- Name: ifk_availablefacilities_facili; Type: INDEX; Schema: public; Owner: hospital
7128--
7129
7130CREATE INDEX ifk_availablefacilities_facili ON availablefacilities USING btree (facilities_id);
7131
7132
7133--
7134-- Name: ifk_availablespeciality_specia; Type: INDEX; Schema: public; Owner: hospital
7135--
7136
7137CREATE INDEX ifk_availablespeciality_specia ON healthproviders_speciality USING btree (speciality_id);
7138
7139
7140--
7141-- Name: ifk_clinician_education_qualif; Type: INDEX; Schema: public; Owner: hospital
7142--
7143
7144CREATE INDEX ifk_clinician_education_qualif ON clinicians_education USING btree (qualification_id);
7145
7146
7147--
7148-- Name: ifk_clinician_memberships_city; Type: INDEX; Schema: public; Owner: hospital
7149--
7150
7151CREATE INDEX ifk_clinician_memberships_city ON clinician_memberships USING btree (city_id);
7152
7153
7154--
7155-- Name: ifk_clinician_users; Type: INDEX; Schema: public; Owner: hospital
7156--
7157
7158CREATE INDEX ifk_clinician_users ON clinicians USING btree (users_id);
7159
7160
7161--
7162-- Name: ifk_clinicians_appointments; Type: INDEX; Schema: public; Owner: hospital
7163--
7164
7165CREATE INDEX ifk_clinicians_appointments ON appointmentbooking USING btree (clinicians_id);
7166
7167
7168--
7169-- Name: ifk_clinicians_clinicians_date; Type: INDEX; Schema: public; Owner: hospital
7170--
7171
7172CREATE INDEX ifk_clinicians_clinicians_date ON clinicians_dates USING btree (clinicians_id);
7173
7174
7175--
7176-- Name: ifk_clinicians_consultationfee; Type: INDEX; Schema: public; Owner: hospital
7177--
7178
7179CREATE INDEX ifk_clinicians_consultationfee ON resellers USING btree (users_id);
7180
7181
7182--
7183-- Name: ifk_clinicians_dates_timeslots; Type: INDEX; Schema: public; Owner: hospital
7184--
7185
7186CREATE INDEX ifk_clinicians_dates_timeslots ON clinicians_dates USING btree (timeslots_id);
7187
7188
7189--
7190-- Name: ifk_clinicians_dates_weeks; Type: INDEX; Schema: public; Owner: hospital
7191--
7192
7193CREATE INDEX ifk_clinicians_dates_weeks ON clinicians_dates USING btree (week_id);
7194
7195
7196--
7197-- Name: ifk_clinicians_education; Type: INDEX; Schema: public; Owner: hospital
7198--
7199
7200CREATE INDEX ifk_clinicians_education ON clinicians_education USING btree (clinicians_id);
7201
7202
7203--
7204-- Name: ifk_clinicians_exp_designation; Type: INDEX; Schema: public; Owner: hospital
7205--
7206
7207CREATE INDEX ifk_clinicians_exp_designation ON clinicians_experience USING btree (designation_id);
7208
7209
7210--
7211-- Name: ifk_clinicians_experience; Type: INDEX; Schema: public; Owner: hospital
7212--
7213
7214CREATE INDEX ifk_clinicians_experience ON clinicians_experience USING btree (clinicians_id);
7215
7216
7217--
7218-- Name: ifk_clinicians_gender; Type: INDEX; Schema: public; Owner: hospital
7219--
7220
7221CREATE INDEX ifk_clinicians_gender ON clinicians USING btree (gender_id);
7222
7223
7224--
7225-- Name: ifk_clinicians_languages; Type: INDEX; Schema: public; Owner: hospital
7226--
7227
7228CREATE INDEX ifk_clinicians_languages ON clinicians USING btree (languages_id);
7229
7230
7231--
7232-- Name: ifk_clinicians_speciality; Type: INDEX; Schema: public; Owner: hospital
7233--
7234
7235CREATE INDEX ifk_clinicians_speciality ON clinicians_speciality USING btree (clinicians_id);
7236
7237
7238--
7239-- Name: ifk_clinicians_speciality_symp; Type: INDEX; Schema: public; Owner: hospital
7240--
7241
7242CREATE INDEX ifk_clinicians_speciality_symp ON clinicians_speciality USING btree (symptoms_id);
7243
7244
7245--
7246-- Name: ifk_country_clinician_membersh; Type: INDEX; Schema: public; Owner: hospital
7247--
7248
7249CREATE INDEX ifk_country_clinician_membersh ON clinician_memberships USING btree (country_id);
7250
7251
7252--
7253-- Name: ifk_discountcard_family; Type: INDEX; Schema: public; Owner: hospital
7254--
7255
7256CREATE INDEX ifk_discountcard_family ON discountcard_family USING btree (discountcard_id);
7257
7258
7259--
7260-- Name: ifk_discountcard_family_discou; Type: INDEX; Schema: public; Owner: hospital
7261--
7262
7263CREATE INDEX ifk_discountcard_family_discou ON discountcard_family USING btree (family_id);
7264
7265
7266--
7267-- Name: ifk_discountcard_family_extra; Type: INDEX; Schema: public; Owner: hospital
7268--
7269
7270CREATE INDEX ifk_discountcard_family_extra ON discountcard_family_extra USING btree (discountcard_id);
7271
7272
7273--
7274-- Name: ifk_facilities_services; Type: INDEX; Schema: public; Owner: hospital
7275--
7276
7277CREATE INDEX ifk_facilities_services ON facilities_services USING btree (facilities_id);
7278
7279
7280--
7281-- Name: ifk_healthchecks_discountcard; Type: INDEX; Schema: public; Owner: hospital
7282--
7283
7284CREATE INDEX ifk_healthchecks_discountcard ON discountcard USING btree (healthchecks_id);
7285
7286
7287--
7288-- Name: ifk_healthprovider_availablefa; Type: INDEX; Schema: public; Owner: hospital
7289--
7290
7291CREATE INDEX ifk_healthprovider_availablefa ON availablefacilities USING btree (healthproviders_id);
7292
7293
7294--
7295-- Name: ifk_healthproviders_address; Type: INDEX; Schema: public; Owner: hospital
7296--
7297
7298CREATE INDEX ifk_healthproviders_address ON healthproviders USING btree (address_id);
7299
7300
7301--
7302-- Name: ifk_healthproviders_availables; Type: INDEX; Schema: public; Owner: hospital
7303--
7304
7305CREATE INDEX ifk_healthproviders_availables ON healthproviders_speciality USING btree (healthproviders_id);
7306
7307
7308--
7309-- Name: ifk_healthproviders_users; Type: INDEX; Schema: public; Owner: hospital
7310--
7311
7312CREATE INDEX ifk_healthproviders_users ON healthproviders USING btree (users_id);
7313
7314
7315--
7316-- Name: ifk_healthseeker_alerts; Type: INDEX; Schema: public; Owner: hospital
7317--
7318
7319CREATE INDEX ifk_healthseeker_alerts ON healthseeker_alerts USING btree (healthseeker_id);
7320
7321
7322--
7323-- Name: ifk_healthseeker_availabilitie; Type: INDEX; Schema: public; Owner: hospital
7324--
7325
7326CREATE INDEX ifk_healthseeker_availabilitie ON healthseeker_availabilities USING btree (healthseeker_id);
7327
7328
7329--
7330-- Name: ifk_healthseeker_discountcard_; Type: INDEX; Schema: public; Owner: hospital
7331--
7332
7333CREATE INDEX ifk_healthseeker_discountcard_ ON healthseeker_availabilities USING btree (discountcard_id);
7334
7335
7336--
7337-- Name: ifk_healthseeker_gender; Type: INDEX; Schema: public; Owner: hospital
7338--
7339
7340CREATE INDEX ifk_healthseeker_gender ON healthseeker USING btree (gender_id);
7341
7342
7343--
7344-- Name: ifk_healthseeker_healthchecks_; Type: INDEX; Schema: public; Owner: hospital
7345--
7346
7347CREATE INDEX ifk_healthseeker_healthchecks_ ON healthseeker_availabilities USING btree (healthchecks_id);
7348
7349
7350--
7351-- Name: ifk_healthseeker_interest; Type: INDEX; Schema: public; Owner: hospital
7352--
7353
7354CREATE INDEX ifk_healthseeker_interest ON interest USING btree (healthseeker_id);
7355
7356
7357--
7358-- Name: ifk_healthseeker_languages; Type: INDEX; Schema: public; Owner: hospital
7359--
7360
7361CREATE INDEX ifk_healthseeker_languages ON healthseeker USING btree (languages_id);
7362
7363
7364--
7365-- Name: ifk_healthseeker_profession; Type: INDEX; Schema: public; Owner: hospital
7366--
7367
7368CREATE INDEX ifk_healthseeker_profession ON healthseeker USING btree (profession_id);
7369
7370
7371--
7372-- Name: ifk_healthseeker_type; Type: INDEX; Schema: public; Owner: hospital
7373--
7374
7375CREATE INDEX ifk_healthseeker_type ON healthseeker USING btree (healthseeker_type_id);
7376
7377
7378--
7379-- Name: ifk_healthseeker_users; Type: INDEX; Schema: public; Owner: hospital
7380--
7381
7382CREATE INDEX ifk_healthseeker_users ON healthseeker USING btree (users_id);
7383
7384
7385--
7386-- Name: ifk_helthseeker_coupon_availab; Type: INDEX; Schema: public; Owner: hospital
7387--
7388
7389CREATE INDEX ifk_helthseeker_coupon_availab ON healthseeker_availabilities USING btree (coupons_id);
7390
7391
7392--
7393-- Name: ifk_plans_group; Type: INDEX; Schema: public; Owner: hospital
7394--
7395
7396CREATE INDEX ifk_plans_group ON plans USING btree (plans_groups_id);
7397
7398
7399--
7400-- Name: ifk_plans_groups_specialities_; Type: INDEX; Schema: public; Owner: hospital
7401--
7402
7403CREATE INDEX ifk_plans_groups_specialities_ ON plans_groups USING btree (plans_groups_specialities_id);
7404
7405
7406--
7407-- Name: ifk_rel_46; Type: INDEX; Schema: public; Owner: hospital
7408--
7409
7410CREATE INDEX ifk_rel_46 ON healthseeker_healthrecords USING btree (healthseeker_id);
7411
7412
7413--
7414-- Name: ifk_rel_50; Type: INDEX; Schema: public; Owner: hospital
7415--
7416
7417CREATE INDEX ifk_rel_50 ON healthseeker_alerts USING btree (alertsources_id);
7418
7419
7420--
7421-- Name: ifk_rel_51; Type: INDEX; Schema: public; Owner: hospital
7422--
7423
7424CREATE INDEX ifk_rel_51 ON healthchecks_inclusion USING btree (healthchecks_id);
7425
7426
7427--
7428-- Name: ifk_rel_52; Type: INDEX; Schema: public; Owner: hospital
7429--
7430
7431CREATE INDEX ifk_rel_52 ON healthchecks USING btree (coupons_id);
7432
7433
7434--
7435-- Name: ifk_rel_55; Type: INDEX; Schema: public; Owner: hospital
7436--
7437
7438CREATE INDEX ifk_rel_55 ON wellnessplan USING btree (agegroup_id);
7439
7440
7441--
7442-- Name: ifk_rel_56; Type: INDEX; Schema: public; Owner: hospital
7443--
7444
7445CREATE INDEX ifk_rel_56 ON wellnessplan USING btree (conditions_id);
7446
7447
7448--
7449-- Name: ifk_rel_57; Type: INDEX; Schema: public; Owner: hospital
7450--
7451
7452CREATE INDEX ifk_rel_57 ON wellnessplan USING btree (wellnessplan_profession_id);
7453
7454
7455--
7456-- Name: ifk_rel_58; Type: INDEX; Schema: public; Owner: hospital
7457--
7458
7459CREATE INDEX ifk_rel_58 ON wellnessplan USING btree (wellnessplan_socialhistory_id);
7460
7461
7462--
7463-- Name: ifk_rel_59; Type: INDEX; Schema: public; Owner: hospital
7464--
7465
7466CREATE INDEX ifk_rel_59 ON salesagents USING btree (users_id);
7467
7468
7469--
7470-- Name: ifk_rel_61; Type: INDEX; Schema: public; Owner: hospital
7471--
7472
7473CREATE INDEX ifk_rel_61 ON salesagentpackages USING btree (salestarget_id);
7474
7475
7476--
7477-- Name: ifk_rel_62; Type: INDEX; Schema: public; Owner: hospital
7478--
7479
7480CREATE INDEX ifk_rel_62 ON resellerpackages USING btree (salestarget_id);
7481
7482
7483--
7484-- Name: ifk_rel_67; Type: INDEX; Schema: public; Owner: hospital
7485--
7486
7487CREATE INDEX ifk_rel_67 ON healthcheckbooking USING btree (healthproviders_id);
7488
7489
7490--
7491-- Name: ifk_rel_68; Type: INDEX; Schema: public; Owner: hospital
7492--
7493
7494CREATE INDEX ifk_rel_68 ON healthcheckbooking USING btree (healthseeker_id);
7495
7496
7497--
7498-- Name: ifk_speciality_clinicians_heal; Type: INDEX; Schema: public; Owner: hospital
7499--
7500
7501CREATE INDEX ifk_speciality_clinicians_heal ON clinicians_speciality USING btree (healthproviders_speciality_id);
7502
7503
7504--
7505-- Name: ifk_speciality_qualification; Type: INDEX; Schema: public; Owner: hospital
7506--
7507
7508CREATE INDEX ifk_speciality_qualification ON speciality USING btree (qualification_id);
7509
7510
7511--
7512-- Name: ifk_speciality_symptoms; Type: INDEX; Schema: public; Owner: hospital
7513--
7514
7515CREATE INDEX ifk_speciality_symptoms ON symptoms USING btree (speciality_id);
7516
7517
7518--
7519-- Name: ifk_speciality_type; Type: INDEX; Schema: public; Owner: hospital
7520--
7521
7522CREATE INDEX ifk_speciality_type ON speciality USING btree (speciality_type_id);
7523
7524
7525--
7526-- Name: ifk_sponser_users; Type: INDEX; Schema: public; Owner: hospital
7527--
7528
7529CREATE INDEX ifk_sponser_users ON sponsors USING btree (users_id);
7530
7531
7532--
7533-- Name: ifk_sponsor_group; Type: INDEX; Schema: public; Owner: hospital
7534--
7535
7536CREATE INDEX ifk_sponsor_group ON sponsors USING btree (sponsors_group_id);
7537
7538
7539--
7540-- Name: ifk_sponsors_businesstype; Type: INDEX; Schema: public; Owner: hospital
7541--
7542
7543CREATE INDEX ifk_sponsors_businesstype ON sponsors USING btree (businessregtype_id);
7544
7545
7546--
7547-- Name: ifk_test_category; Type: INDEX; Schema: public; Owner: hospital
7548--
7549
7550CREATE INDEX ifk_test_category ON test USING btree (test_category_id);
7551
7552
7553--
7554-- Name: ifk_testsubcategory; Type: INDEX; Schema: public; Owner: hospital
7555--
7556
7557CREATE INDEX ifk_testsubcategory ON test USING btree (test_subcategory_id);
7558
7559
7560--
7561-- Name: ifk_transaction_discountcard; Type: INDEX; Schema: public; Owner: hospital
7562--
7563
7564CREATE INDEX ifk_transaction_discountcard ON trxn_discountcard USING btree (discountcard_id);
7565
7566
7567--
7568-- Name: ifk_trxn_appointments; Type: INDEX; Schema: public; Owner: hospital
7569--
7570
7571CREATE INDEX ifk_trxn_appointments ON trxn_appointmentbookings USING btree (appointmentbooking_id, appointmentbooking_date);
7572
7573
7574--
7575-- Name: ifk_trxn_coupons; Type: INDEX; Schema: public; Owner: hospital
7576--
7577
7578CREATE INDEX ifk_trxn_coupons ON trxn_coupons USING btree (coupons_id);
7579
7580
7581--
7582-- Name: ifk_trxn_healthcheckbooking; Type: INDEX; Schema: public; Owner: hospital
7583--
7584
7585CREATE INDEX ifk_trxn_healthcheckbooking ON trxn_healthcheckbooking USING btree (healthcheckbooking_id);
7586
7587
7588--
7589-- Name: ifk_users_feedback; Type: INDEX; Schema: public; Owner: hospital
7590--
7591
7592CREATE INDEX ifk_users_feedback ON feedback USING btree (users_id);
7593
7594
7595--
7596-- Name: ifk_users_photoalbum; Type: INDEX; Schema: public; Owner: hospital
7597--
7598
7599CREATE INDEX ifk_users_photoalbum ON photoalbum USING btree (users_id);
7600
7601
7602--
7603-- Name: ifk_users_role; Type: INDEX; Schema: public; Owner: hospital
7604--
7605
7606CREATE INDEX ifk_users_role ON users USING btree (role_id);
7607
7608
7609--
7610-- Name: ifk_users_secretquestions; Type: INDEX; Schema: public; Owner: hospital
7611--
7612
7613CREATE INDEX ifk_users_secretquestions ON users USING btree (secretquestions_id);
7614
7615
7616--
7617-- Name: ifk_users_testimonials; Type: INDEX; Schema: public; Owner: hospital
7618--
7619
7620CREATE INDEX ifk_users_testimonials ON testimonials USING btree (users_id);
7621
7622
7623--
7624-- Name: interest_fkindex1; Type: INDEX; Schema: public; Owner: hospital
7625--
7626
7627CREATE INDEX interest_fkindex1 ON interest USING btree (healthseeker_id);
7628
7629
7630--
7631-- Name: photoalbum_fkindex1; Type: INDEX; Schema: public; Owner: hospital
7632--
7633
7634CREATE INDEX photoalbum_fkindex1 ON photoalbum USING btree (users_id);
7635
7636
7637--
7638-- Name: plans_fkindex1; Type: INDEX; Schema: public; Owner: hospital
7639--
7640
7641CREATE INDEX plans_fkindex1 ON plans USING btree (plans_groups_id);
7642
7643
7644--
7645-- Name: plans_groups_fkindex1; Type: INDEX; Schema: public; Owner: hospital
7646--
7647
7648CREATE INDEX plans_groups_fkindex1 ON plans_groups USING btree (plans_groups_specialities_id);
7649
7650
7651--
7652-- Name: resellerpackages_fkindex1; Type: INDEX; Schema: public; Owner: hospital
7653--
7654
7655CREATE INDEX resellerpackages_fkindex1 ON resellerpackages USING btree (salestarget_id);
7656
7657
7658--
7659-- Name: resellers_fkindex1; Type: INDEX; Schema: public; Owner: hospital
7660--
7661
7662CREATE INDEX resellers_fkindex1 ON resellers USING btree (users_id);
7663
7664
7665--
7666-- Name: salesagentpackages_fkindex1; Type: INDEX; Schema: public; Owner: hospital
7667--
7668
7669CREATE INDEX salesagentpackages_fkindex1 ON salesagentpackages USING btree (salestarget_id);
7670
7671
7672--
7673-- Name: salesagents_fkindex1; Type: INDEX; Schema: public; Owner: hospital
7674--
7675
7676CREATE INDEX salesagents_fkindex1 ON salesagents USING btree (users_id);
7677
7678
7679--
7680-- Name: speciality_fkindex1; Type: INDEX; Schema: public; Owner: hospital
7681--
7682
7683CREATE INDEX speciality_fkindex1 ON speciality USING btree (qualification_id);
7684
7685
7686--
7687-- Name: speciality_fkindex2; Type: INDEX; Schema: public; Owner: hospital
7688--
7689
7690CREATE INDEX speciality_fkindex2 ON speciality USING btree (speciality_type_id);
7691
7692
7693--
7694-- Name: sponsors_fkindex1; Type: INDEX; Schema: public; Owner: hospital
7695--
7696
7697CREATE INDEX sponsors_fkindex1 ON sponsors USING btree (businessregtype_id);
7698
7699
7700--
7701-- Name: sponsors_fkindex2; Type: INDEX; Schema: public; Owner: hospital
7702--
7703
7704CREATE INDEX sponsors_fkindex2 ON sponsors USING btree (users_id);
7705
7706
7707--
7708-- Name: sponsors_fkindex3; Type: INDEX; Schema: public; Owner: hospital
7709--
7710
7711CREATE INDEX sponsors_fkindex3 ON sponsors USING btree (sponsors_group_id);
7712
7713
7714--
7715-- Name: symptoms_fkindex1; Type: INDEX; Schema: public; Owner: hospital
7716--
7717
7718CREATE INDEX symptoms_fkindex1 ON symptoms USING btree (speciality_id);
7719
7720
7721--
7722-- Name: telephone_fkindex1; Type: INDEX; Schema: public; Owner: hospital
7723--
7724
7725CREATE INDEX telephone_fkindex1 ON telephone USING btree (address_id);
7726
7727
7728--
7729-- Name: test_fkindex1; Type: INDEX; Schema: public; Owner: hospital
7730--
7731
7732CREATE INDEX test_fkindex1 ON test USING btree (test_category_id);
7733
7734
7735--
7736-- Name: test_fkindex2; Type: INDEX; Schema: public; Owner: hospital
7737--
7738
7739CREATE INDEX test_fkindex2 ON test USING btree (test_subcategory_id);
7740
7741
7742--
7743-- Name: test_subcategory_fkindex1; Type: INDEX; Schema: public; Owner: hospital
7744--
7745
7746CREATE INDEX test_subcategory_fkindex1 ON test_subcategory USING btree (test_category_id);
7747
7748
7749--
7750-- Name: testimonials_fkindex1; Type: INDEX; Schema: public; Owner: hospital
7751--
7752
7753CREATE INDEX testimonials_fkindex1 ON testimonials USING btree (users_id);
7754
7755
7756--
7757-- Name: trxn_appointmentbookings_fkindex1; Type: INDEX; Schema: public; Owner: hospital
7758--
7759
7760CREATE INDEX trxn_appointmentbookings_fkindex1 ON trxn_appointmentbookings USING btree (appointmentbooking_id, appointmentbooking_date);
7761
7762
7763--
7764-- Name: trxn_coupons_fkindex1; Type: INDEX; Schema: public; Owner: hospital
7765--
7766
7767CREATE INDEX trxn_coupons_fkindex1 ON trxn_coupons USING btree (coupons_id);
7768
7769
7770--
7771-- Name: trxn_discountcard_fkindex1; Type: INDEX; Schema: public; Owner: hospital
7772--
7773
7774CREATE INDEX trxn_discountcard_fkindex1 ON trxn_discountcard USING btree (discountcard_id);
7775
7776
7777--
7778-- Name: trxn_healthcheckbooking_fkindex1; Type: INDEX; Schema: public; Owner: hospital
7779--
7780
7781CREATE INDEX trxn_healthcheckbooking_fkindex1 ON trxn_healthcheckbooking USING btree (healthcheckbooking_id);
7782
7783
7784--
7785-- Name: users_feedback_fkindex1; Type: INDEX; Schema: public; Owner: hospital
7786--
7787
7788CREATE INDEX users_feedback_fkindex1 ON feedback USING btree (users_id);
7789
7790
7791--
7792-- Name: users_fkindex1; Type: INDEX; Schema: public; Owner: hospital
7793--
7794
7795CREATE INDEX users_fkindex1 ON users USING btree (role_id);
7796
7797
7798--
7799-- Name: users_fkindex2; Type: INDEX; Schema: public; Owner: hospital
7800--
7801
7802CREATE INDEX users_fkindex2 ON users USING btree (secretquestions_id);
7803
7804
7805--
7806-- Name: wellnessplan_fkindex1; Type: INDEX; Schema: public; Owner: hospital
7807--
7808
7809CREATE INDEX wellnessplan_fkindex1 ON wellnessplan USING btree (agegroup_id);
7810
7811
7812--
7813-- Name: wellnessplan_fkindex2; Type: INDEX; Schema: public; Owner: hospital
7814--
7815
7816CREATE INDEX wellnessplan_fkindex2 ON wellnessplan USING btree (conditions_id);
7817
7818
7819--
7820-- Name: wellnessplan_fkindex3; Type: INDEX; Schema: public; Owner: hospital
7821--
7822
7823CREATE INDEX wellnessplan_fkindex3 ON wellnessplan USING btree (wellnessplan_profession_id);
7824
7825
7826--
7827-- Name: wellnessplan_fkindex4; Type: INDEX; Schema: public; Owner: hospital
7828--
7829
7830CREATE INDEX wellnessplan_fkindex4 ON wellnessplan USING btree (wellnessplan_socialhistory_id);
7831
7832
7833--
7834-- Name: address address_city_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hospital
7835--
7836
7837ALTER TABLE ONLY address
7838    ADD CONSTRAINT address_city_id_fkey FOREIGN KEY (city_id) REFERENCES city(city_id);
7839
7840
7841--
7842-- Name: address address_country_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hospital
7843--
7844
7845ALTER TABLE ONLY address
7846    ADD CONSTRAINT address_country_id_fkey FOREIGN KEY (country_id) REFERENCES country(country_id);
7847
7848
7849--
7850-- Name: address address_district_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hospital
7851--
7852
7853ALTER TABLE ONLY address
7854    ADD CONSTRAINT address_district_id_fkey FOREIGN KEY (district_id) REFERENCES district(district_id);
7855
7856
7857--
7858-- Name: address address_state_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hospital
7859--
7860
7861ALTER TABLE ONLY address
7862    ADD CONSTRAINT address_state_id_fkey FOREIGN KEY (state_id) REFERENCES state(state_id);
7863
7864
7865--
7866-- Name: appointmentbooking appointmentbooking_bookingsources_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hospital
7867--
7868
7869ALTER TABLE ONLY appointmentbooking
7870    ADD CONSTRAINT appointmentbooking_bookingsources_id_fkey FOREIGN KEY (bookingsources_id) REFERENCES bookingsources(bookingsources_id);
7871
7872
7873--
7874-- Name: appointmentbooking appointmentbooking_clinicians_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hospital
7875--
7876
7877ALTER TABLE ONLY appointmentbooking
7878    ADD CONSTRAINT appointmentbooking_clinicians_id_fkey FOREIGN KEY (clinicians_id) REFERENCES clinicians(clinicians_id);
7879
7880
7881--
7882-- Name: appointmentbooking appointmentbooking_healthseeker_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hospital
7883--
7884
7885ALTER TABLE ONLY appointmentbooking
7886    ADD CONSTRAINT appointmentbooking_healthseeker_id_fkey FOREIGN KEY (healthseeker_id) REFERENCES healthseeker(healthseeker_id);
7887
7888
7889--
7890-- Name: appointmentbooking appointmentbooking_priyority_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hospital
7891--
7892
7893ALTER TABLE ONLY appointmentbooking
7894    ADD CONSTRAINT appointmentbooking_priyority_id_fkey FOREIGN KEY (priyority_id) REFERENCES priyority(priyority_id);
7895
7896
7897--
7898-- Name: appointmentbooking appointmentbooking_speciality_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hospital
7899--
7900
7901ALTER TABLE ONLY appointmentbooking
7902    ADD CONSTRAINT appointmentbooking_speciality_id_fkey FOREIGN KEY (speciality_id) REFERENCES speciality(speciality_id);
7903
7904
7905--
7906-- Name: auth_group_permissions auth_group_permissio_permission_id_84c5c92e_fk_auth_perm; Type: FK CONSTRAINT; Schema: public; Owner: hospital
7907--
7908
7909ALTER TABLE ONLY auth_group_permissions
7910    ADD CONSTRAINT auth_group_permissio_permission_id_84c5c92e_fk_auth_perm FOREIGN KEY (permission_id) REFERENCES auth_permission(id) DEFERRABLE INITIALLY DEFERRED;
7911
7912
7913--
7914-- Name: auth_group_permissions auth_group_permissions_group_id_b120cbf9_fk_auth_group_id; Type: FK CONSTRAINT; Schema: public; Owner: hospital
7915--
7916
7917ALTER TABLE ONLY auth_group_permissions
7918    ADD CONSTRAINT auth_group_permissions_group_id_b120cbf9_fk_auth_group_id FOREIGN KEY (group_id) REFERENCES auth_group(id) DEFERRABLE INITIALLY DEFERRED;
7919
7920
7921--
7922-- Name: auth_permission auth_permission_content_type_id_2f476e4b_fk_django_co; Type: FK CONSTRAINT; Schema: public; Owner: hospital
7923--
7924
7925ALTER TABLE ONLY auth_permission
7926    ADD CONSTRAINT auth_permission_content_type_id_2f476e4b_fk_django_co FOREIGN KEY (content_type_id) REFERENCES django_content_type(id) DEFERRABLE INITIALLY DEFERRED;
7927
7928
7929--
7930-- Name: auth_user_groups auth_user_groups_group_id_97559544_fk_auth_group_id; Type: FK CONSTRAINT; Schema: public; Owner: hospital
7931--
7932
7933ALTER TABLE ONLY auth_user_groups
7934    ADD CONSTRAINT auth_user_groups_group_id_97559544_fk_auth_group_id FOREIGN KEY (group_id) REFERENCES auth_group(id) DEFERRABLE INITIALLY DEFERRED;
7935
7936
7937--
7938-- Name: auth_user_groups auth_user_groups_user_id_6a12ed8b_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: hospital
7939--
7940
7941ALTER TABLE ONLY auth_user_groups
7942    ADD CONSTRAINT auth_user_groups_user_id_6a12ed8b_fk_auth_user_id FOREIGN KEY (user_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED;
7943
7944
7945--
7946-- Name: auth_user_user_permissions auth_user_user_permi_permission_id_1fbb5f2c_fk_auth_perm; Type: FK CONSTRAINT; Schema: public; Owner: hospital
7947--
7948
7949ALTER TABLE ONLY auth_user_user_permissions
7950    ADD CONSTRAINT auth_user_user_permi_permission_id_1fbb5f2c_fk_auth_perm FOREIGN KEY (permission_id) REFERENCES auth_permission(id) DEFERRABLE INITIALLY DEFERRED;
7951
7952
7953--
7954-- Name: auth_user_user_permissions auth_user_user_permissions_user_id_a95ead1b_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: hospital
7955--
7956
7957ALTER TABLE ONLY auth_user_user_permissions
7958    ADD CONSTRAINT auth_user_user_permissions_user_id_a95ead1b_fk_auth_user_id FOREIGN KEY (user_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED;
7959
7960
7961--
7962-- Name: availablefacilities availablefacilities_facilities_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hospital
7963--
7964
7965ALTER TABLE ONLY availablefacilities
7966    ADD CONSTRAINT availablefacilities_facilities_id_fkey FOREIGN KEY (facilities_id) REFERENCES facilities(facilities_id);
7967
7968
7969--
7970-- Name: availablefacilities availablefacilities_facilities_services_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hospital
7971--
7972
7973ALTER TABLE ONLY availablefacilities
7974    ADD CONSTRAINT availablefacilities_facilities_services_id_fkey FOREIGN KEY (facilities_services_id) REFERENCES facilities_services(facilities_services_id);
7975
7976
7977--
7978-- Name: availablefacilities availablefacilities_healthproviders_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hospital
7979--
7980
7981ALTER TABLE ONLY availablefacilities
7982    ADD CONSTRAINT availablefacilities_healthproviders_id_fkey FOREIGN KEY (healthproviders_id) REFERENCES healthproviders(healthproviders_id);
7983
7984
7985--
7986-- Name: clinician_memberships clinician_memberships_city_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hospital
7987--
7988
7989ALTER TABLE ONLY clinician_memberships
7990    ADD CONSTRAINT clinician_memberships_city_id_fkey FOREIGN KEY (city_id) REFERENCES city(city_id);
7991
7992
7993--
7994-- Name: clinician_memberships clinician_memberships_country_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hospital
7995--
7996
7997ALTER TABLE ONLY clinician_memberships
7998    ADD CONSTRAINT clinician_memberships_country_id_fkey FOREIGN KEY (country_id) REFERENCES country(country_id);
7999
8000
8001--
8002-- Name: clinicians_dates clinicians_dates_clinicians_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hospital
8003--
8004
8005ALTER TABLE ONLY clinicians_dates
8006    ADD CONSTRAINT clinicians_dates_clinicians_id_fkey FOREIGN KEY (clinicians_id) REFERENCES clinicians(clinicians_id);
8007
8008
8009--
8010-- Name: clinicians_dates clinicians_dates_timeslots_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hospital
8011--
8012
8013ALTER TABLE ONLY clinicians_dates
8014    ADD CONSTRAINT clinicians_dates_timeslots_id_fkey FOREIGN KEY (timeslots_id) REFERENCES timeslots(timeslots_id);
8015
8016
8017--
8018-- Name: clinicians_dates clinicians_dates_week_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hospital
8019--
8020
8021ALTER TABLE ONLY clinicians_dates
8022    ADD CONSTRAINT clinicians_dates_week_id_fkey FOREIGN KEY (week_id) REFERENCES week(week_id);
8023
8024
8025--
8026-- Name: clinicians_education clinicians_education_clinicians_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hospital
8027--
8028
8029ALTER TABLE ONLY clinicians_education
8030    ADD CONSTRAINT clinicians_education_clinicians_id_fkey FOREIGN KEY (clinicians_id) REFERENCES clinicians(clinicians_id);
8031
8032
8033--
8034-- Name: clinicians_education clinicians_education_qualification_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hospital
8035--
8036
8037ALTER TABLE ONLY clinicians_education
8038    ADD CONSTRAINT clinicians_education_qualification_id_fkey FOREIGN KEY (qualification_id) REFERENCES qualification(qualification_id);
8039
8040
8041--
8042-- Name: clinicians_experience clinicians_experience_clinicians_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hospital
8043--
8044
8045ALTER TABLE ONLY clinicians_experience
8046    ADD CONSTRAINT clinicians_experience_clinicians_id_fkey FOREIGN KEY (clinicians_id) REFERENCES clinicians(clinicians_id);
8047
8048
8049--
8050-- Name: clinicians_experience clinicians_experience_designation_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hospital
8051--
8052
8053ALTER TABLE ONLY clinicians_experience
8054    ADD CONSTRAINT clinicians_experience_designation_id_fkey FOREIGN KEY (designation_id) REFERENCES designation(designation_id);
8055
8056
8057--
8058-- Name: clinicians clinicians_gender_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hospital
8059--
8060
8061ALTER TABLE ONLY clinicians
8062    ADD CONSTRAINT clinicians_gender_id_fkey FOREIGN KEY (gender_id) REFERENCES gender(gender_id);
8063
8064
8065--
8066-- Name: clinicians clinicians_languages_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hospital
8067--
8068
8069ALTER TABLE ONLY clinicians
8070    ADD CONSTRAINT clinicians_languages_id_fkey FOREIGN KEY (languages_id) REFERENCES languages(languages_id);
8071
8072
8073--
8074-- Name: clinicians_speciality clinicians_speciality_clinicians_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hospital
8075--
8076
8077ALTER TABLE ONLY clinicians_speciality
8078    ADD CONSTRAINT clinicians_speciality_clinicians_id_fkey FOREIGN KEY (clinicians_id) REFERENCES clinicians(clinicians_id);
8079
8080
8081--
8082-- Name: clinicians_speciality clinicians_speciality_healthproviders_speciality_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hospital
8083--
8084
8085ALTER TABLE ONLY clinicians_speciality
8086    ADD CONSTRAINT clinicians_speciality_healthproviders_speciality_id_fkey FOREIGN KEY (healthproviders_speciality_id) REFERENCES healthproviders_speciality(healthproviders_speciality_id);
8087
8088
8089--
8090-- Name: clinicians_speciality clinicians_speciality_symptoms_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hospital
8091--
8092
8093ALTER TABLE ONLY clinicians_speciality
8094    ADD CONSTRAINT clinicians_speciality_symptoms_id_fkey FOREIGN KEY (symptoms_id) REFERENCES symptoms(symptoms_id);
8095
8096
8097--
8098-- Name: clinicians clinicians_users_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hospital
8099--
8100
8101ALTER TABLE ONLY clinicians
8102    ADD CONSTRAINT clinicians_users_id_fkey FOREIGN KEY (users_id) REFERENCES users(users_id);
8103
8104
8105--
8106-- Name: discountcard_family discountcard_family_discountcard_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hospital
8107--
8108
8109ALTER TABLE ONLY discountcard_family
8110    ADD CONSTRAINT discountcard_family_discountcard_id_fkey FOREIGN KEY (discountcard_id) REFERENCES discountcard(discountcard_id);
8111
8112
8113--
8114-- Name: discountcard_family_extra discountcard_family_extra_discountcard_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hospital
8115--
8116
8117ALTER TABLE ONLY discountcard_family_extra
8118    ADD CONSTRAINT discountcard_family_extra_discountcard_id_fkey FOREIGN KEY (discountcard_id) REFERENCES discountcard(discountcard_id);
8119
8120
8121--
8122-- Name: discountcard_family_extra discountcard_family_extra_family_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hospital
8123--
8124
8125ALTER TABLE ONLY discountcard_family_extra
8126    ADD CONSTRAINT discountcard_family_extra_family_id_fkey FOREIGN KEY (family_id) REFERENCES family(family_id);
8127
8128
8129--
8130-- Name: discountcard_family discountcard_family_family_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hospital
8131--
8132
8133ALTER TABLE ONLY discountcard_family
8134    ADD CONSTRAINT discountcard_family_family_id_fkey FOREIGN KEY (family_id) REFERENCES family(family_id);
8135
8136
8137--
8138-- Name: discountcard discountcard_healthchecks_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hospital
8139--
8140
8141ALTER TABLE ONLY discountcard
8142    ADD CONSTRAINT discountcard_healthchecks_id_fkey FOREIGN KEY (healthchecks_id) REFERENCES healthchecks(healthchecks_id);
8143
8144
8145--
8146-- Name: django_admin_log django_admin_log_content_type_id_c4bce8eb_fk_django_co; Type: FK CONSTRAINT; Schema: public; Owner: hospital
8147--
8148
8149ALTER TABLE ONLY django_admin_log
8150    ADD CONSTRAINT django_admin_log_content_type_id_c4bce8eb_fk_django_co FOREIGN KEY (content_type_id) REFERENCES django_content_type(id) DEFERRABLE INITIALLY DEFERRED;
8151
8152
8153--
8154-- Name: django_admin_log django_admin_log_user_id_c564eba6_fk; Type: FK CONSTRAINT; Schema: public; Owner: hospital
8155--
8156
8157ALTER TABLE ONLY django_admin_log
8158    ADD CONSTRAINT django_admin_log_user_id_c564eba6_fk FOREIGN KEY (user_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED;
8159
8160
8161--
8162-- Name: facilities_services facilities_services_facilities_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hospital
8163--
8164
8165ALTER TABLE ONLY facilities_services
8166    ADD CONSTRAINT facilities_services_facilities_id_fkey FOREIGN KEY (facilities_id) REFERENCES facilities(facilities_id);
8167
8168
8169--
8170-- Name: feedback feedback_users_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hospital
8171--
8172
8173ALTER TABLE ONLY feedback
8174    ADD CONSTRAINT feedback_users_id_fkey FOREIGN KEY (users_id) REFERENCES users(users_id);
8175
8176
8177--
8178-- Name: healthcheckbooking healthcheckbooking_bookingsources_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hospital
8179--
8180
8181ALTER TABLE ONLY healthcheckbooking
8182    ADD CONSTRAINT healthcheckbooking_bookingsources_id_fkey FOREIGN KEY (bookingsources_id) REFERENCES bookingsources(bookingsources_id);
8183
8184
8185--
8186-- Name: healthcheckbooking healthcheckbooking_healthproviders_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hospital
8187--
8188
8189ALTER TABLE ONLY healthcheckbooking
8190    ADD CONSTRAINT healthcheckbooking_healthproviders_id_fkey FOREIGN KEY (healthproviders_id) REFERENCES healthproviders(healthproviders_id);
8191
8192
8193--
8194-- Name: healthcheckbooking healthcheckbooking_healthseeker_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hospital
8195--
8196
8197ALTER TABLE ONLY healthcheckbooking
8198    ADD CONSTRAINT healthcheckbooking_healthseeker_id_fkey FOREIGN KEY (healthseeker_id) REFERENCES healthseeker(healthseeker_id);
8199
8200
8201--
8202-- Name: healthchecks healthchecks_coupons_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hospital
8203--
8204
8205ALTER TABLE ONLY healthchecks
8206    ADD CONSTRAINT healthchecks_coupons_id_fkey FOREIGN KEY (coupons_id) REFERENCES coupons(coupons_id);
8207
8208
8209--
8210-- Name: healthchecks_inclusion healthchecks_inclusion_healthchecks_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hospital
8211--
8212
8213ALTER TABLE ONLY healthchecks_inclusion
8214    ADD CONSTRAINT healthchecks_inclusion_healthchecks_id_fkey FOREIGN KEY (healthchecks_id) REFERENCES healthchecks(healthchecks_id);
8215
8216
8217--
8218-- Name: healthchecks_inclusion healthchecks_inclusion_test_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hospital
8219--
8220
8221ALTER TABLE ONLY healthchecks_inclusion
8222    ADD CONSTRAINT healthchecks_inclusion_test_id_fkey FOREIGN KEY (test_id) REFERENCES test(test_id);
8223
8224
8225--
8226-- Name: healthproviders healthproviders_address_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hospital
8227--
8228
8229ALTER TABLE ONLY healthproviders
8230    ADD CONSTRAINT healthproviders_address_id_fkey FOREIGN KEY (address_id) REFERENCES address(address_id);
8231
8232
8233--
8234-- Name: healthproviders_speciality healthproviders_speciality_healthproviders_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hospital
8235--
8236
8237ALTER TABLE ONLY healthproviders_speciality
8238    ADD CONSTRAINT healthproviders_speciality_healthproviders_id_fkey FOREIGN KEY (healthproviders_id) REFERENCES healthproviders(healthproviders_id);
8239
8240
8241--
8242-- Name: healthproviders_speciality healthproviders_speciality_speciality_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hospital
8243--
8244
8245ALTER TABLE ONLY healthproviders_speciality
8246    ADD CONSTRAINT healthproviders_speciality_speciality_id_fkey FOREIGN KEY (speciality_id) REFERENCES speciality(speciality_id);
8247
8248
8249--
8250-- Name: healthproviders healthproviders_users_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hospital
8251--
8252
8253ALTER TABLE ONLY healthproviders
8254    ADD CONSTRAINT healthproviders_users_id_fkey FOREIGN KEY (users_id) REFERENCES users(users_id);
8255
8256
8257--
8258-- Name: healthseeker_alerts healthseeker_alerts_alertsources_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hospital
8259--
8260
8261ALTER TABLE ONLY healthseeker_alerts
8262    ADD CONSTRAINT healthseeker_alerts_alertsources_id_fkey FOREIGN KEY (alertsources_id) REFERENCES alertsources(alertsources_id);
8263
8264
8265--
8266-- Name: healthseeker_alerts healthseeker_alerts_alerttype_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hospital
8267--
8268
8269ALTER TABLE ONLY healthseeker_alerts
8270    ADD CONSTRAINT healthseeker_alerts_alerttype_id_fkey FOREIGN KEY (alerttype_id) REFERENCES alerttype(alerttype_id);
8271
8272
8273--
8274-- Name: healthseeker_alerts healthseeker_alerts_healthseeker_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hospital
8275--
8276
8277ALTER TABLE ONLY healthseeker_alerts
8278    ADD CONSTRAINT healthseeker_alerts_healthseeker_id_fkey FOREIGN KEY (healthseeker_id) REFERENCES healthseeker(healthseeker_id);
8279
8280
8281--
8282-- Name: healthseeker_availabilities healthseeker_availabilities_coupons_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hospital
8283--
8284
8285ALTER TABLE ONLY healthseeker_availabilities
8286    ADD CONSTRAINT healthseeker_availabilities_coupons_id_fkey FOREIGN KEY (coupons_id) REFERENCES coupons(coupons_id);
8287
8288
8289--
8290-- Name: healthseeker_availabilities healthseeker_availabilities_discountcard_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hospital
8291--
8292
8293ALTER TABLE ONLY healthseeker_availabilities
8294    ADD CONSTRAINT healthseeker_availabilities_discountcard_id_fkey FOREIGN KEY (discountcard_id) REFERENCES discountcard(discountcard_id);
8295
8296
8297--
8298-- Name: healthseeker_availabilities healthseeker_availabilities_healthchecks_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hospital
8299--
8300
8301ALTER TABLE ONLY healthseeker_availabilities
8302    ADD CONSTRAINT healthseeker_availabilities_healthchecks_id_fkey FOREIGN KEY (healthchecks_id) REFERENCES healthchecks(healthchecks_id);
8303
8304
8305--
8306-- Name: healthseeker_availabilities healthseeker_availabilities_healthseeker_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hospital
8307--
8308
8309ALTER TABLE ONLY healthseeker_availabilities
8310    ADD CONSTRAINT healthseeker_availabilities_healthseeker_id_fkey FOREIGN KEY (healthseeker_id) REFERENCES healthseeker(healthseeker_id);
8311
8312
8313--
8314-- Name: healthseeker healthseeker_gender_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hospital
8315--
8316
8317ALTER TABLE ONLY healthseeker
8318    ADD CONSTRAINT healthseeker_gender_id_fkey FOREIGN KEY (gender_id) REFERENCES gender(gender_id);
8319
8320
8321--
8322-- Name: healthseeker_healthrecords healthseeker_healthrecords_healthrecords_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hospital
8323--
8324
8325ALTER TABLE ONLY healthseeker_healthrecords
8326    ADD CONSTRAINT healthseeker_healthrecords_healthrecords_id_fkey FOREIGN KEY (healthrecords_id) REFERENCES healthrecords(healthrecords_id);
8327
8328
8329--
8330-- Name: healthseeker_healthrecords healthseeker_healthrecords_healthseeker_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hospital
8331--
8332
8333ALTER TABLE ONLY healthseeker_healthrecords
8334    ADD CONSTRAINT healthseeker_healthrecords_healthseeker_id_fkey FOREIGN KEY (healthseeker_id) REFERENCES healthseeker(healthseeker_id);
8335
8336
8337--
8338-- Name: healthseeker healthseeker_healthseeker_type_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hospital
8339--
8340
8341ALTER TABLE ONLY healthseeker
8342    ADD CONSTRAINT healthseeker_healthseeker_type_id_fkey FOREIGN KEY (healthseeker_type_id) REFERENCES healthseeker_type(healthseeker_type_id);
8343
8344
8345--
8346-- Name: healthseeker healthseeker_languages_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hospital
8347--
8348
8349ALTER TABLE ONLY healthseeker
8350    ADD CONSTRAINT healthseeker_languages_id_fkey FOREIGN KEY (languages_id) REFERENCES languages(languages_id);
8351
8352
8353--
8354-- Name: healthseeker healthseeker_profession_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hospital
8355--
8356
8357ALTER TABLE ONLY healthseeker
8358    ADD CONSTRAINT healthseeker_profession_id_fkey FOREIGN KEY (profession_id) REFERENCES profession(profession_id);
8359
8360
8361--
8362-- Name: healthseeker healthseeker_users_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hospital
8363--
8364
8365ALTER TABLE ONLY healthseeker
8366    ADD CONSTRAINT healthseeker_users_id_fkey FOREIGN KEY (users_id) REFERENCES users(users_id);
8367
8368
8369--
8370-- Name: interest interest_healthseeker_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hospital
8371--
8372
8373ALTER TABLE ONLY interest
8374    ADD CONSTRAINT interest_healthseeker_id_fkey FOREIGN KEY (healthseeker_id) REFERENCES healthseeker(healthseeker_id);
8375
8376
8377--
8378-- Name: photoalbum photoalbum_users_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hospital
8379--
8380
8381ALTER TABLE ONLY photoalbum
8382    ADD CONSTRAINT photoalbum_users_id_fkey FOREIGN KEY (users_id) REFERENCES users(users_id);
8383
8384
8385--
8386-- Name: plans_groups plans_groups_plans_groups_specialities_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hospital
8387--
8388
8389ALTER TABLE ONLY plans_groups
8390    ADD CONSTRAINT plans_groups_plans_groups_specialities_id_fkey FOREIGN KEY (plans_groups_specialities_id) REFERENCES plans_groups_specialities(plans_groups_specialities_id);
8391
8392
8393--
8394-- Name: plans plans_plans_groups_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hospital
8395--
8396
8397ALTER TABLE ONLY plans
8398    ADD CONSTRAINT plans_plans_groups_id_fkey FOREIGN KEY (plans_groups_id) REFERENCES plans_groups(plans_groups_id);
8399
8400
8401--
8402-- Name: resellerpackages resellerpackages_salestarget_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hospital
8403--
8404
8405ALTER TABLE ONLY resellerpackages
8406    ADD CONSTRAINT resellerpackages_salestarget_id_fkey FOREIGN KEY (salestarget_id) REFERENCES salestarget(salestarget_id);
8407
8408
8409--
8410-- Name: resellers resellers_users_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hospital
8411--
8412
8413ALTER TABLE ONLY resellers
8414    ADD CONSTRAINT resellers_users_id_fkey FOREIGN KEY (users_id) REFERENCES users(users_id);
8415
8416
8417--
8418-- Name: salesagentpackages salesagentpackages_salestarget_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hospital
8419--
8420
8421ALTER TABLE ONLY salesagentpackages
8422    ADD CONSTRAINT salesagentpackages_salestarget_id_fkey FOREIGN KEY (salestarget_id) REFERENCES salestarget(salestarget_id);
8423
8424
8425--
8426-- Name: salesagents salesagents_users_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hospital
8427--
8428
8429ALTER TABLE ONLY salesagents
8430    ADD CONSTRAINT salesagents_users_id_fkey FOREIGN KEY (users_id) REFERENCES users(users_id);
8431
8432
8433--
8434-- Name: speciality speciality_qualification_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hospital
8435--
8436
8437ALTER TABLE ONLY speciality
8438    ADD CONSTRAINT speciality_qualification_id_fkey FOREIGN KEY (qualification_id) REFERENCES qualification(qualification_id);
8439
8440
8441--
8442-- Name: speciality speciality_speciality_type_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hospital
8443--
8444
8445ALTER TABLE ONLY speciality
8446    ADD CONSTRAINT speciality_speciality_type_id_fkey FOREIGN KEY (speciality_type_id) REFERENCES speciality_type(speciality_type_id);
8447
8448
8449--
8450-- Name: sponsors sponsors_businessregtype_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hospital
8451--
8452
8453ALTER TABLE ONLY sponsors
8454    ADD CONSTRAINT sponsors_businessregtype_id_fkey FOREIGN KEY (businessregtype_id) REFERENCES businessregtype(businessregtype_id);
8455
8456
8457--
8458-- Name: sponsors sponsors_sponsors_group_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hospital
8459--
8460
8461ALTER TABLE ONLY sponsors
8462    ADD CONSTRAINT sponsors_sponsors_group_id_fkey FOREIGN KEY (sponsors_group_id) REFERENCES sponsors_group(sponsors_group_id);
8463
8464
8465--
8466-- Name: sponsors sponsors_users_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hospital
8467--
8468
8469ALTER TABLE ONLY sponsors
8470    ADD CONSTRAINT sponsors_users_id_fkey FOREIGN KEY (users_id) REFERENCES users(users_id);
8471
8472
8473--
8474-- Name: symptoms symptoms_speciality_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hospital
8475--
8476
8477ALTER TABLE ONLY symptoms
8478    ADD CONSTRAINT symptoms_speciality_id_fkey FOREIGN KEY (speciality_id) REFERENCES speciality(speciality_id);
8479
8480
8481--
8482-- Name: telephone telephone_address_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hospital
8483--
8484
8485ALTER TABLE ONLY telephone
8486    ADD CONSTRAINT telephone_address_id_fkey FOREIGN KEY (address_id) REFERENCES address(address_id);
8487
8488
8489--
8490-- Name: test_subcategory test_subcategory_test_category_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hospital
8491--
8492
8493ALTER TABLE ONLY test_subcategory
8494    ADD CONSTRAINT test_subcategory_test_category_id_fkey FOREIGN KEY (test_category_id) REFERENCES test_category(test_category_id);
8495
8496
8497--
8498-- Name: test test_test_category_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hospital
8499--
8500
8501ALTER TABLE ONLY test
8502    ADD CONSTRAINT test_test_category_id_fkey FOREIGN KEY (test_category_id) REFERENCES test_category(test_category_id);
8503
8504
8505--
8506-- Name: test test_test_subcategory_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hospital
8507--
8508
8509ALTER TABLE ONLY test
8510    ADD CONSTRAINT test_test_subcategory_id_fkey FOREIGN KEY (test_subcategory_id) REFERENCES test_subcategory(test_subcategory_id);
8511
8512
8513--
8514-- Name: testimonials testimonials_users_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hospital
8515--
8516
8517ALTER TABLE ONLY testimonials
8518    ADD CONSTRAINT testimonials_users_id_fkey FOREIGN KEY (users_id) REFERENCES users(users_id);
8519
8520
8521--
8522-- Name: trxn_appointmentbookings trxn_appointmentbookings_appointmentbooking_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hospital
8523--
8524
8525ALTER TABLE ONLY trxn_appointmentbookings
8526    ADD CONSTRAINT trxn_appointmentbookings_appointmentbooking_id_fkey FOREIGN KEY (appointmentbooking_id, appointmentbooking_date) REFERENCES appointmentbooking(appointmentbooking_id, date);
8527
8528
8529--
8530-- Name: trxn_coupons trxn_coupons_coupons_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hospital
8531--
8532
8533ALTER TABLE ONLY trxn_coupons
8534    ADD CONSTRAINT trxn_coupons_coupons_id_fkey FOREIGN KEY (coupons_id) REFERENCES coupons(coupons_id);
8535
8536
8537--
8538-- Name: trxn_discountcard trxn_discountcard_discountcard_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hospital
8539--
8540
8541ALTER TABLE ONLY trxn_discountcard
8542    ADD CONSTRAINT trxn_discountcard_discountcard_id_fkey FOREIGN KEY (discountcard_id) REFERENCES discountcard(discountcard_id);
8543
8544
8545--
8546-- Name: trxn_healthcheckbooking trxn_healthcheckbooking_healthcheckbooking_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hospital
8547--
8548
8549ALTER TABLE ONLY trxn_healthcheckbooking
8550    ADD CONSTRAINT trxn_healthcheckbooking_healthcheckbooking_id_fkey FOREIGN KEY (healthcheckbooking_id) REFERENCES healthcheckbooking(healthcheckbooking_id);
8551
8552
8553--
8554-- Name: users users_role_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hospital
8555--
8556
8557ALTER TABLE ONLY users
8558    ADD CONSTRAINT users_role_id_fkey FOREIGN KEY (role_id) REFERENCES role(role_id);
8559
8560
8561--
8562-- Name: users users_secretquestions_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hospital
8563--
8564
8565ALTER TABLE ONLY users
8566    ADD CONSTRAINT users_secretquestions_id_fkey FOREIGN KEY (secretquestions_id) REFERENCES secretquestions(secretquestions_id);
8567
8568
8569--
8570-- Name: wellnessplan wellnessplan_agegroup_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hospital
8571--
8572
8573ALTER TABLE ONLY wellnessplan
8574    ADD CONSTRAINT wellnessplan_agegroup_id_fkey FOREIGN KEY (agegroup_id) REFERENCES agegroup(agegroup_id);
8575
8576
8577--
8578-- Name: wellnessplan wellnessplan_conditions_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hospital
8579--
8580
8581ALTER TABLE ONLY wellnessplan
8582    ADD CONSTRAINT wellnessplan_conditions_id_fkey FOREIGN KEY (conditions_id) REFERENCES conditions(conditions_id);
8583
8584
8585--
8586-- Name: wellnessplan wellnessplan_wellnessplan_profession_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hospital
8587--
8588
8589ALTER TABLE ONLY wellnessplan
8590    ADD CONSTRAINT wellnessplan_wellnessplan_profession_id_fkey FOREIGN KEY (wellnessplan_profession_id) REFERENCES wellnessplan_profession(wellnessplan_profession_id);
8591
8592
8593--
8594-- Name: wellnessplan wellnessplan_wellnessplan_socialhistory_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hospital
8595--
8596
8597ALTER TABLE ONLY wellnessplan
8598    ADD CONSTRAINT wellnessplan_wellnessplan_socialhistory_id_fkey FOREIGN KEY (wellnessplan_socialhistory_id) REFERENCES wellnessplan_socialhistory(wellnessplan_socialhistory_id);
8599
8600
8601--
8602-- PostgreSQL database dump complete
8603--