e-commerce
Tables (9)
Member (Untitled)
- id (Key) — BIGINT — Primary key — NOT NULL
- name (Field) — varchar
- email (Field2) — varchar
- phone_number (Field3) — varchar
- address (Field4) — varchar
- nickname (Field5) — varchar
- password (Field6) — varchar
- createdAt (Field7) — LocalDateTime
- updatedAt (Field8) — LocalDateTime
- deletedAt (Field9) — LocalDateTime
Order (Untitled3)
- id (Key) — BIGINT — Primary key — NOT NULL
- member_id (Key2) — BIGINT — Foreign key → Member.id — NOT NULL
- shippingInfo_id (Key4) — BIGINT — Foreign key → ShippingInfo.id — NOT NULL
- total_amount (Field) — BIGINT
- order_state (Field2) — ENUM
- orderAt (Field3) — LocalDateTime
- createdAt (Field4) — LocalDateTime
- updatedAt (Field5) — LocalDateTime
- deletedAt (Field6) — LocalDateTime
OrderLine (Untitled4)
- id (Key) — BIGINT — Primary key — NOT NULL
- order_id (Key2) — BIGINT — Foreign key → Order.id — NOT NULL
- member_id (Key22) — BIGINT — Foreign key → Order.member_id — NOT NULL
- product_id (Key3) — BIGINT — Foreign key → Product.id — NOT NULL
- shipingInfo_id (Key4) — BIGINT — Foreign key → Order.shippingInfo_id — NOT NULL
- time_deal_id (Key5) — BIGINT — Foreign key → ProductTimeDeal.id — NOT NULL
- price (Field) — BIGINT
- quatity (Field2) — BIGINT
- amounts (Field3) — BIGINT
OrderState (Untitled6)
- payment_waiting (Field)
- preparing (Field2)
- shipped (Field3)
- delivering (Field4)
- delivery_completed (Field5)
- canceled (Field6)
Product (Untitled2)
- id (Key) — BIGINT — Primary key — NOT NULL
- name (Field) — varchar
- description (Field2) — varchar
- price (Field3) — BIGINT
- stock (Field5) — BIGINT
- image_url (Field4) — BIGINT
- createdAt (Field6) — LocalDateTime
- updatedAt (Field7) — LocalDateTime
- deletedAt (Field8) — LocalDateTime
ProductTimeDeal (CopyOfUntitled2)
- id (Key) — BIGINT — Primary key — NOT NULL
- name (Field) — varchar
- description (Field2) — varchar
- price (Field3) — BIGINT
- stock (Field5) — BIGINT
- image_url (Field4) — BIGINT
- createdAt (Field6) — LocalDateTime
- updatedAt (Field7) — LocalDateTime
- deletedAt (Field8) — LocalDateTime
- start_time (Field9) — LocalDateTime
- end_time (Field10) — LocalDateTime
- discount_percent (Field11) — Float
ShippingInfo (Untitled5)
- id (Key) — BIGINT — Primary key — NOT NULL
- receiver_name (Field) — varchar
- receiver_phone_number (Field2) — varchar
- shipping_address1 (Field3) — varchar
- shipping_address2 (Field4) — varchar
- shipping_zip_code (Field5) — varchar
- createdAt (Field6) — LocalDateTime
- updatedAt (Field7) — LocalDateTime
- deletedAt (Field8) — LocalDateTime
WishList (Untitled7)
- id (Key) — BIGINT — Primary key — NOT NULL
- member_id (Key2) — BIGINT — Foreign key → Member.id — NOT NULL
WishListLine (Untitled8)
- id (Key) — BIGINT — Primary key — NOT NULL
- wishList_id (Key2) — BIGINT — Foreign key → WishList.id — NOT NULL
- member_id (Key22) — BIGINT — Foreign key → WishList.member_id — NOT NULL
- product_id (Key3) — BIGINT — Foreign key → Product.id — NOT NULL
- quantity (Field) — BIGINT
- price (Field2) — BIGINT
- amounts (Field3) — BIGINT