API tools faq
paste
Advertisement
Guest User

sewaproperti

a guest
Sep 14th, 2019
184
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PostgreSQL 7.01 KB | None | 0 0
raw download clone embed print report
  1. --
  2. -- PostgreSQL database dump
  3. --
  4.  
  5. -- Dumped from database version 11.5
  6. -- Dumped by pg_dump version 11.5
  7.  
  8. SET statement_timeout = 0;
  9. SET lock_timeout = 0;
  10. SET idle_in_transaction_session_timeout = 0;
  11. SET client_encoding = 'UTF8';
  12. SET standard_conforming_strings = on;
  13. SELECT pg_catalog.set_config('search_path', '', false);
  14. SET check_function_bodies = false;
  15. SET xmloption = content;
  16. SET client_min_messages = warning;
  17. SET row_security = off;
  18.  
  19. SET default_tablespace = '';
  20.  
  21. SET default_with_oids = false;
  22.  
  23. --
  24. -- Name: branch; Type: TABLE; Schema: public; Owner: postgres
  25. --
  26.  
  27. CREATE TABLE public.branch (
  28.     branchno character varying(4) NOT NULL,
  29.     street character varying(30) NOT NULL,
  30.     city character varying(20) NOT NULL,
  31.     postcode character varying(20) NOT NULL
  32. );
  33.  
  34.  
  35. ALTER TABLE public.branch OWNER TO postgres;
  36.  
  37. --
  38. -- Name: client; Type: TABLE; Schema: public; Owner: postgres
  39. --
  40.  
  41. CREATE TABLE public.client (
  42.     clientno character varying(4) NOT NULL,
  43.     fname character varying(20) NOT NULL,
  44.     lname character varying(20) NOT NULL,
  45.     telno character varying(20) NOT NULL,
  46.     preftype character varying(20) NOT NULL,
  47.     maxrent numeric NOT NULL
  48. );
  49.  
  50.  
  51. ALTER TABLE public.client OWNER TO postgres;
  52.  
  53. --
  54. -- Name: privateowner; Type: TABLE; Schema: public; Owner: postgres
  55. --
  56.  
  57. CREATE TABLE public.privateowner (
  58.     ownerno character varying(7) NOT NULL,
  59.     fname character varying(20) NOT NULL,
  60.     lname character varying(20) NOT NULL,
  61.     address character varying(40) NOT NULL,
  62.     telno character varying(20) NOT NULL
  63. );
  64.  
  65.  
  66. ALTER TABLE public.privateowner OWNER TO postgres;
  67.  
  68. --
  69. -- Name: propertyforrent; Type: TABLE; Schema: public; Owner: postgres
  70. --
  71.  
  72. CREATE TABLE public.propertyforrent (
  73.     propertyno character varying(4) NOT NULL,
  74.     street character varying(20) NOT NULL,
  75.     city character varying(20) NOT NULL,
  76.     postcode character varying(20) NOT NULL,
  77.     type character varying(10) NOT NULL,
  78.     rooms integer NOT NULL,
  79.     rent numeric NOT NULL,
  80.     ownerno character varying(7) NOT NULL,
  81.     staffno character varying(8),
  82.     branchno character varying(4) NOT NULL
  83. );
  84.  
  85.  
  86. ALTER TABLE public.propertyforrent OWNER TO postgres;
  87.  
  88. --
  89. -- Name: registration; Type: TABLE; Schema: public; Owner: postgres
  90. --
  91.  
  92. CREATE TABLE public.registration (
  93.     clientno character varying(4) NOT NULL,
  94.     branchno character varying(4) NOT NULL,
  95.     staffno character varying(8),
  96.     datejoined date NOT NULL
  97. );
  98.  
  99.  
  100. ALTER TABLE public.registration OWNER TO postgres;
  101.  
  102. --
  103. -- Name: staff; Type: TABLE; Schema: public; Owner: postgres
  104. --
  105.  
  106. CREATE TABLE public.staff (
  107.     staffno character varying(8) NOT NULL,
  108.     fname character varying(20) NOT NULL,
  109.     lname character varying(20) NOT NULL,
  110.     "position" character varying(20) NOT NULL,
  111.     sex character varying(1) NOT NULL,
  112.     dob date NOT NULL,
  113.     salary numeric,
  114.     branchno character varying(4) NOT NULL
  115. );
  116.  
  117.  
  118. ALTER TABLE public.staff OWNER TO postgres;
  119.  
  120. --
  121. -- Name: viewing; Type: TABLE; Schema: public; Owner: postgres
  122. --
  123.  
  124. CREATE TABLE public.viewing (
  125.     clientno character varying(4) NOT NULL,
  126.     propertyno character varying(4) NOT NULL,
  127.     viewdate date NOT NULL,
  128.     comment character varying(60)
  129. );
  130.  
  131.  
  132. ALTER TABLE public.viewing OWNER TO postgres;
  133.  
  134. --
  135. -- Data for Name: branch; Type: TABLE DATA; Schema: public; Owner: postgres
  136. --
  137.  
  138. COPY public.branch (branchno, street, city, postcode) FROM stdin;
  139. B005    22 Deer Rd  London  SWl 4EH
  140. B007    16 Argyll St    Aberdeen    AB2 3SU
  141. B003    163 Main St     Glasgow Gil 9QX
  142. B004    32 Manse Rd     Bristol     BS99 1NZ
  143. B002    56 Clover Dr    London  NW10 6EU
  144. \.
  145.  
  146.  
  147. --
  148. -- Data for Name: client; Type: TABLE DATA; Schema: public; Owner: postgres
  149. --
  150.  
  151. COPY public.client (clientno, fname, lname, telno, preftype, maxrent) FROM stdin;
  152. CR76    John    Kay 0207-774-5632   Flat    425
  153. CR56    Aline   Stewart 0141-848-1825   Flat    350
  154. CR74    Mike    Ritchie 01475-392178    House   750
  155. CR62    Mary    Tregear 01224-196720    Flat    600
  156. \.
  157.  
  158.  
  159. --
  160. -- Data for Name: privateowner; Type: TABLE DATA; Schema: public; Owner: postgres
  161. --
  162.  
  163. COPY public.privateowner (ownerno, fname, lname, address, telno) FROM stdin;
  164. CO46    Joe Keogh   2 Fergus Dr, Aberdeen AB2 7SX   01224-861212
  165. CO87    Carol   Farrel  6 Achray St, Glasgow G32 9DX    0141-357-7419
  166. CO40    Tina    Murphy  63 Well St, Glasgow G42 0141-943-1728
  167. CO93    Tony    Shaw    12 Park Pl, Glasgow G4 0QR  0141-225-7025
  168. \.
  169.  
  170.  
  171. --
  172. -- Data for Name: propertyforrent; Type: TABLE DATA; Schema: public; Owner: postgres
  173. --
  174.  
  175. COPY public.propertyforrent (propertyno, street, city, postcode, type, rooms, rent, ownerno, staffno, branchno) FROM stdin;
  176. PAM 16 Holhead  Aberdeen    AB7 5SU House   6   650 CO46    SA9 B007
  177. PL94    6 Argyll St London  NW2 Flat    4   400 CO87    SL41    B005
  178. PG4 6 Lawrence St   Glasgow G1I 9QX Flat    3   350 CO40    \N  B003
  179. PG36    2 Manor Rd  Glasgow G32 4QX Flat    3   375 CO93    SG37    B003
  180. PG21    18 Dale Rd  Glasgow G12 House   5   600 CO87    SG37    B003
  181. PG16    5 Novar Dr  Glasgow G12 9AX Flat    4   450 CO93    SG14    B003
  182. \.
  183.  
  184.  
  185. --
  186. -- Data for Name: registration; Type: TABLE DATA; Schema: public; Owner: postgres
  187. --
  188.  
  189. COPY public.registration (clientno, branchno, staffno, datejoined) FROM stdin;
  190. CR76    SL41    SL41    2001-01-02
  191. CR56    SG37    SG37    2000-04-11
  192. CR74    SG37    SG37    1999-11-16
  193. CR62    SA9 SA9     2000-03-07
  194. \.
  195.  
  196.  
  197. --
  198. -- Data for Name: staff; Type: TABLE DATA; Schema: public; Owner: postgres
  199. --
  200.  
  201. COPY public.staff (staffno, fname, lname, "position", sex, dob, salary, branchno) FROM stdin;
  202. SL21    John    White   Manager M   1945-10-01  30000   B005
  203. SG37    Ann     Beech    Assistant  F   1960-11-10  12000   B003
  204. SG14    David   Ford     Supervisor     M   1958-03-24  18000   B003
  205. SA9 Mary    Howe    Assistant   F   1970-02-19  9000    B007
  206. SG5 Susan   Brand   Manager     F   1940-06-03  24000   B003
  207. SL41    Julie   Lee     Assistant   F   1965-06-13  9000    B005
  208. \.
  209.  
  210.  
  211. --
  212. -- Data for Name: viewing; Type: TABLE DATA; Schema: public; Owner: postgres
  213. --
  214.  
  215. COPY public.viewing (clientno, propertyno, viewdate, comment) FROM stdin;
  216. CR56    PAM     2001-05-24  too small
  217. CR76    PG4     2001-04-20  too remote
  218. CR56    PG4     2001-05-26  \N
  219. CR62    PAM     2001-05-14  no dining room
  220. CR56    PG36    2001-04-28  \N
  221. \.
  222.  
  223.  
  224. --
  225. -- Name: branch branch_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
  226. --
  227.  
  228. ALTER TABLE ONLY public.branch
  229.     ADD CONSTRAINT branch_pkey PRIMARY KEY (branchno);
  230.  
  231.  
  232. --
  233. -- Name: client client_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
  234. --
  235.  
  236. ALTER TABLE ONLY public.client
  237.     ADD CONSTRAINT client_pkey PRIMARY KEY (clientno);
  238.  
  239.  
  240. --
  241. -- Name: privateowner privateowner_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
  242. --
  243.  
  244. ALTER TABLE ONLY public.privateowner
  245.     ADD CONSTRAINT privateowner_pkey PRIMARY KEY (ownerno);
  246.  
  247.  
  248. --
  249. -- Name: propertyforrent propertyforrent_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
  250. --
  251.  
  252. ALTER TABLE ONLY public.propertyforrent
  253.     ADD CONSTRAINT propertyforrent_pkey PRIMARY KEY (propertyno);
  254.  
  255.  
  256. --
  257. -- Name: staff staff_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
  258. --
  259.  
  260. ALTER TABLE ONLY public.staff
  261.     ADD CONSTRAINT staff_pkey PRIMARY KEY (staffno);
  262.  
  263.  
  264. --
  265. -- PostgreSQL database dump complete
  266. --
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!