CJ

Tables (3)

brands (brand)

  • b_id (PK) — INTEGER — Primary key — NOT NULL
  • name (Field) — varchar(20)
  • eng_name (Field2) — varchar(20)
  • description (Field3) — varchar(100)
  • note (Field4) — varchar(100)
  • is_delete (Field5) — BIT

products

  • p_id (PK) — INTEGER — Primary key — NOT NULL
  • b_id (PK2) — INTEGER — Foreign key → brands.b_id — NOT NULL
  • name (Field)
  • price (Field2) — INTEGER
  • is_delete (Field3) — BIT

users

  • u_id (PK) — INTEGER — Primary key — NOT NULL
  • name (Field) — varchar(10)
  • id (Field2) — varchar(20)
  • password (Field3)