GroceryMarket
Tables (8)
Orders (주문테이블)
- orderId (고유아이디) — Bigint — Primary key — NOT NULL
- userId (고유 외래키) — Bigint — Foreign key → Users.userId — NOT NULL
- userId (외래키) — Bigint
- orderDate (주문일시) — TIMESTAMP
- totalAmount (총결제금액) — DECIMAL
- shippingAddress (배송될주소) — varchar
- orderStatus (배송상태)
- paymentMethod (결제방법) — VARCHAR
- paymentStatus (결제상태) — BOOLEAN
- updatedAt (주문정보업데이트) — VARCHAR
Users (유저 테이블)
- userId (고유아이디) — Bigint — Primary key — NOT NULL
- username (사용자 이름) — varchar
- password (비밀번호) — varchar
- email (이메일) — varchar
- phoneNumber (전화번호) — VARCHAR
- address (주소) — VARCHAR
- userType (역할) — customer/admin
- createdAt (생성일자) — TIMESTAMP
- updatedAt (수정일자) — TIMESTAMP
fdsaf (dd테이블)
- Key — Primary key — NOT NULL