tex3d

Tables (5)

Categori

  • Key (id) — Not null — Primary key — NOT NULL
  • id (level) — Not null — Foreign key → User.id
  • Field (user_insert) — null

Fabric

  • Key (id) — Not null — Primary key — NOT NULL
  • Key (CategoryID) — Not null — Foreign key → Sub_categori.Key — NOT NULL
  • name — Not null
  • Field (image) — Not null
  • Field (ThumbImg) — Not null
  • Field

Product

  • Key (id) — Not null — Primary key — NOT NULL
  • Key (CategoryID) — Not null — Foreign key → Sub_categori.Key — NOT NULL
  • Field (name) — Not null
  • Field (Image) — Not null
  • Field (thumb) — Not null
  • Field (txd) — Not null
  • Field (xml) — Not null
  • Field (categorinum(id2)) — Not null
  • Field

Sub_categori (Sub_catagori)

  • Key (id) — Primary key — NOT NULL
  • Key (id2) — Not null — Foreign key → Categori.Key — NOT NULL
  • Field (user_insert) — Not null
  • Field

User

  • id — Not null — Primary key
  • username (ID) — Not null
  • password (PW) — Not null
  • name — Not null
  • brith — Not null
  • Field (gender) — Not null
  • Field (email) — Not null
  • Field (phone) — Not null
  • Field (address) — null
  • Field (level) — Not null
  • Field (left_date) — null