Baristack
Tables (7)
auth_log
- log_id — bigint — Primary key — NOT NULL
- event_type — varchar(50) — NOT NULL
- ip — varchar(45) — NOT NULL
- user_agent — varchar(255)
- reason — varchar(100)
- created_at — datetime — NOT NULL
- USER_ID — bigint — Foreign key → users.USER_ID — NOT NULL
reward_master
- REWARD_ID — bigint — Primary key — NOT NULL
- NAME — varchar(100) — NOT NULL
- REQUIRED_STAMPS — int — NOT NULL
- START_DATE — date — NOT NULL
- END_DATE — date — NOT NULL
- STOCK — int
user_queue_record
- QUEUE_ID — bigint — Primary key — NOT NULL
- USER_ID — bigint — NOT NULL
- STATUS — enum('WAIT','ENTERED','EXITED') — NOT NULL
- ENTER_ORDER — int
- ENTERED_AT — datetime
- EXITED_AT — datetime
user_refresh_token
- ID — bigint — Primary key — NOT NULL
- REFRESH_TOKEN — varchar(500) — NOT NULL
- EXPIRES_AT — datetime — NOT NULL
- CREATED_AT — datetime — NOT NULL
- USER_ID — bigint — Foreign key → users.USER_ID — NOT NULL
user_stamp_history
- HISTORY_ID — bigint — Primary key — NOT NULL
- ACTION_TYPE — enum('EARN','USE') — NOT NULL
- STAMP_CHANGE — int — NOT NULL
- CREATED_AT — datetime — NOT NULL
- USER_ID (USER_ID2) — bigint — Foreign key → users.USER_ID — NOT NULL
user_stamp_summary
- USER_ID — bigint — Primary key — NOT NULL
- TOTAL_STAMPS — int — NOT NULL
- UPDATED_AT — datetime — NOT NULL
- USER_ID (USER_ID2) — bigint — Foreign key → users.USER_ID — NOT NULL
users
- USER_ID — bigint — Primary key — NOT NULL
- USER_NAME — varchar(50)
- PASSWORD — varchar(255) — NOT NULL
- PHONE — varchar(20)
- STATUS — varchar(20) — NOT NULL
- CREATED_AT — datetime — NOT NULL
- UPDATED_AT — datetime — NOT NULL