[토이 프로젝트] 카테고리 테이블 DDL

SELECT * FROM tabs;
-- 모집 포지션 카테고리 T
SELECT * FROM position_category_table;
INSERT INTO position_category_table VALUES(position_category_seq.nextval, '프론트엔드');
INSERT INTO position_category_table VALUES(position_category_seq.nextval, '백엔드');

-- 기술스택 카테고리 T
SELECT * FROM TECH_CATEGORY_TABLE;
INSERT INTO TECH_CATEGORY_TABLE VALUES(tech_category_seq.nextval, 'Java');
INSERT INTO TECH_CATEGORY_TABLE VALUES(tech_category_seq.nextval, 'Spring');
INSERT INTO TECH_CATEGORY_TABLE VALUES(tech_category_seq.nextval, 'Spring Boot');
INSERT INTO TECH_CATEGORY_TABLE VALUES(tech_category_seq.nextval, 'C');
INSERT INTO TECH_CATEGORY_TABLE VALUES(tech_category_seq.nextval, 'Python');
INSERT INTO TECH_CATEGORY_TABLE VALUES(tech_category_seq.nextval, 'React');
INSERT INTO TECH_CATEGORY_TABLE VALUES(tech_category_seq.nextval, 'Vue');
INSERT INTO TECH_CATEGORY_TABLE VALUES(tech_category_seq.nextval, 'NodeJS');
INSERT INTO TECH_CATEGORY_TABLE VALUES(tech_category_seq.nextval, 'Swift');
INSERT INTO TECH_CATEGORY_TABLE VALUES(tech_category_seq.nextval, 'Kotlin');
INSERT INTO TECH_CATEGORY_TABLE VALUES(tech_category_seq.nextval, 'Git');
INSERT INTO TECH_CATEGORY_TABLE VALUES(tech_category_seq.nextval, 'AWS');
INSERT INTO TECH_CATEGORY_TABLE VALUES(tech_category_seq.nextval, 'Flutter');
INSERT INTO TECH_CATEGORY_TABLE VALUES(tech_category_seq.nextval, 'Docker');
INSERT INTO TECH_CATEGORY_TABLE VALUES(tech_category_seq.nextval, 'JavaScript');
INSERT INTO TECH_CATEGORY_TABLE VALUES(tech_category_seq.nextval, 'TypeScript');
INSERT INTO TECH_CATEGORY_TABLE VALUES(tech_category_seq.nextval, 'Django');
INSERT INTO TECH_CATEGORY_TABLE VALUES(tech_category_seq.nextval, 'PHP');

-- 프로젝트/스터디 카테고리 T
SELECT * FROM PROJECT_STUDY_CATEGORY_TABLE;
INSERT INTO PROJECT_STUDY_CATEGORY_TABLE VALUES(project_study_category_seq.nextval, '프로젝트');
INSERT INTO PROJECT_STUDY_CATEGORY_TABLE VALUES(project_study_category_seq.nextval, '스터디');

-- 프로젝트 진행기간 카테고리 T
SELECT * FROM PERIOD_CATEGORY_TABLE;
INSERT INTO PERIOD_CATEGORY_TABLE VALUES(period_category_seq.nextval, '기간 미정');
INSERT INTO PERIOD_CATEGORY_TABLE VALUES(period_category_seq.nextval, '1개월');
INSERT INTO PERIOD_CATEGORY_TABLE VALUES(period_category_seq.nextval, '2개월');
INSERT INTO PERIOD_CATEGORY_TABLE VALUES(period_category_seq.nextval, '3개월');
INSERT INTO PERIOD_CATEGORY_TABLE VALUES(period_category_seq.nextval, '4개월');
INSERT INTO PERIOD_CATEGORY_TABLE VALUES(period_category_seq.nextval, '5개월');
INSERT INTO PERIOD_CATEGORY_TABLE VALUES(period_category_seq.nextval, '6개월');
INSERT INTO PERIOD_CATEGORY_TABLE VALUES(period_category_seq.nextval, '장기');

COMMIT;