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