kakaopay

Tables (4)

k_member (멤버)

  • id — bigint — Primary key — NOT NULL — auto_increment
  • user_id (사용자 번호) — varchar(9) — NOT NULL — unique
  • username (사용자 아이디) — varchar(50) — NOT NULL
  • barcode (바코드) — varcher(10) — NOT NULL — unique
  • created_at (생성일자) — timestamp — NOT NULL

k_member_point (멤버별 포인트)

  • id — bigint — Primary key — NOT NULL — auto_increment
  • store_category_id (가게 카테고리) — bigint — NOT NULL
  • member_id (Field) — bigint — NOT NULL
  • point (포인트) — int
  • created_at (생성일자) — timestamp — NOT NULL
  • updated_at (수정일자) — timestamp

k_point_history (포인트 내역)

  • id — bigint — Primary key — NOT NULL
  • member_id (Field) — bigint — NOT NULL
  • store_category_id (가게 카테고리) — bigint — NOT NULL
  • point (포인트) — int
  • action (활동) — varchar(5) — NOT NULL — add / use
  • store_id (가게 id) — bigint — NOT NULL
  • created_at (생성일자) — timestamp — NOT NULL

k_store (가게)

  • id — bigint — Primary key — NOT NULL
  • store_category_id (가게 카테고리) — bigint — NOT NULL
  • name (가게명) — varchar(50) — NOT NULL
  • created_at (생성일시) — timestamp — NOT NULL
  • created_by (생성자) — bigint
  • updated_at (수정일시) — timestamp
  • updated_by (수정자) — bigint