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