ddd

Tables (3)

t_category

  • category_pk — INT
  • category_nm — VARCHAR(30) — NOT NULL

t_purchase_product

  • product_pk — INT
  • user_pk — INT
  • category_pk — INT
  • product_nm — VARCHAR(20) — NOT NULL
  • memo — VARCHAR(100)
  • product_count — SMALLINT(2)
  • created_at — DATETIME
  • updated_at — DATETIME
  • buying_check — TINYINT(1) — NOT NULL
  • buying_date — DATETIME

t_user

  • user_pk — INT
  • uid — VARCHAR(20) — NOT NULL
  • upw — VARCHAR(20) — NOT NULL
  • nm — VARCHAR(20) — NOT NULL
  • created_at — DATETIME