{"info":{"_postman_id":"14d7ddcb-975a-43e7-8b31-62a809357426","name":"디비마스터","schema":"https://schema.getpostman.com/json/collection/v2.0.0/collection.json","toc":[],"description":"","owner":"5249380","collectionId":"14d7ddcb-975a-43e7-8b31-62a809357426","publishedId":"Szmcaz3f","public":true,"customColor":{"top-bar":"FFFFFF","right-sidebar":"303030","highlight":"EF5B25"},"publishDate":"2020-05-06T12:29:35.000Z"},"item":[{"name":"회원가입/로그인","item":[{"name":"아이디 중복검사","id":"097d2270-1e29-46c9-9c36-3c22b01ef267","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\"name\" : \"uuzaza\"}","options":{"raw":{"language":"json"}}},"url":"http://localhost:8081/v1/sign-up/check-name","urlObject":{"protocol":"http","port":"8081","path":["v1","sign-up","check-name"],"host":["localhost"],"query":[],"variable":[]}},"response":[],"_postman_id":"097d2270-1e29-46c9-9c36-3c22b01ef267"},{"name":"회원가입","id":"317d2a32-99be-430d-a09f-eb44d576cb53","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\n\t\"name\" : \"##SEELECET\",\n\t\"pw\" : \"1q2w3e4r\"\n\t\n}\n","options":{"raw":{"language":"json"}}},"url":"http://localhost:8081/v1/sign-up/request","urlObject":{"protocol":"http","port":"8081","path":["v1","sign-up","request"],"host":["localhost"],"query":[],"variable":[]}},"response":[],"_postman_id":"317d2a32-99be-430d-a09f-eb44d576cb53"},{"name":"로그인","id":"b356443e-1181-48ab-bf0f-37ad8e95af53","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\n\t\"name\" : \"test\",\n\t\"pw\" : \"1q2w3e4r\"\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost:8081/v1/connection/check","urlObject":{"protocol":"http","port":"8081","path":["v1","connection","check"],"host":["localhost"],"query":[],"variable":[]}},"response":[],"_postman_id":"b356443e-1181-48ab-bf0f-37ad8e95af53"}],"id":"5e8d553c-55fd-4766-96d9-0218a580e08c","_postman_id":"5e8d553c-55fd-4766-96d9-0218a580e08c","description":""},{"name":"생성","item":[{"name":"테이블 생성","id":"d921bdf9-3a89-418b-abbd-6c99a29966ee","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\n\t\"name\" : \"test\",\n\t\"tableName\" : \"test3Table\",\n\t\"fieldInfo\" : \"sno int(11) NOT NULL, name char(10) DEFAULT NULL, PRIMARY KEY (sno)\"\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost:8081/v1/table/create","urlObject":{"protocol":"http","port":"8081","path":["v1","table","create"],"host":["localhost"],"query":[],"variable":[]}},"response":[],"_postman_id":"d921bdf9-3a89-418b-abbd-6c99a29966ee"},{"name":"특정 테이블 INSERT","id":"db69b269-bcc0-4e06-84e7-8105c07ad8b9","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\n\t\"tableName\" : \"tableB\",\n\t\"name\" : \"test\",\n\t\"insert\" : \"33,201723332, '01022993322', 'testname', 'addressexample'\"\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost:8081/v1/table/insert","urlObject":{"protocol":"http","port":"8081","path":["v1","table","insert"],"host":["localhost"],"query":[],"variable":[]}},"response":[],"_postman_id":"db69b269-bcc0-4e06-84e7-8105c07ad8b9"}],"id":"1baa9345-32ec-4000-a01b-165188324180","_postman_id":"1baa9345-32ec-4000-a01b-165188324180","description":""},{"name":"삭제","item":[{"name":"테이블 특정 컬럼 delete","id":"6d6eb7a6-4582-4a41-939c-3ac519482428","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\n\t\"name\" : \"test\",\n\t\"tableName\" : \"tableA\",\n\t\"primary_key_name\" : \"id\",\n\t\"primary_key_value\" : \"201524447\"\n}\n","options":{"raw":{"language":"json"}}},"url":"http://localhost:8081/v1/column/delete","urlObject":{"protocol":"http","port":"8081","path":["v1","column","delete"],"host":["localhost"],"query":[],"variable":[]}},"response":[],"_postman_id":"6d6eb7a6-4582-4a41-939c-3ac519482428"},{"name":"테이블 삭제","id":"85a4e995-9efb-4f11-b3ee-25a7bbb4c599","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\n\t\"name\" : \"qwer\",\n\t\"tableName\" : \"test2\"\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost:8081/v1/table/drop","urlObject":{"protocol":"http","port":"8081","path":["v1","table","drop"],"host":["localhost"],"query":[],"variable":[]}},"response":[],"_postman_id":"85a4e995-9efb-4f11-b3ee-25a7bbb4c599"}],"id":"94f430a0-a0ab-44ca-90ae-659b753993ee","_postman_id":"94f430a0-a0ab-44ca-90ae-659b753993ee","description":""},{"name":"조회","item":[{"name":"가진 테이블 모든 이름 조회","id":"aeeebf4d-657a-4496-9636-7b52e162045f","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\n\t\"name\" : \"test\"\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost:8081/v1/table/all-tables","urlObject":{"protocol":"http","port":"8081","path":["v1","table","all-tables"],"host":["localhost"],"query":[],"variable":[]}},"response":[],"_postman_id":"aeeebf4d-657a-4496-9636-7b52e162045f"},{"name":"테이블 정보 받기","id":"97398b02-11d3-4a93-8db6-049c260cf430","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\n\t\"name\" : \"deletelater\",\n\t\"tableName\" : \"new_table\"\n}\n\n","options":{"raw":{"language":"json"}}},"url":"http://localhost:8081/v1/table/get-info","urlObject":{"protocol":"http","port":"8081","path":["v1","table","get-info"],"host":["localhost"],"query":[],"variable":[]}},"response":[],"_postman_id":"97398b02-11d3-4a93-8db6-049c260cf430"},{"name":"테이블 데이터 전부 받아오기","id":"164b6f6b-34e6-49d0-a8a4-48e81f07ffc1","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\n\t\"tableName\" : \"testTable\",\n\t\"name\" : \"test\"\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost:8081/v1/column/get-all","urlObject":{"protocol":"http","port":"8081","path":["v1","column","get-all"],"host":["localhost"],"query":[],"variable":[]}},"response":[],"_postman_id":"164b6f6b-34e6-49d0-a8a4-48e81f07ffc1"}],"id":"7d78735b-58a5-4473-be5d-fad58e6f3542","_postman_id":"7d78735b-58a5-4473-be5d-fad58e6f3542","description":""},{"name":"수정","item":[{"name":"테이블 이름 수정","id":"9a34e14a-62fd-4b0d-9c47-af073ea1b8fb","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\n\t\"name\" : \"test\",\n\t\"tableName\" : \"tableA\",\n\t\"newName\" : \"\"\n\t\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost:8081/v1/table/rename","urlObject":{"protocol":"http","port":"8081","path":["v1","table","rename"],"host":["localhost"],"query":[],"variable":[]}},"response":[],"_postman_id":"9a34e14a-62fd-4b0d-9c47-af073ea1b8fb"},{"name":"테이블 특정 컬럼 update","id":"b80f4dac-0d37-49f6-8ddb-08b394030231","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\n\t\"name\" : \"uuzaza\",\n\t\"tableName\" : \"test1\",\n\t\"primary_key_name\" : \"sno\",\n\t\"primary_key_value\" : \"1\",\n\t\"update_column_name\" : \"name\",\n\t\"update_value\" : \"업데이트적용\"\n}\n","options":{"raw":{"language":"json"}}},"url":"http://localhost:8081/v1/column/update","urlObject":{"protocol":"http","port":"8081","path":["v1","column","update"],"host":["localhost"],"query":[],"variable":[]}},"response":[],"_postman_id":"b80f4dac-0d37-49f6-8ddb-08b394030231"}],"id":"4e9e5815-7b84-4cbe-a78e-9471e7f09119","_postman_id":"4e9e5815-7b84-4cbe-a78e-9471e7f09119","description":""},{"name":"테이블 이름 중복 검사","id":"121db53c-dab1-4f3d-b66b-5cd656cab90c","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"basic","basic":{"basicConfig":[{"key":"username","value":""},{"key":"password","value":""}]},"isInherited":false},"method":"GET","header":[],"body":{"mode":"formdata","formdata":[{"key":"username","value":"uuzaza@naver.com","type":"text","disabled":true},{"key":"password","value":"1q2w3e4r","type":"text","disabled":true}]},"url":"https://ttakeum.shop/vaccines/","urlObject":{"protocol":"https","path":["vaccines",""],"host":["ttakeum","shop"],"query":[],"variable":[]}},"response":[],"_postman_id":"121db53c-dab1-4f3d-b66b-5cd656cab90c"},{"name":"이메일 인증 요청 ","id":"794c8620-c939-4e70-89f9-09ebe729eaec","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\n\t\"email\" : \"uuzaza@naver.com\"\n}","options":{"raw":{"language":"json"}}},"url":"https://pnuteam03.herokuapp.com/v1/auth/request","urlObject":{"protocol":"https","path":["v1","auth","request"],"host":["pnuteam03","herokuapp","com"],"query":[],"variable":[]}},"response":[],"_postman_id":"794c8620-c939-4e70-89f9-09ebe729eaec"},{"name":"최종 인증 확인","id":"9e93e05f-44f9-4230-9571-592f093bd772","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\n\t\"email\" : \"uuzaza@naver.com\",\n\t\"authNum\" : \"556091\"\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost:8081/v1/auth/check","urlObject":{"protocol":"http","port":"8081","path":["v1","auth","check"],"host":["localhost"],"query":[],"variable":[]}},"response":[],"_postman_id":"9e93e05f-44f9-4230-9571-592f093bd772"},{"name":"테이블 내 데이터 검색","id":"7229bf3c-ab5d-4e39-9c55-aa58824c0884","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\n\t\"tableName\" : \"testTable\",\n\t\"name\" : \"test\",\n\t\"keyword\" : \"3\"\n}","options":{"raw":{"language":"json"}}},"url":"https://pnuteam03.herokuapp.com/v1/table/search","urlObject":{"protocol":"https","path":["v1","table","search"],"host":["pnuteam03","herokuapp","com"],"query":[],"variable":[]}},"response":[],"_postman_id":"7229bf3c-ab5d-4e39-9c55-aa58824c0884"},{"name":"사용자 지정 입력 쿼리문","id":"15b42e4d-6104-4e24-86e9-c7b8471a4acc","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\n\t\"name\" : \"test\",\n\t\"tableName\" : \"testTable\",\n\t\"query\" : \"SELECT * FROM test.testTable WHERE sno = 2\"\n}","options":{"raw":{"language":"json"}}},"url":"https://pnuteam03.herokuapp.com/v1/query/custom","urlObject":{"protocol":"https","path":["v1","query","custom"],"host":["pnuteam03","herokuapp","com"],"query":[],"variable":[]}},"response":[],"_postman_id":"15b42e4d-6104-4e24-86e9-c7b8471a4acc"},{"name":"테이블 export api","id":"a4b8cec3-10da-41ac-bd2c-981ec215e7da","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\n\t\"tableName\" : \"testTable\",\n\t\"name\" : \"test2\",\n\t\"email\" : \"uuzaza@naver.com\"\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost:8081/v1/table/export","urlObject":{"protocol":"http","port":"8081","path":["v1","table","export"],"host":["localhost"],"query":[],"variable":[]}},"response":[],"_postman_id":"a4b8cec3-10da-41ac-bd2c-981ec215e7da"},{"name":"사용자 비밀번호 수정 api","id":"a7001ddf-6a61-4952-95ae-3f614ede2efc","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\n\t\"name\" : \"test\",\n\t\"oldPw\" : \"test\",\n\t\"newPw\" : \"1q2w3e4r\"\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost:8081/v1/pw/change","urlObject":{"protocol":"http","port":"8081","path":["v1","pw","change"],"host":["localhost"],"query":[],"variable":[]}},"response":[],"_postman_id":"a7001ddf-6a61-4952-95ae-3f614ede2efc"},{"name":"Tablei join API ","id":"f67fc507-d400-4d10-837d-ea1922043052","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\n\t\"name\" : \"test\",\n\t\"tableName\" : \"tableA\",\n\t\"joinTable\" : \"tableB\",\n\t\"joiningColumn\" : \"id\"\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost:8081/v1/table/join","urlObject":{"protocol":"http","port":"8081","path":["v1","table","join"],"host":["localhost"],"query":[],"variable":[]}},"response":[],"_postman_id":"f67fc507-d400-4d10-837d-ea1922043052"},{"name":"특정 칼럼 기준 정렬 API ","id":"7c445c72-6a39-451f-9b1f-e7ba1588156b","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\n\t\"name\" : \"test\",\n\t\"tableName\" : \"testTable\",\n\t\"sortColumn\" : \"name\",\n\t\"direction\" : \"DESCa\"\n}\n","options":{"raw":{"language":"json"}}},"url":"http://localhost:8081/v1/table/sort","urlObject":{"protocol":"http","port":"8081","path":["v1","table","sort"],"host":["localhost"],"query":[],"variable":[]}},"response":[],"_postman_id":"7c445c72-6a39-451f-9b1f-e7ba1588156b"},{"name":"외래키 설정 api","id":"8bda215d-8c78-42b5-a79c-351316aea30a","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\n\t\"name\" : \"test\",\n\t\"tableName\" : \"tableA\",\n\t\"baseColumn\" : \"id\",\n\t\"targetTable\" : \"tableB\",\n\t\"targetColumn\" : \"id2\"\n}\n\n","options":{"raw":{"language":"json"}}},"url":"http://localhost:8081/v1/table/set-foreign","urlObject":{"protocol":"http","port":"8081","path":["v1","table","set-foreign"],"host":["localhost"],"query":[],"variable":[]}},"response":[],"_postman_id":"8bda215d-8c78-42b5-a79c-351316aea30a"},{"name":"외래키 정보 받아오기 api","id":"0129bc4f-7783-4370-a594-4f45b79625c8","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\n\t\"name\" : \"test\",\n\t\"tableName\" : \"table2\"\n}\n\n","options":{"raw":{"language":"json"}}},"url":"http://localhost:8081/v1/table/get-foreign","urlObject":{"protocol":"http","port":"8081","path":["v1","table","get-foreign"],"host":["localhost"],"query":[],"variable":[]}},"response":[],"_postman_id":"0129bc4f-7783-4370-a594-4f45b79625c8"}]}