POS_UPDATING

Tables (7)

admins

  • id — SERIAL
  • nickname — VARCHAR — NOT NULL
  • email — VARCHAR
  • phone_number — VARCHAR — NOT NULL
  • access_level — access_level — NOT NULL
  • is_mobile_verified — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP(6) — NOT NULL
  • updated_at — TIMESTAMP(6) — NOT NULL
  • deleted_at — TIMESTAMP(6)
  • admin_type — admin_registration_status — NOT NULL
  • business_number — VARCHAR
  • owner_id — INTEGER

customers

  • id — SERIAL
  • nickname — VARCHAR — NOT NULL
  • email — VARCHAR
  • phone_number — VARCHAR — NOT NULL
  • access_level — access_level — NOT NULL
  • is_mobile_verified — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP(6) — NOT NULL
  • updated_at — TIMESTAMP(6) — NOT NULL
  • deleted_at — TIMESTAMP(6)
  • registration_status — registration_status — NOT NULL
  • birth_date — DATE
  • is_agreement — BOOLEAN — NOT NULL
  • agreed_at — TIMESTAMP(6)

notifications

  • id — SERIAL
  • admin_id — INTEGER
  • customer_id — INTEGER

store_visit_histories

  • id — SERIAL
  • customer_id — INTEGER

stores

  • id — SERIAL
  • owner_id — INTEGER

user_auth_providers

  • id — SERIAL
  • admin_id — INTEGER
  • customer_id — INTEGER

waiting

  • id — SERIAL
  • customer_id — INTEGER