test
Tables (8)
card
- id — bigint
- user_id — int — NOT NULL
- card_number — varchar(20) — NOT NULL
- card_name — varchar(100)
- card_type — varchar(50)
- expiry — varchar(10)
- created_at — timestamp
cart
- id — int
- user_id — int
- store_id — int
- is_active — tinyint(1)
- total_amount — int
- created_at — datetime
- cart_number — int — NOT NULL
- status — varchar(50)
cartitem
- id — int
- cart_id — int
- product_id — int
- quantity — int
- unit_price — int
- total_price — int
payment
- id — int
- user_id — int — NOT NULL
- cart_id — int — NOT NULL
- amount — int — NOT NULL
- method — varchar(50)
- status — varchar(20)
- issued_at — timestamp
payment_item
- id — bigint
- payment_id — bigint — NOT NULL
- product_name — varchar(255)
- quantity — int
- total_price — int
product
- id — int
- name — varchar(255)
- price — int
- weight — varchar(50)
- image_identifier — varchar(255)
- image_url — text
store
- id — int
- name — varchar(255)
- latitude — double
- longitude — double
- beacon_uuid — varchar(255)
user
- id — int — Primary key
- user_id — varchar(255)
- name — varchar(255)
- email — varchar(255)
- password — varchar(255)
- refresh_token — varchar(255)
- is_registered — tinyint(1)
- current_store_id — int
- created_at — datetime
- last_login_at — datetime