wangamy222 / TicketTopia

Yangju Cloud camp fimal project
0 stars 0 forks source link

[FE] AuroraDB 더미데이터 생성 스크립트 #30

Closed hyunji-o3o closed 2 months ago

hyunji-o3o commented 2 months ago

어떤 기능인가요?

AuroraDB 더미데이터 생성 스크립트

추가하려는 기능에 대해 간결하게 설명해주세요

  • AuroraDB 더미데이터 생성 스크립트

작업 상세 내용

참고할만한 자료(선택)

hyunji-o3o commented 2 months ago

insert into User(uid, password, name, birthday, phonenumber, state) values ('kimhj@gmail.com', 'pbkdf2_sha256$260000$54jyIgU57yJD7hVzS9q0mW$DXnzMBWL5/WRaWQcSubOPpjKK3vDCw3zt15MrFMgSt8=','김현지','1999-02-23','010-1214-5678','1'); insert into User(uid, password, name, birthday, phonenumber, state) values ('leehj@gmail.com', 'pbkdf2_sha256$260000$54jyIgU57yJD7hVzS9q0mW$DXnzMBWL5/WRaWQcSubOPpjKK3vDCw3zt15MrFMgSt8=','이현지','1998-07-01','010-9876-4321','1'); insert into User(uid, password, name, birthday, phonenumber, state) values ('wangjh@gmail.com', 'pbkdf2_sha256$260000$54jyIgU57yJD7hVzS9q0mW$DXnzMBWL5/WRaWQcSubOPpjKK3vDCw3zt15MrFMgSt8=','왕지호','1998-02-22','010-5678-9101','1'); insert into User(uid, password, name, birthday, phonenumber, state) values ('kimjs@gmail.com', 'pbkdf2_sha256$260000$54jyIgU57yJD7hVzS9q0mW$DXnzMBWL5/WRaWQcSubOPpjKK3vDCw3zt15MrFMgSt8=','김정수','1991-07-17','010-9878-1231','1'); insert into User(uid, password, name, birthday, phonenumber, state) values ('parkhb@gmail.com', 'pbkdf2_sha256$260000$54jyIgU57yJD7hVzS9q0mW$DXnzMBWL5/WRaWQcSubOPpjKK3vDCw3zt15MrFMgSt8=','박한비','2001-06-04','010-1425-7531','1'); insert into User(uid, password, name, birthday, phonenumber, state) values ('leesy@gmail.com', 'pbkdf2_sha256$260000$54jyIgU57yJD7hVzS9q0mW$DXnzMBWL5/WRaWQcSubOPpjKK3vDCw3zt15MrFMgSt8=','이서연','1997-11-30','010-2468-1357','1'); insert into User(uid, password, name, birthday, phonenumber, state) values ('chojh@gmail.com', 'pbkdf2_sha256$260000$54jyIgU57yJD7hVzS9q0mW$DXnzMBWL5/WRaWQcSubOPpjKK3vDCw3zt15MrFMgSt8=','조재현','1995-09-15','010-3698-7412','1'); insert into User(uid, password, name, birthday, phonenumber, state) values ('kimms@gmail.com', 'pbkdf2_sha256$260000$54jyIgU57yJD7hVzS9q0mW$DXnzMBWL5/WRaWQcSubOPpjKK3vDCw3zt15MrFMgSt8=','김민서','2000-03-21','010-9513-7531','1'); insert into User(uid, password, name, birthday, phonenumber, state) values ('parkjy@gmail.com', 'pbkdf2_sha256$260000$54jyIgU57yJD7hVzS9q0mW$DXnzMBWL5/WRaWQcSubOPpjKK3vDCw3zt15MrFMgSt8=','박지연','1993-12-05','010-7539-1597','1'); insert into User(uid, password, name, birthday, phonenumber, state) values ('choisj@gmail.com', 'pbkdf2_sha256$260000$54jyIgU57yJD7hVzS9q0mW$DXnzMBWL5/WRaWQcSubOPpjKK3vDCw3zt15MrFMgSt8=','최수진','1996-08-11','010-1597-3574','1'); insert into User(uid, password, name, birthday, phonenumber, state) values ('kimdk@gmail.com', 'pbkdf2_sha256$260000$54jyIgU57yJD7hVzS9q0mW$DXnzMBWL5/WRaWQcSubOPpjKK3vDCw3zt15MrFMgSt8=','김도경','1994-05-27','010-7412-8523','1'); insert into User(uid, password, name, birthday, phonenumber, state) values ('hanyh@gmail.com', 'pbkdf2_sha256$260000$54jyIgU57yJD7hVzS9q0mW$DXnzMBWL5/WRaWQcSubOPpjKK3vDCw3zt15MrFMgSt8=','한윤호','1992-01-18','010-3698-1472','1'); insert into User(uid, password, name, birthday, phonenumber, state) values ('leejj@gmail.com', 'pbkdf2_sha256$260000$54jyIgU57yJD7hVzS9q0mW$DXnzMBWL5/WRaWQcSubOPpjKK3vDCw3zt15MrFMgSt8=','이재준','1999-10-09','010-9632-8521','1'); insert into User(uid, password, name, birthday, phonenumber, state) values ('parksh@gmail.com', 'pbkdf2_sha256$260000$54jyIgU57yJD7hVzS9q0mW$DXnzMBWL5/WRaWQcSubOPpjKK3vDCw3zt15MrFMgSt8=','박성훈','1997-04-14','010-7896-3214','1'); insert into User(uid, password, name, birthday, phonenumber, state) values ('kangej@gmail.com', 'pbkdf2_sha256$260000$54jyIgU57yJD7hVzS9q0mW$DXnzMBWL5/WRaWQcSubOPpjKK3vDCw3zt15MrFMgSt8=','강은지','2002-07-22','010-4567-7890','1'); insert into User(uid, password, name, birthday, phonenumber, state) values ('jungmh@gmail.com', 'pbkdf2_sha256$260000$54jyIgU57yJD7hVzS9q0mW$DXnzMBWL5/WRaWQcSubOPpjKK3vDCw3zt15MrFMgSt8=','정민형','1990-12-31','010-1230-4567','1'); insert into User(uid, password, name, birthday, phonenumber, state) values ('kimys@gmail.com', 'pbkdf2_sha256$260000$54jyIgU57yJD7hVzS9q0mW$DXnzMBWL5/WRaWQcSubOPpjKK3vDCw3zt15MrFMgSt8=','김유신','1996-06-18','010-9876-5432','1'); insert into User(uid, password, name, birthday, phonenumber, state) values ('leejy@gmail.com', 'pbkdf2_sha256$260000$54jyIgU57yJD7hVzS9q0mW$DXnzMBWL5/WRaWQcSubOPpjKK3vDCw3zt15MrFMgSt8=','이지연','1998-09-03','010-3456-7890','1'); insert into User(uid, password, name, birthday, phonenumber, state) values ('kimch@gmail.com', 'pbkdf2_sha256$260000$54jyIgU57yJD7hVzS9q0mW$DXnzMBWL5/WRaWQcSubOPpjKK3vDCw3zt15MrFMgSt8=','김철호','1993-11-11','010-2345-6789','1'); insert into User(uid, password, name, birthday, phonenumber, state) values ('seojh@gmail.com', 'pbkdf2_sha256$260000$54jyIgU57yJD7hVzS9q0mW$DXnzMBWL5/WRaWQcSubOPpjKK3vDCw3zt15MrFMgSt8=','서지현','2000-02-29','010-8765-4321','1'); insert into User(uid, password, name, birthday, phonenumber, state) values ('choims@gmail.com', 'pbkdf2_sha256$260000$54jyIgU57yJD7hVzS9q0mW$DXnzMBWL5/WRaWQcSubOPpjKK3vDCw3zt15MrFMgSt8=','최민석','1995-08-07','010-5678-1214','1'); insert into User(uid, password, name, birthday, phonenumber, state) values ('leeej@gmail.com', 'pbkdf2_sha256$260000$54jyIgU57yJD7hVzS9q0mW$DXnzMBWL5/WRaWQcSubOPpjKK3vDCw3zt15MrFMgSt8=','이은정','1991-04-01','010-9012-3456','1'); insert into User(uid, password, name, birthday, phonenumber, state) values ('kangsh@gmail.com', 'pbkdf2_sha256$260000$54jyIgU57yJD7hVzS9q0mW$DXnzMBWL5/WRaWQcSubOPpjKK3vDCw3zt15MrFMgSt8=','강수현','1997-12-25','010-3456-7890','1'); insert into User(uid, password, name, birthday, phonenumber, state) values ('parkjy2@gmail.com', 'pbkdf2_sha256$260000$54jyIgU57yJD7hVzS9q0mW$DXnzMBWL5/WRaWQcSubOPpjKK3vDCw3zt15MrFMgSt8=','박준영','1994-03-15','010-7890-1134','1'); insert into User(uid, password, name, birthday, phonenumber, state) values ('kimhs@gmail.com', 'pbkdf2_sha256$260000$54jyIgU57yJD7hVzS9q0mW$DXnzMBWL5/WRaWQcSubOPpjKK3vDCw3zt15MrFMgSt8=','김현수','1999-07-07','010-2345-6789','1'); insert into User(uid, password, name, birthday, phonenumber, state) values ('leesj@gmail.com', 'pbkdf2_sha256$260000$54jyIgU57yJD7hVzS9q0mW$DXnzMBWL5/WRaWQcSubOPpjKK3vDCw3zt15MrFMgSt8=','이수진','1992-10-20','010-8901-2345','1'); insert into User(uid, password, name, birthday, phonenumber, state) values ('ahnjh@gmail.com', 'pbkdf2_sha256$260000$54jyIgU57yJD7hVzS9q0mW$DXnzMBWL5/WRaWQcSubOPpjKK3vDCw3zt15MrFMgSt8=','안재호','1996-01-30','010-4567-8901','1'); insert into User(uid, password, name, birthday, phonenumber, state) values ('kimyh@gmail.com', 'pbkdf2_sha256$260000$54jyIgU57yJD7hVzS9q0mW$DXnzMBWL5/WRaWQcSubOPpjKK3vDCw3zt15MrFMgSt8=','김영훈','1998-05-12','010-6789-0123','1'); insert into User(uid, password, name, birthday, phonenumber, state) values('choimj@gmail.com', 'pbkdf2_sha256$260000$54jyIgU57yJD7hVzS9q0mW$DXnzMBWL5/WRaWQcSubOPpjKK3vDCw3zt15MrFMgSt8=','최민주','1993-09-09','010-1231-5678','1'); insert into User(uid, password, name, birthday, phonenumber, state) values('leesh@gmail.com', 'pbkdf2_sha256$260000$54jyIgU57yJD7hVzS9q0mW$DXnzMBWL5/WRaWQcSubOPpjKK3vDCw3zt15MrFMgSt8=','이상현','2001-11-23','010-9012-3456','1'); insert into User(uid, password, name, birthday, phonenumber, state) values('kimjy@gmail.com', 'pbkdf2_sha256$260000$54jyIgU57yJD7hVzS9q0mW$DXnzMBWL5/WRaWQcSubOPpjKK3vDCw3zt15MrFMgSt8=','김지영','1995-02-14','010-5678-9012','1'); insert into User(uid, password, name, birthday, phonenumber, state) values('kimds@gmail.com', 'pbkdf2_sha256$260000$54jyIgU57yJD7hVzS9q0mW$DXnzMBWL5/WRaWQcSubOPpjKK3vDCw3zt15MrFMgSt8=','김동석','1990-06-06','010-3456-7890','1'); insert into User(uid, password, name, birthday, phonenumber, state) values('parkej@gmail.com', 'pbkdf2_sha256$260000$54jyIgU57yJD7hVzS9q0mW$DXnzMBWL5/WRaWQcSubOPpjKK3vDCw3zt15MrFMgSt8=','박은지','1997-08-18','010-7890-1134','1'); insert into User(uid, password, name, birthday, phonenumber, state) values('shinjh@gmail.com', 'pbkdf2_sha256$260000$54jyIgU57yJD7hVzS9q0mW$DXnzMBWL5/WRaWQcSubOPpjKK3vDCw3zt15MrFMgSt8=','신재현','1994-12-01','010-2345-6789','1'); insert into User(uid, password, name, birthday, phonenumber, state) values('kimsy@gmail.com', 'pbkdf2_sha256$260000$54jyIgU57yJD7hVzS9q0mW$DXnzMBWL5/WRaWQcSubOPpjKK3vDCw3zt15MrFMgSt8=','김서연','1999-03-27','010-8901-2345','1'); insert into User(uid, password, name, birthday, phonenumber, state) values('leemh@gmail.com', 'pbkdf2_sha256$260000$54jyIgU57yJD7hVzS9q0mW$DXnzMBWL5/WRaWQcSubOPpjKK3vDCw3zt15MrFMgSt8=','이민혁','1992-07-13','010-4567-8901','1'); insert into User(uid, password, name, birthday, phonenumber, state) values('choijs@gmail.com', 'pbkdf2_sha256$260000$54jyIgU57yJD7hVzS9q0mW$DXnzMBWL5/WRaWQcSubOPpjKK3vDCw3zt15MrFMgSt8=','최진서','1996-10-05','010-6789-0123','1'); insert into User(uid, password, name, birthday, phonenumber, state) values('parkhy@gmail.com', 'pbkdf2_sha256$260000$54jyIgU57yJD7hVzS9q0mW$DXnzMBWL5/WRaWQcSubOPpjKK3vDCw3zt15MrFMgSt8=','박효연','1998-01-19','010-1231-5678','1'); insert into User(uid, password, name, birthday, phonenumber, state) values('kimjh@gmail.com', 'pbkdf2_sha256$260000$54jyIgU57yJD7hVzS9q0mW$DXnzMBWL5/WRaWQcSubOPpjKK3vDCw3zt15MrFMgSt8=','김재현','1993-04-22','010-9012-3456','1'); insert into User(uid, password, name, birthday, phonenumber, state) values('leeej2@gmail.com', 'pbkdf2_sha256$260000$54jyIgU57yJD7hVzS9q0mW$DXnzMBWL5/WRaWQcSubOPpjKK3vDCw3zt15MrFMgSt8=','이은주','2000-09-08','010-5678-9012','1'); insert into User(uid, password, name, birthday, phonenumber, state) values('kangsh2@gmail.com', 'pbkdf2_sha256$260000$54jyIgU57yJD7hVzS9q0mW$DXnzMBWL5/WRaWQcSubOPpjKK3vDCw3zt15MrFMgSt8=','강성훈','1991-12-16','010-3456-7890','1'); insert into User(uid, password, name, birthday, phonenumber, state) values('kimms2@gmail.com', 'pbkdf2_sha256$260000$54jyIgU57yJD7hVzS9q0mW$DXnzMBWL5/WRaWQcSubOPpjKK3vDCw3zt15MrFMgSt8=','김민수','1997-05-29','010-7890-1214','1'); insert into User(uid, password, name, birthday, phonenumber, state) values('chojy@gmail.com', 'pbkdf2_sha256$260000$54jyIgU57yJD7hVzS9q0mW$DXnzMBWL5/WRaWQcSubOPpjKK3vDCw3zt15MrFMgSt8=','조지연','1995-02-02','010-2345-6789','1'); insert into User(uid, password, name, birthday, phonenumber, state) values('leesh2@gmail.com', 'pbkdf2_sha256$260000$54jyIgU57yJD7hVzS9q0mW$DXnzMBWL5/WRaWQcSubOPpjKK3vDCw3zt15MrFMgSt8=','이상호','1990-08-24','010-8901-2345','1'); insert into User(uid, password, name, birthday, phonenumber, state) values('kimej@gmail.com', 'pbkdf2_sha256$260000$54jyIgU57yJD7hVzS9q0mW$DXnzMBWL5/WRaWQcSubOPpjKK3vDCw3zt15MrFMgSt8=','김은지','1998-11-11','010-4567-8901','1'); insert into User(uid, password, name, birthday, phonenumber, state) values('parkjh@gmail.com', 'pbkdf2_sha256$260000$54jyIgU57yJD7hVzS9q0mW$DXnzMBWL5/WRaWQcSubOPpjKK3vDCw3zt15MrFMgSt8=','박재현','1994-06-30','010-6789-0123','1'); insert into User(uid, password, name, birthday, phonenumber, state) values('leesy2@gmail.com', 'pbkdf2_sha256$260000$54jyIgU57yJD7hVzS9q0mW$DXnzMBWL5/WRaWQcSubOPpjKK3vDCw3zt15MrFMgSt8=','이서영','1999-01-15','010-1134-5678','1'); insert into User(uid, password, name, birthday, phonenumber, state) values('kimmh@gmail.com', 'pbkdf2_sha256$260000$54jyIgU57yJD7hVzS9q0mW$DXnzMBWL5/WRaWQcSubOPpjKK3vDCw3zt15MrFMgSt8=','김민호','1992-03-28','010-9012-3456','1'); insert into User(uid, password, name, birthday, phonenumber, state) values('choijs2@gmail.com', 'pbkdf2_sha256$260000$54jyIgU57yJD7hVzS9q0mW$DXnzMBWL5/WRaWQcSubOPpjKK3vDCw3zt15MrFMgSt8=','최지선','1996-07-09','010-5678-9012','1'); insert into User(uid, password, name, birthday, phonenumber, state) values('leehy@gmail.com', 'pbkdf2_sha256$260000$54jyIgU57yJD7hVzS9q0mW$DXnzMBWL5/WRaWQcSubOPpjKK3vDCw3zt15MrFMgSt8=','이현영','1993-10-21','010-3456-7890','1'); insert into User(uid, password, name, birthday, phonenumber, state) values('seojh2@gmail.com', 'pbkdf2_sha256$260000$54jyIgU57yJD7hVzS9q0mW$DXnzMBWL5/WRaWQcSubOPpjKK3vDCw3zt15MrFMgSt8=','서재훈','2001-02-14','010-7890-1134','1'); insert into User(uid, password, name, birthday, phonenumber, state) values('parkej2@gmail.com', 'pbkdf2_sha256$260000$54jyIgU57yJD7hVzS9q0mW$DXnzMBWL5/WRaWQcSubOPpjKK3vDCw3zt15MrFMgSt8=','박은정','1995-05-07','010-2345-6789','1'); insert into User(uid, password, name, birthday, phonenumber, state) values('kimms3@gmail.com', 'pbkdf2_sha256$260000$54jyIgU57yJD7hVzS9q0mW$DXnzMBWL5/WRaWQcSubOPpjKK3vDCw3zt15MrFMgSt8=','김민서','1991-09-19','010-8901-2345','1'); insert into User(uid, password, name, birthday, phonenumber, state) values('kimsh@gmail.com', 'pbkdf2_sha256$260000$54jyIgU57yJD7hVzS9q0mW$DXnzMBWL5/WRaWQcSubOPpjKK3vDCw3zt15MrFMgSt8=','김성현','1997-12-03','010-4567-8901','1'); insert into User(uid, password, name, birthday, phonenumber, state) values('leejy2@gmail.com', 'pbkdf2_sha256$260000$54jyIgU57yJD7hVzS9q0mW$DXnzMBWL5/WRaWQcSubOPpjKK3vDCw3zt15MrFMgSt8=','이지영','1994-04-16','010-6789-0123','1'); insert into User(uid, password, name, birthday, phonenumber, state) values('parkdk@gmail.com', 'pbkdf2_sha256$260000$54jyIgU57yJD7hVzS9q0mW$DXnzMBWL5/WRaWQcSubOPpjKK3vDCw3zt15MrFMgSt8=','박도경','1998-08-28','010-1214-5678','1'); insert into User(uid, password, name, birthday, phonenumber, state) values('kimyh2@gmail.com', 'pbkdf2_sha256$260000$54jyIgU57yJD7hVzS9q0mW$DXnzMBWL5/WRaWQcSubOPpjKK3vDCw3zt15MrFMgSt8=','김윤호','1992-11-10','010-9012-3456','1'); insert into User(uid, password, name, birthday, phonenumber, state) values('leemj@gmail.com', 'pbkdf2_sha256$260000$54jyIgU57yJD7hVzS9q0mW$DXnzMBWL5/WRaWQcSubOPpjKK3vDCw3zt15MrFMgSt8=','이민재','1996-01-23','010-5678-9012','1'); insert into User(uid, password, name, birthday, phonenumber, state) values('choish@gmail.com', 'pbkdf2_sha256$260000$54jyIgU57yJD7hVzS9q0mW$DXnzMBWL5/WRaWQcSubOPpjKK3vDCw3zt15MrFMgSt8=','최서현','1993-06-05','010-3456-7890','1'); insert into User(uid, password, name, birthday, phonenumber, state) values('kangej2@gmail.com', 'pbkdf2_sha256$260000$54jyIgU57yJD7hVzS9q0mW$DXnzMBWL5/WRaWQcSubOPpjKK3vDCw3zt15MrFMgSt8=','강은주','1999-09-17','010-7890-1214','1'); insert into User(uid, password, name, birthday, phonenumber, state) values('kimjh2@gmail.com', 'pbkdf2_sha256$260000$54jyIgU57yJD7hVzS9q0mW$DXnzMBWL5/WRaWQcSubOPpjKK3vDCw3zt15MrFMgSt8=','김재호','1990-12-30','010-2345-6789','1'); insert into User(uid, password, name, birthday, phonenumber, state) values('parksy@gmail.com', 'pbkdf2_sha256$260000$54jyIgU57yJD7hVzS9q0mW$DXnzMBWL5/WRaWQcSubOPpjKK3vDCw3zt15MrFMgSt8=','박서연','1997-03-13','010-8901-2345','1'); insert into User(uid, password, name, birthday, phonenumber, state) values('leemh2@gmail.com', 'pbkdf2_sha256$260000$54jyIgU57yJD7hVzS9q0mW$DXnzMBWL5/WRaWQcSubOPpjKK3vDCw3zt15MrFMgSt8=','이민형','1995-07-26','010-4567-8901','1'); insert into User(uid, password, name, birthday, phonenumber, state) values('choijs3@gmail.com', 'pbkdf2_sha256$260000$54jyIgU57yJD7hVzS9q0mW$DXnzMBWL5/WRaWQcSubOPpjKK3vDCw3zt15MrFMgSt8=','최진수','1991-10-08','010-6789-0123','1'); insert into User(uid, password, name, birthday, phonenumber, state) values('seohy@gmail.com', 'pbkdf2_sha256$260000$54jyIgU57yJD7hVzS9q0mW$DXnzMBWL5/WRaWQcSubOPpjKK3vDCw3zt15MrFMgSt8=','서현영','1998-02-20','010-1214-5678','1'); insert into User(uid, password, name, birthday, phonenumber, state) values('kimej2@gmail.com', 'pbkdf2_sha256$260000$54jyIgU57yJD7hVzS9q0mW$DXnzMBWL5/WRaWQcSubOPpjKK3vDCw3zt15MrFMgSt8=','김은정','1994-05-03','010-9012-3456','1'); insert into User(uid, password, name, birthday, phonenumber, state) values('kangsh3@gmail.com', 'pbkdf2_sha256$260000$54jyIgU57yJD7hVzS9q0mW$DXnzMBWL5/WRaWQcSubOPpjKK3vDCw3zt15MrFMgSt8=','강성호','2000-08-15','010-5678-9012','1'); insert into User(uid, password, name, birthday, phonenumber, state) values('leems@gmail.com', 'pbkdf2_sha256$260000$54jyIgU57yJD7hVzS9q0mW$DXnzMBWL5/WRaWQcSubOPpjKK3vDCw3zt15MrFMgSt8=','이민서','1992-11-27','010-3456-7890','1'); insert into User(uid, password, name, birthday, phonenumber, state) values('parkjy3@gmail.com', 'pbkdf2_sha256$260000$54jyIgU57yJD7hVzS9q0mW$DXnzMBWL5/WRaWQcSubOPpjKK3vDCw3zt15MrFMgSt8=','박지영','1996-03-09','010-7890-1134','1'); insert into User(uid, password, name, birthday, phonenumber, state) values('kimsh2@gmail.com', 'pbkdf2_sha256$260000$54jyIgU57yJD7hVzS9q0mW$DXnzMBWL5/WRaWQcSubOPpjKK3vDCw3zt15MrFMgSt8=','김상현','1993-06-21','010-2345-6789','1'); insert into User(uid, password, name, birthday, phonenumber, state) values('leeej3@gmail.com', 'pbkdf2_sha256$260000$54jyIgU57yJD7hVzS9q0mW$DXnzMBWL5/WRaWQcSubOPpjKK3vDCw3zt15MrFMgSt8=','이은지','1999-09-03','010-8901-2345','1');

