SMAT

Tables (17)

banners

  • id — BIGSERIAL
  • title — VARCHAR(80) — NOT NULL
  • image_url — VARCHAR(255) — NOT NULL
  • link_url — VARCHAR(255)
  • start_at — TIMESTAMPTZ
  • end_at — TIMESTAMPTZ
  • is_active — BOOLEAN — NOT NULL
  • sort_order — INT — NOT NULL

company_facilities

  • id — BIGSERIAL
  • company_id — BIGINT — NOT NULL
  • facility_tag_id — BIGINT — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • UNIQUE(company_id, — facility_tag_id)

company_images

  • id — BIGSERIAL
  • company_id — BIGINT — NOT NULL
  • image_url — VARCHAR(255) — NOT NULL
  • sort_order — INT — NOT NULL
  • is_main — BOOLEAN — NOT NULL
  • file_meta — JSONB
  • created_at — TIMESTAMPTZ — NOT NULL

company_operating_hours

  • id — BIGSERIAL
  • company_id — BIGINT — NOT NULL
  • day_of_week — INT — NOT NULL
  • open_time — TIME
  • close_time — TIME
  • is_closed — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

company_profiles

  • id — BIGSERIAL
  • owner_user_id — BIGINT — NOT NULL
  • verify_status — verify_status_enum — NOT NULL
  • submitted_at — TIMESTAMPTZ
  • verified_at — TIMESTAMPTZ
  • rejected_reason — VARCHAR(255)
  • company_name — VARCHAR(80)
  • company_phone_number — VARCHAR(20)
  • address — VARCHAR(255)
  • address_detail — VARCHAR(255)
  • latitude — DECIMAL(10,7)
  • longitude — DECIMAL(10,7)
  • description — TEXT
  • business_registration_number — VARCHAR(10)
  • business_registration_files — JSONB
  • logo_url — VARCHAR(255)
  • main_image_url — VARCHAR(255)
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

company_sports

  • id — BIGSERIAL
  • company_id — BIGINT — NOT NULL
  • sport_category_id — BIGINT — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • UNIQUE(company_id, — sport_category_id)

enrollments

  • id — BIGSERIAL
  • user_id — BIGINT — NOT NULL
  • program_schedule_id — BIGINT — NOT NULL
  • start_date — DATE — NOT NULL
  • end_date — DATE — NOT NULL
  • status — enrollment_status_enum — NOT NULL
  • rejected_reason — VARCHAR(255)
  • total_amount — INT
  • paid_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • UNIQUE(user_id, — program_schedule_id,

facility_tags

  • id — BIGSERIAL
  • code — VARCHAR(30) — NOT NULL
  • name — VARCHAR(30) — NOT NULL
  • icon_url — VARCHAR(255)
  • sort_order — INT — NOT NULL
  • is_active — BOOLEAN — NOT NULL

favorites

  • id — BIGSERIAL
  • user_id — BIGINT — NOT NULL
  • target_type — favorite_target_enum — NOT NULL
  • target_id — BIGINT — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • UNIQUE(user_id, — target_type,

instructor_profiles

  • id — BIGSERIAL
  • user_id — BIGINT — NOT NULL
  • verify_status — verify_status_enum — NOT NULL
  • submitted_at — TIMESTAMPTZ
  • verified_at — TIMESTAMPTZ
  • rejected_reason — VARCHAR(255)
  • profile_image_url — VARCHAR(255)
  • bio — VARCHAR(80)
  • description — TEXT
  • career_text — TEXT
  • specialties — JSONB
  • lesson_types — JSONB
  • region — VARCHAR(50)
  • qualifications — JSONB
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

payments

  • id — BIGSERIAL
  • enrollment_id — BIGINT — NOT NULL
  • provider — VARCHAR(30) — NOT NULL
  • status — payment_status_enum — NOT NULL
  • amount — INT — NOT NULL
  • currency — VARCHAR(10) — NOT NULL
  • transaction_id — VARCHAR(100)
  • paid_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL

program_instructors

  • id — BIGSERIAL
  • program_schedule_id — BIGINT — NOT NULL
  • instructor_profile_id — BIGINT — NOT NULL
  • role — VARCHAR(20)
  • created_at — TIMESTAMPTZ — NOT NULL
  • UNIQUE(program_schedule_id, — instructor_profile_id)

program_schedules

  • id — BIGSERIAL
  • program_id — BIGINT — NOT NULL
  • days_of_week — JSONB — NOT NULL
  • start_time — TIME — NOT NULL
  • end_time — TIME — NOT NULL
  • capacity — INT
  • status — schedule_status_enum — NOT NULL
  • registration_start_at — TIMESTAMPTZ
  • registration_end_at — TIMESTAMPTZ
  • instructor_profile_id — BIGINT
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

programs

  • id — BIGSERIAL
  • company_id — BIGINT — NOT NULL
  • title — VARCHAR(80) — NOT NULL
  • description — TEXT
  • level — program_level_enum
  • price — INT — NOT NULL
  • currency — VARCHAR(10) — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

sns_posts

  • id — BIGSERIAL
  • author_type — author_type_enum — NOT NULL
  • author_id — BIGINT — NOT NULL
  • image_url — VARCHAR(255) — NOT NULL
  • content — TEXT
  • created_at — TIMESTAMPTZ — NOT NULL

sport_categories

  • id — BIGSERIAL
  • code — VARCHAR(30) — NOT NULL
  • name — VARCHAR(30) — NOT NULL
  • icon_url — VARCHAR(255)
  • sort_order — INT — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

users

  • id — BIGSERIAL
  • provider — VARCHAR(20) — NOT NULL
  • email — VARCHAR(100)
  • name — VARCHAR(50) — NOT NULL
  • nickname — VARCHAR(30)
  • gender — gender_enum
  • phone_number — VARCHAR(20) — NOT NULL
  • is_phone_verified — BOOLEAN — NOT NULL
  • phone_verified_at — TIMESTAMPTZ
  • profile_image_url — VARCHAR(255)
  • role — user_role_enum — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • deleted_at — TIMESTAMPTZ