개인사

테이블 정보1. SKILLCODESNAMETYPEUNIQUENULLABLENAMEVARCHAR(N)YNCATEGORYVARCHAR(N)NNCODEINTEGERYN  2. DEVELOPERSNAMETYPEUNIQUENULLABLEIDVARCHAR(N)YNFIRST_NAMEVARCHAR(N)NYLAST_NAMEVARCHAR(N)NYEMAILVARCHAR(N)YNSKILL_CODEINTEGERNN  예시 테이블1. SKILLCODESNAMECATEGORYCODEC++Back End4JavaScriptFront End16JavaBack End128PythonBack End256C#Back End1024ReactFront End2048VueFront End8192Node.jsBack End16384  2. DEV..

테이블 정보1. MEMBER_PROFILEColumn nameTypeNullableMEMBER_IDVARCHAR(100)FALSEMEMBER_NAMEVARCHAR(50)FALSETLNOVARCHAR(50)TRUEGENDERVARCHAR(1)TRUEDATE_OF_BIRTHDATETRUE  2. REST_REVIEW Column nameTypeNullableREVIEW_IDVARCHAR(10)FALSEREST_IDVARCHAR(10)TRUEMEMBER_IDVARCHAR(100)TRUEREVIEW_SCORENUMBERTRUEREVIEW_TEXTVARCHAR(1000)TRUEREVIEW_DATEDATETRUE  예시 테이블1. MEMBER_PROFILEMEMBER_IDMEMBER_NAMETLNOGENDERDAT..

테이블 정보1. BOOK Column nameTypeNullableDescriptionBOOK_IDINTEGERFALSE도서 IDCATEGORYVARCHAR(N)FALSE카테고리 (경제, 인문, 소설, 생활, 기술)AUTHOR_IDINTEGERFALSE저자 IDPRICEINTEGERFALSE판매가 (원)PUBLISHED_DATEDATEFALSE출판일  2. BOOK_SALES Column nameTypeNullableDescriptionBOOK_IDINTEGERFALSE도서 IDSALES_DATEDATEFALSE판매일SALESINTEGERFALSE판매량   예시 테이블1. BOOK BOOK_IDCATEGORYAUTHOR_IDPRICEPUBLISHED_DATE1인문1100002020-01-012경제1900..

테이블 정보1. FIRST_HALF NAMETYPENULLABLESHIPMENT_IDINT(N)FALSEFLAVORVARCHAR(N)FALSETOTAL_ORDERINT(N)FALSE 2. JULY NAMETYPENULLABLESHIPMENT_IDINT(N)FALSEFLAVORVARCHAR(N)FALSETOTAL_ORDERINT(N)FALSE 예시 테이블1. FIRST_HALF SHIPMENT_IDFLAVORTOTAL_ORDER101chocolate3200102vanilla2800103mint_chocolate1700104caramel2600105white_chocolate3100106peach2450107watermelon2150108mango2900109strawberry3100110melon31501..

테이블 정보1. FOOD_PRODUCT Column nameTypeNullablePRODUCT_IDVARCHAR(10)FALSEPRODUCT_NAMEVARCHAR(50)FALSEPRODUCT_CDVARCHAR(10)TRUECATEGORYVARCHAR(10)TRUEPRICENUMBERTRUE  2. FOOD_ORDER Column nameTypeNullableORDER_IDVARCHAR(10)FALSEPRODUCT_IDVARCHAR(5)FALSEAMOUNTNUMBERFALSEPRODUCE_DATEDATETRUEIN_DATEDATETRUEOUT_DATEDATETRUEFACTORY_IDVARCHAR(10)FALSEWAREHOUSE_IDVARCHAR(10)FALSE 예시 테이블1. FOOD_PRODUCT PRO..

