sampleData.sql

INSERT INTO CATEGORY (NAME) VALUES ('FOOD');
INSERT INTO CATEGORY (NAME) VALUES ('ELECTRONICS');
INSERT INTO CATEGORY (NAME) VALUES ('CLOTHES');
INSERT INTO CATEGORY (NAME) VALUES ('BOOK');
INSERT INTO CATEGORY (NAME) VALUES ('TOY');
INSERT INTO CATEGORY (NAME) VALUES ('FURNITURE');
INSERT INTO CATEGORY (NAME) VALUES ('SPORTS');
INSERT INTO CATEGORY (NAME) VALUES ('BEAUTY');
INSERT INTO CATEGORY (NAME) VALUES ('OFFICE');
INSERT INTO CATEGORY (NAME) VALUES ('PET');

INSERT INTO MANAGER (ID, NAME, GRADE) VALUES
    ('346c218f-59e6-4bd1-83ea-a941f8e98dbe', '관리자1', 'A');
INSERT INTO MANAGER (ID, NAME, GRADE) VALUES
    ('6529547b-2491-4044-b5c6-7e7ce17f22bb', '관리자2', 'A');
INSERT INTO MANAGER (ID, NAME, GRADE) VALUES
    ('b9151834-5c2f-4f20-ad05-60a05a7ee80a', '관리자3', 'B');
INSERT INTO MANAGER (ID, NAME, GRADE) VALUES
    ('e4fba9f2-e07f-4c2d-8bb5-0008d5f0bdd7', '관리자4', 'B');
INSERT INTO MANAGER (ID, NAME, GRADE) VALUES
    ('8ee1a802-fc7e-49c6-b2c4-25407efbc802', '관리자5', 'B');
INSERT INTO MANAGER (ID, NAME, GRADE) VALUES
    ('e55ebc4f-3d8a-488d-b440-d95c82c1c3b1', '관리자6', 'C');
INSERT INTO MANAGER (ID, NAME, GRADE) VALUES
    ('dd1f971d-19e3-4de7-bb47-568b3c15f5da', '관리자7', 'C');
INSERT INTO MANAGER (ID, NAME, GRADE) VALUES
    ('e3f68678-9d03-444d-b729-915e84905ddd', '관리자8', 'C');
INSERT INTO MANAGER (ID, NAME, GRADE) VALUES
    ('5a97025f-19b2-4037-97a3-2322ae5fa3c1', '관리자9', 'S');
INSERT INTO MANAGER (ID, NAME, GRADE) VALUES
    ('becbc40e-60ae-4359-9119-0e810c080062', '관리자10', 'S');

INSERT INTO ITEM (ID, NAME, CATEGORY_ID, QUANTITY) VALUES
    ('cf0b446a-4352-4413-927c-b6a4bb50af8c', '사과 박스',      'FOOD',        100);
INSERT INTO ITEM (ID, NAME, CATEGORY_ID, QUANTITY) VALUES
    ('2ef6760f-abe4-456d-9d10-a0db89b1475a', '블루투스 이어폰', 'ELECTRONICS', 50);
INSERT INTO ITEM (ID, NAME, CATEGORY_ID, QUANTITY) VALUES
    ('68abd24e-4add-4aa4-a8c4-ef82fd28e73c', '후드티',          'CLOTHES',     80);
INSERT INTO ITEM (ID, NAME, CATEGORY_ID, QUANTITY) VALUES
    ('52083140-0aef-4cab-bb90-fb82f9771886', '자바의 정석',      'BOOK',        40);
INSERT INTO ITEM (ID, NAME, CATEGORY_ID, QUANTITY) VALUES
    ('fcd886b7-dfd4-49a1-ad8d-62c2d1dfe117', '레고 블록',        'TOY',         60);
INSERT INTO ITEM (ID, NAME, CATEGORY_ID, QUANTITY) VALUES
    ('3923f2fa-9467-4211-8b2d-95faea4f4d24', '책상',            'FURNITURE',   15);
INSERT INTO ITEM (ID, NAME, CATEGORY_ID, QUANTITY) VALUES
    ('511f8ca6-272d-4deb-8074-c4956952f792', '축구공',          'SPORTS',      25);
INSERT INTO ITEM (ID, NAME, CATEGORY_ID, QUANTITY) VALUES
    ('9587cb95-ad44-4756-85d7-8d337b4bda91', '스킨로션',        'BEAUTY',      70);
INSERT INTO ITEM (ID, NAME, CATEGORY_ID, QUANTITY) VALUES
    ('dda7a966-0231-489d-97ce-5ee21c34bccc', '볼펜 세트',        'OFFICE',      120);
