Kream

Tables (6)

card (Untitled6)

  • card_number (Key) — Primary key — NOT NULL
  • company (Field)

order (Untitled4)

  • id (Key) — int — Primary key — NOT NULL
  • product_id (Field) — int
  • created_at (Field2) — datetime

product (Untitled)

  • product_id (Key) — int — Primary key — NOT NULL
  • model_code (Field6) — varchar(255)
  • product_name (Field5) — varchar(255)
  • type (Field) — varchar(255)
  • size (Field3) — int
  • gender (Field4) — varchar(255)
  • released_at (Key2) — datetime — NOT NULL
  • purchase_sale (Field7) — varchar(255)
  • market_price (Field2) — int
  • release_price (Field8) — int
  • color (Field9) — varchar(255)
  • brand_name (Field10) — varchar(255)

shipping (Untitled5)

  • id (Key) — int — Primary key — NOT NULL
  • product_id (Field) — int
  • created_at (Field2) — datetime
  • state (Field3) — varchar(255)
  • due_date (Field4) — datetime

user (Untitled2)

  • user_id (Key) — int — Primary key — NOT NULL
  • name (Field) — varchar(255)
  • date_of_birth (Field2) — datetime
  • address (Field3) — varchar(255)
  • phone_number (Field4) — varchar(255)
  • email (Field5) — varchar(255)
  • create_at (Field6) — datetime
  • login_id (Field7) — varchar(255)
  • pw (Field8) — varchar(255)
  • main_card (Field9) — varchar(255)

wishlist (Untitled3)

  • user_id (Key) — Primary key — NOT NULL
  • product_id (Field)