TtocAppservice
Tables (6)
Reservation
- Reservation_Index — Int — Primary key — NOT NULL — 00001
- CreaterNumber (UserNumber) — Int — Foreign key → User.UserNumber — NOT NULL — 00254
- Service_Name — String — NOT NULL — 산전, 산후 바디관리
- Service_Counts (Service_Count) — Int — NOT NULL — 6
- PartnerID — String — [email protected]
- CreatedAt (Last_Name) — Date — NOT NULL — 2021-06-17 PM 13:01:06 Seoul
ShopProducts
- Product_Index — Primary key — NOT NULL — 00001
- Product_Name — Primary key — NOT NULL — 닥터 오투스 전해수 살균 세정제
- Product_Price — Int — NOT NULL — 47,000
- Product_Detail_Info — String — 상품 상세 정보들 (Json으로 저장해야할 것 같은데)
- Product_Status — Int — NOT NULL — 0: 숨김, 1: 판매중, 2: 품절, 3: 구매불가능
- Product_Pointable — Int — NOT NULL — 0: 포인트 사용 불가능, 자연수: 금액만큼 사용 가능
User (user)
- UserNumber (Index) — Int — Primary key — NOT NULL — 00254
- UserID — String — Primary key — NOT NULL — [email protected]
- CreatedAt — Date — NOT NULL — 2021-06-14 PM 18:00:00 Seoul
- First_Name — String — NOT NULL — 구
- Last_Name — String — NOT NULL — 민정
- Phone — Int — NOT NULL — 1056959919
- Juso — String — 경기도 성남시 분당구 분당동 128-3
- Joso_sub — String — 1층 103호
- Birthday — Date — 1999-12-21
UserCart (CopyOfShopProducts)
- UserNumber (Index2) — Int — Foreign key → User.UserNumber — NOT NULL — 00254
- UserID — String — Foreign key → User.UserID — NOT NULL — [email protected]
- Add_Products — Array — 추가한 상품들의 인덱스 배열
UserSurvey
- Survey_Index (Key) — Primary key — NOT NULL — 00001
- Reservation_Index (Reservation_Index2) — Int — Foreign key → Reservation.Reservation_Index — NOT NULL — 00001
- Reservation_Index — Int — NOT NULL — 00001
- Questions_List — Array — NOT NULL — ['질문1','질문2']
- Answers_List — Array — NOT NULL — ['답변1','']
User_Order_History
- Order_Index (Key) — Int — Primary key — NOT NULL
- UserID — String — Foreign key → User.UserID — NOT NULL — [email protected]
- UserNumber (Index2) — Int — Foreign key → User.UserNumber — NOT NULL — 00254
- Product_Index — Foreign key → ShopProducts.Product_Index — NOT NULL — 00001
- Product_Name — Foreign key → ShopProducts.Product_Name — NOT NULL — 닥터 오투스 전해수 살균 세정제
- PaymentMethod (Field) — String — NOT NULL
- Payment_Status (Field2) — Int — NOT NULL — 정상, 실패, 대기중
- Order_Status (Field3) — String — NOT NULL — 입금전, 배송전, 배송중, 배송완료
- Transport_Number (Field4) — Int