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

Untitled

    Untitled2

      Untitled4

        Untitled5

          Untitled6

            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