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)