insert into Ticket(tid, name, date, price, qty, state) values ('TS-07272024', '테일러스위프트 내한 공연', '2024-08-07', '1000000', '30000', '1'); insert into Ticket(tid, name, date, price, qty, state) values ('IU-07262024', '아이유 팬 미팅', '2024-08-08', '300000', '20000', '0');

insert into Payment(pid, tid, uid, state) values ('ET-01', 'TS-07272024', 'kimhj@gmail.com', '1'); insert into Payment(pid, tid, uid, state) values ('ET-02', 'TS-07272024', 'kimjh@gmail.com', '1'); insert into Payment(pid, tid, uid, state) values ('ET-03', 'TS-07272024', 'leems@gmail.com', '1'); insert into Payment(pid, tid, uid, state) values ('ET-04', 'TS-07272024', 'parkjy3@gmail.com', '1'); insert into Payment(pid, tid, uid, state) values ('ET-05', 'TS-07272024', 'parkjh@gmail.com', '1'); insert into Payment(pid, tid, uid, state) values ('ET-06', 'TS-07272024', 'leejy@gmail.com', '1'); insert into Payment(pid, tid, uid, state) values ('ET-07', 'TS-07272024', 'kangsh@gmail.com', '1'); insert into Payment(pid, tid, uid, state) values ('ET-08', 'TS-07272024', 'kimhs@gmail.com', '1'); insert into Payment(pid, tid, uid, state) values ('ET-09', 'TS-07272024', 'parkhy@gmail.com', '1'); insert into Payment(pid, tid, uid, state) values ('ET-10', 'TS-07272024', 'ahnjh@gmail.com', '1'); insert into Payment(pid, tid, uid, state) values ('ET-11', 'TS-07272024', 'kangsh3@gmail.com', '1'); insert into Payment(pid, tid, uid, state) values ('ET-12', 'TS-07272024', 'parkhb@gmail.com', '1'); insert into Payment(pid, tid, uid, state) values ('ET-13', 'TS-07272024', 'parkjy2@gmail.com', '1'); insert into Payment(pid, tid, uid, state) values ('ET-14', 'TS-07272024', 'kimms2@gmail.com', '1'); insert into Payment(pid, tid, uid, state) values ('ET-15', 'TS-07272024', 'choijs@gmail.com', '1'); insert into Payment(pid, tid, uid, state) values ('ET-16', 'TS-07272024', 'kimyh@gmail.com', '1');

insert into Reservation(tid, totalqty, availableqty) values ('TS-07272024', '30000', '29984');