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)