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