database

Tables (7)

11st (Untitled4)

  • id (Key) — varchar(10) — Foreign key → User.id — NOT NULL
  • 11st key (Field) — varchar(50)

CheckOption (Untitled7)

  • num (Key) — tinyint(100) — Foreign key → Option.num — NOT NULL
  • check (Field) — tinyint(1)

Coupang (Untitled3)

  • id (Key) — varchar(10) — Foreign key → User.id — NOT NULL
  • coupang id (Field) — varchar(15)
  • coupang code (Field2) — varchar(10)
  • coupang key (Field3) — varchar(50)
  • secret key (Field4) — varchar(50)

Option (Untitled6)

  • num (Key) — tinyint(100) — Primary key — NOT NULL
  • index (Key2) — smallint(1000) — Foreign key → Product.index — NOT NULL
  • option1_name (Field) — varchar(15)
  • option1_price (Field2) — varchar(10)
  • option1_dprice (Field3) — varchar(10)
  • option2_name (Field5) — varchar(15)
  • option2_price (Field6) — varchar(10)
  • option2_dprice (Field7) — varchar(10)
  • synchro (Field4) — varchar(5)

Product (Untitled5)

  • index (Key2) — smallint(1000) — Primary key — NOT NULL
  • id (Key) — varchar(10) — Foreign key → User.id — NOT NULL
  • url (Field) — varchar(100)
  • tname (Field2) — varchar(50)
  • price (Field3) — varchar(10)
  • category (Field4) — varchar(30)
  • code (Field5) — varchar(15)
  • detail (Field6)

Setup (Untitled2)

  • id (Key2) — varchar(10) — Foreign key → User.id — NOT NULL
  • delivery charge (Field) — varchar(8)
  • change charge (Field2) — varchar(8)
  • return chargev (Field3) — varchar(8)
  • day for delivery (Field4) — varchar(8)
  • price rate (Field5) — varchar(5)

User (Untitled)

  • id (Key) — varchar(10) — Primary key — NOT NULL
  • password (Field) — varchar(15)