shoppingmall

Tables (7)

cart

  • id (Key) — bigint — Primary key — NOT NULL
  • uid (Key2) — varchar — Foreign key → users.id — NOT NULL
  • product_id (Key3) — bigint — Foreign key → product.id — NOT NULL
  • option — varchar(255)
  • quantity — integer
  • created_at — timestamp
  • created_by — varchar(255)
  • modified_at — timestamp
  • modified_by — varchar(255)

orders

  • id (Key) — bigint — Primary key — NOT NULL
  • uid (Key2) — bigint — Foreign key → users.id — NOT NULL
  • order_token — varchar(255)
  • order_status — varchar(255)
  • payment_type — varchar(255)
  • is_pay — boolean
  • total_price — numeric(19, 2)
  • total_quantity — integer
  • delivery_fee — numeric(19, 2)
  • promotion_discount — numeric(19, 2)
  • receiver_name — varchar(255)
  • receiver_tel — varchar(255)
  • receiver_addr — varchar(255)
  • receiver_addr_detail — varchar(255)
  • receiver_email — varchar(255)
  • delivery_msg — varchar(255)
  • created_at — timestamp
  • created_by — varchar(255)
  • modified_at — timestamp
  • modified_by — varchar(255)

orders_detail

  • id (Key) — bigint — Primary key — NOT NULL
  • orders_id (Key2) — bigint — Foreign key → orders.id — NOT NULL
  • product_code — varchar(255)
  • final_price — numeric(19, 2)
  • origin_price — numeric(19, 2)
  • quantity — integer
  • discount — numeric(19, 2)
  • product_name — varchar(255)
  • option — integer
  • created_at — timestamp
  • created_by — varchar(255)
  • modified_at — timestamp
  • modified_by — varchar(255)

payment

  • id (Key) — bigint — Primary key — NOT NULL
  • orders_id (Key2) — bigint — Foreign key → orders.id — NOT NULL
  • payment_type — varchar(255)
  • pay_company_code — varchar(255)
  • pay_amount — numeric(19, 2)
  • card_company — varchar(255)
  • card_no — varchar(255)
  • card_exp_mon — varchar(255)
  • card_exp_year — varchar(255)
  • card_cvv — varchar(255)
  • card_pw — varchar(255)
  • created_at — timestamp
  • created_by — varchar(255)
  • modified_at — timestamp
  • modified_by — varchar(255)

product

  • id (Key) — bigint — Primary key — NOT NULL
  • product_code — varchar(255)
  • product_type — varchar(255)
  • product_name — varchar(255)
  • price — numeric(19, 2)
  • thumbnail — varchar(255)
  • detail_image — varchar(1000)
  • service_type — varchar(255)
  • option — varchar(255)
  • is_delete — boolean
  • created_at — timestamp
  • created_by — varchar(255)
  • modified_at — timestamp
  • modified_by — varchar(255)

review

  • id (Key) — bigint — Primary key — NOT NULL
  • product_id (Key2) — bigint — Foreign key → product.id — NOT NULL
  • users_id (Key3) — bigint — Foreign key → users.id — NOT NULL
  • score — integer
  • content — varchar(255)
  • created_by — varchar(255)
  • created_at — timestamp
  • modified_at — timestamp
  • modified_by — varchar(255)

users

  • id (Key) — bigint — Primary key — NOT NULL
  • uid — varchar(255)
  • email — varchar(255)
  • password — varchar(255)
  • name — varchar(255)
  • phone_number — varchar(255)
  • authority — varchar(255)
  • sign_up_type — varchar(255)
  • user_type — varchar(255)
  • point — integer
  • created_at — timestamp
  • created_by — varchar(255)
  • modified_at — timestamp
  • modified_by — varchar(255)