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