테이블 정보1. ANIMAL_INSNAMETYPENULLABLEANIMAL_IDVARCHAR(N)FALSEANIMAL_TYPEVARCHAR(N)FALSEDATETIMEDATETIMEFALSEINTAKE_CONDITIONVARCHAR(N)FALSENAMEVARCHAR(N)TRUESEX_UPON_INTAKEVARCHAR(N)FALSE 2. ANIMAL_OUTSNAMETYPENULLABLEANIMAL_IDVARCHAR(N)FALSEANIMAL_TYPEVARCHAR(N)FALSEDATETIMEDATETIMEFALSENAMEVARCHAR(N)TRUESEX_UPON_OUTCOMEVARCHAR(N)FALSE  예시 테이블1. ANIMAL_INSANIMAL_IDANIMAL_TYPEDATETIMEINTAKE_CONDIT..

테이블 정보1. PRODUCTColumn nameTypeNullablePRODUCT_IDINTEGERFALSEPRODUCT_CODEVARCHAR(8)FALSEPRICEINTEGERFALSE  2. OFFLINE_SALEColumn nameTypeNullableOFFLINE_SALE_IDINTEGERFALSEPRODUCT_IDINTEGERFALSESALES_AMOUNTINTEGERFALSESALES_DATEDATEFALSE  예시 테이블1. PRODUCTPRODUCT_IDPRODUCT_CODEPRICE1A1000011150002A100004580003C300000242000  2. OFFLINE_SALEOFFLINE_SALE_IDPRODUCT_IDSALES_AMOUNTSALES_DATE1122022-02-..

테이블 정보1. ANIMAL_INS NAMETYPENULLABLEANIMAL_IDVARCHAR(N)FALSEANIMAL_TYPEVARCHAR(N)FALSEDATETIMEDATETIMEFALSEINTAKE_CONDITIONVARCHAR(N)FALSENAMEVARCHAR(N)TRUESEX_UPON_INTAKEVARCHAR(N)FALSE 2. ANIMAL_OUTS NAMETYPENULLABLEANIMAL_IDVARCHAR(N)FALSEANIMAL_TYPEVARCHAR(N)FALSEDATETIMEDATETIMEFALSENAMEVARCHAR(N)TRUESEX_UPON_OUTCOMEVARCHAR(N)FALSE  예시 테이블1. ANIMAL_INS ANIMAL_IDANIMAL_TYPEDATETIMEINTAKE_CON..

테이블 정보1. ANIMAL_INS NAMETYPENULLABLEANIMAL_IDVARCHAR(N)FALSEANIMAL_TYPEVARCHAR(N)FALSEDATETIMEDATETIMEFALSEINTAKE_CONDITIONVARCHAR(N)FALSENAMEVARCHAR(N)TRUESEX_UPON_INTAKEVARCHAR(N)FALSE 2.ANIMAL_OUTS NAMETYPENULLABLEANIMAL_IDVARCHAR(N)FALSEANIMAL_TYPEVARCHAR(N)FALSEDATETIMEDATETIMEFALSENAMEVARCHAR(N)TRUESEX_UPON_OUTCOMEVARCHAR(N)FALSE 예시 테이블1. ANIMAL_INS ANIMAL_IDANIMAL_TYPEDATETIMEINTAKE_CONDI..

테이블 정보1. ANIMAL_INS NAMETYPENULLABLEANIMAL_IDVARCHAR(N)FALSEANIMAL_TYPEVARCHAR(N)FALSEDATETIMEDATETIMEFALSEINTAKE_CONDITIONVARCHAR(N)FALSENAMEVARCHAR(N)TRUESEX_UPON_INTAKEVARCHAR(N)FALSE  2. ANIMAL_OUTS NAMETYPENULLABLEANIMAL_IDVARCHAR(N)FALSEANIMAL_TYPEVARCHAR(N)FALSEDATETIMEDATETIMEFALSENAMEVARCHAR(N)TRUESEX_UPON_OUTCOMEVARCHAR(N)FALSE  예시 테이블1. ANIMAL_INS ANIMAL_IDANIMAL_TYPEDATETIMEINTAKE_CO..