doit-shop
Tables (5)
Account (Untitled2)
- accountId (Key) — Long — Primary key — NOT NULL
- accountName (Field) — String
- accountNumber (Field2) — String
- accountBankName (Field3) — String
- accountBalance (Field6) — Integer
- createdAt (Field4) — DateTime
- modifiedAt (Field5) — DateTime
- userId (Key2) — Long — Foreign key → User.userId — NOT NULL
Category (Untitled5)
- categortId (Key) — Long — Primary key — NOT NULL
- categoryType (Field) — Enum
- createdAt (Field2) — DateTime
- modifiedAt (Field3) — DateTime
Order (Untitled4)
- orderId (Key) — Long — Primary key — NOT NULL
- createdAt (Field) — DateTime
- modifiedAt (Field2) — DateTime
- orderedStock (Field3) — Integer
- orderStatus (Field5) — Enum
- totalPrice (Field4) — Integer
- productId (Key2) — Long — Foreign key → Product.productId — NOT NULL
- userId (Key3) — Long — Foreign key → User.userId — NOT NULL
Product (Untitled3)
- productId (Key) — Long — Primary key — NOT NULL
- name (Field) — String
- description (Field2) — String
- image (Field5) — String
- price (Field3) — Integer
- stock (Field4) — Integer
- createdAt (Field6) — DateTime
- modifiedAt (Field7) — DateTime
- categortId (Key2) — Long — Foreign key → Category.categortId — NOT NULL
- userId (Key3) — Long — Foreign key → User.userId — NOT NULL
User (Untitled)
- userId (Key) — Long — Primary key — NOT NULL
- name (Field) — String
- loginId (Field2) — String
- password (Field3) — String
- phoneNumber (Field4) — String
- createdAt (Field5) — DateTime
- modifiedAt (Field6) — DateTime