INSERT INTO ITEM (ID, NAME, CATEGORY_ID, QUANTITY) VALUES
    ('c02b87ec-2a2c-4da7-9f3e-682ee468b8f9', '강아지 사료',      'PET',         90);

INSERT INTO IO_DETAIL (ID, IN_OUT, QUANTITY, MANAGER_ID, ITEM_ID, IO_DATE) VALUES
    ('6f7ab1d9-7ed1-4473-9dc0-a0c6580eabf4', 'IN',  50,
     '346c218f-59e6-4bd1-83ea-a941f8e98dbe',
     'cf0b446a-4352-4413-927c-b6a4bb50af8c',
     '2025-12-01');

INSERT INTO IO_DETAIL (ID, IN_OUT, QUANTITY, MANAGER_ID, ITEM_ID, IO_DATE) VALUES
    ('46922624-d376-4aca-bb3f-8cced8795156', 'OUT', 10,
     '6529547b-2491-4044-b5c6-7e7ce17f22bb',
     '2ef6760f-abe4-456d-9d10-a0db89b1475a',
     '2025-12-02');

INSERT INTO IO_DETAIL (ID, IN_OUT, QUANTITY, MANAGER_ID, ITEM_ID, IO_DATE) VALUES
    ('a93111e4-bf6f-4d56-b6d2-1bac8f4705f9', 'IN',  30,
     'b9151834-5c2f-4f20-ad05-60a05a7ee80a',
     '68abd24e-4add-4aa4-a8c4-ef82fd28e73c',
     '2025-12-03');

INSERT INTO IO_DETAIL (ID, IN_OUT, QUANTITY, MANAGER_ID, ITEM_ID, IO_DATE) VALUES
    ('e9d30ebe-be86-43c7-9f72-a59ea3140de5', 'OUT', 5,
     'e4fba9f2-e07f-4c2d-8bb5-0008d5f0bdd7',
     '52083140-0aef-4cab-bb90-fb82f9771886',
     '2025-12-04');

INSERT INTO IO_DETAIL (ID, IN_OUT, QUANTITY, MANAGER_ID, ITEM_ID, IO_DATE) VALUES
    ('5bdd9318-8082-4a0a-8a8f-50b47923370e', 'IN',  20,
     '8ee1a802-fc7e-49c6-b2c4-25407efbc802',
     'fcd886b7-dfd4-49a1-ad8d-62c2d1dfe117',
     '2025-12-05');

INSERT INTO IO_DETAIL (ID, IN_OUT, QUANTITY, MANAGER_ID, ITEM_ID, IO_DATE) VALUES
    ('2cf73ae7-5445-49f9-9f52-7577ef58f21c', 'OUT', 3,
     'e55ebc4f-3d8a-488d-b440-d95c82c1c3b1',
     '3923f2fa-9467-4211-8b2d-95faea4f4d24',
     '2025-12-06');

INSERT INTO IO_DETAIL (ID, IN_OUT, QUANTITY, MANAGER_ID, ITEM_ID, IO_DATE) VALUES
    ('2ac37617-84d0-4b2d-a610-471e27d631a1', 'IN',  15,
     'dd1f971d-19e3-4de7-bb47-568b3c15f5da',
     '511f8ca6-272d-4deb-8074-c4956952f792',
     '2025-12-07');

INSERT INTO IO_DETAIL (ID, IN_OUT, QUANTITY, MANAGER_ID, ITEM_ID, IO_DATE) VALUES
    ('c1d45009-7264-435d-a1e4-86a3c8d05c18', 'OUT', 7,
     'e3f68678-9d03-444d-b729-915e84905ddd',
     '9587cb95-ad44-4756-85d7-8d337b4bda91',
     '2025-12-08');

INSERT INTO IO_DETAIL (ID, IN_OUT, QUANTITY, MANAGER_ID, ITEM_ID, IO_DATE) VALUES
    ('569f1056-239f-4b8f-bad5-cd51db662a55', 'IN',  40,
     '5a97025f-19b2-4037-97a3-2322ae5fa3c1',
     'dda7a966-0231-489d-97ce-5ee21c34bccc',
     '2025-12-09');

INSERT INTO IO_DETAIL (ID, IN_OUT, QUANTITY, MANAGER_ID, ITEM_ID, IO_DATE) VALUES
    ('e5bdbf7f-bdf0-4b47-8633-d4e723e8c78c', 'OUT', 8,
     'becbc40e-60ae-4359-9119-0e810c080062',
     'c02b87ec-2a2c-4da7-9f3e-682ee468b8f9',
     '2025-12-10');

COMMIT;