TRIT

Tables (50)

business_hour

  • id — bigint
  • company_id — bigint
  • day_of_week — varchar(255)
  • start_time — time(6)
  • end_time — time(6)

campaign

  • id — bigint
  • created_at — timestamp(6)
  • updated_at — timestamp(6)
  • application_end — date
  • application_start — date
  • brand_name — varchar(255)
  • business_hour — varchar(255)
  • campaign_result — date
  • category — smallint
  • creator_reveal — date
  • credit — integer
  • missions_details — varchar(255)
  • notice — varchar(255)
  • recruit_people — integer
  • reward — varchar(2000)
  • selection_end — date
  • selection_start — date
  • service_detail — varchar(255)
  • status — varchar(255)
  • PROGRESS::character — varying
  • APPROVAL::character — varying)::text))
  • thumbnail — varchar(255)
  • title — varchar(255)
  • video_max — integer
  • video_min — integer
  • visit_hours — varchar(255)
  • company_id — bigint
  • location_id — bigint

campaign_apply

  • id — bigint
  • created_at — timestamp(6)
  • updated_at — timestamp(6)
  • introduction — varchar(255)
  • campaign_id — bigint
  • users_id — bigint
  • status — varchar(255)

campaign_like_history

  • id — bigint
  • created_at — timestamp(6)
  • updated_at — timestamp(6)
  • campaign_id — bigint
  • users_id — bigint

campaign_sns

  • campaign_id — bigint — NOT NULL
  • sns — varchar(255)

comment

  • id — bigint
  • created_at — timestamp(6)
  • updated_at — timestamp(6)
  • content — varchar(500) — NOT NULL
  • likes — bigint
  • contents_id — bigint — NOT NULL
  • parent_id — bigint
  • user_id — bigint — NOT NULL

comment_like_history

  • id — bigint
  • liked_at — timestamp(6)
  • comment_id — bigint
  • users_id — bigint

company

  • id — bigint
  • created_at — timestamp(6)
  • updated_at — timestamp(6)
  • business_bank_account_copy_url — varchar(255)
  • business_registration_certificate_url — varchar(255)
  • category — varchar(255)
  • TASTY::character — varying
  • MAKE::character — varying
  • BEAUTY::character — varying
  • ALL::character — varying)::text))
  • company_name — varchar(255)
  • instagram_url — varchar(255)
  • profile_url — varchar(255)
  • registration_number — varchar(255)
  • representative_name — varchar(255)
  • tiktok_url — varchar(255)
  • type_of_business — varchar(255)
  • youtube_url — varchar(255)
  • company_location_id — bigint
  • users_id — bigint
  • company_type — varchar(255)

company_holiday

  • id — bigserial
  • company_id — bigint
  • date — date
  • name — varchar(255)

contents

  • id — bigint
  • created_at — timestamp(6)
  • updated_at — timestamp(6)
  • category — varchar(255)
  • TASTY::character — varying
  • MAKE::character — varying
  • BEAUTY::character — varying
  • ALL::character — varying)::text))
  • description — varchar(1000)
  • likes — bigint
  • thumbnail — varchar(255)
  • title — varchar(255)
  • url — varchar(255)
  • views — bigint
  • creator_id — bigint

contents_location

  • id — bigint
  • contents_id — bigint
  • location_id — bigint

coupon

  • id — bigint — NOT NULL
  • name — varchar(255) — NOT NULL
  • description — varchar(500) — NOT NULL
  • discount_type — varchar(255) — NOT NULL
  • discount_value — integer — NOT NULL
  • minimum_order_price — integer
  • max_discount_amount — integer
  • expiration_date — date
  • valid_days_after_issue — date
  • total_quantity — integer — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • code_name — varchar(100) — NOT NULL
  • issue_method — varchar(255) — NOT NULL
  • usage_limit_per_user — integer — NOT NULL
  • is_public — boolean — NOT NULL
  • priority — integer — NOT NULL
  • allow_duplicate_use_with_other_coupons — boolean — NOT NULL
  • issued_by_type — varchar(255) — NOT NULL
  • issued_by_id — bigint — NOT NULL
  • status — varchar(255) — NOT NULL

coupon_issuance_history

  • id — bigint — NOT NULL
  • coupon_template_id — bigint — NOT NULL
  • issued_at — timestamp — NOT NULL
  • used_at — timestamp
  • created_at — timestamp
  • updated_at — timestamp
  • issued_to_user_id — bigint
  • issued_by_user_id — bigint — NOT NULL
  • issued_to_target_id — bigint
  • issued_to_target_type — varchar(255) — NOT NULL
  • actual_expiration_date — date — NOT NULL
  • status — varchar(255) — NOT NULL

coupon_target

  • id — bigint — NOT NULL
  • coupon_id — bigint — NOT NULL
  • target_type — varchar(255) — NOT NULL
  • reference_id — bigint
  • created_at — timestamp
  • updated_at — timestamp

course_location_mapping

  • id — bigint
  • sequence — integer
  • courses_id — bigint
  • locations_id — bigint

course_user_mapping

  • id — bigint
  • courses_id — bigint
  • users_id — bigint

courses

  • id — bigint
  • created_at — timestamp(6)
  • updated_at — timestamp(6)
  • description — varchar(255)
  • name — varchar(255)
  • users_id — bigint
  • thumbnail — varchar(255)

creator

  • id — bigint
  • created_at — timestamp(6)
  • updated_at — timestamp(6)
  • category — varchar(255)
  • instagram — varchar(300)
  • introduction — varchar(500)
  • portfolio_image — varchar(255)
  • tiktok — varchar(300)
  • youtube — varchar(300)
  • user_id — bigint

databasechangelog

  • id — varchar(255) — NOT NULL
  • author — varchar(255) — NOT NULL
  • filename — varchar(255) — NOT NULL
  • dateexecuted — timestamp — NOT NULL
  • orderexecuted — integer — NOT NULL
  • exectype — varchar(10) — NOT NULL
  • md5sum — varchar(35)
  • description — varchar(255)
  • comments — varchar(255)
  • tag — varchar(255)
  • liquibase — varchar(20)
  • contexts — varchar(255)
  • labels — varchar(255)
  • deployment_id — varchar(10)

databasechangeloglock

  • id — integer — NOT NULL
  • locked — boolean — NOT NULL
  • lockgranted — timestamp
  • lockedby — varchar(255)

hashtags

  • id — bigint
  • name — varchar(255) — NOT NULL

hashtags_contents_mapping

  • id — bigint
  • contents_id — bigint
  • hashtags_id — bigint

holiday

  • id — bigserial
  • date — date
  • name — varchar(255)

inquire

  • id — bigint
  • created_at — timestamp(6)
  • updated_at — timestamp(6)
  • content — varchar(500)
  • inquire_category — varchar(255)
  • LOCATION::character — varying
  • USER::character — varying
  • OTHERS::character — varying)::text))
  • user_id — bigint

liked_history

  • id — bigint
  • liked_at — timestamp(6)
  • contents_id — bigint
  • users_id — bigint

location

  • id — bigint
  • address — varchar(255)
  • google_map_id — varchar(255)
  • latitude — double
  • longitude — double
  • place_name — varchar(255)
  • theme_type — varchar(255)
  • summary — varchar(255)

option_values

  • id — bigserial
  • created_at — timestamp(6)
  • updated_at — timestamp(6)
  • product_option — bigint
  • values_name — varchar(255)
  • product_status — varchar(255)
  • values_price — double

payment

  • id — bigint
  • created_at — timestamp(6)
  • updated_at — timestamp(6)
  • status — varchar(255) — NOT NULL
  • SUCCESS::character — varying
  • FAILED::character — varying
  • CANCELLED::character — varying
  • COMPLETED::character — varying)::text))
  • order_id — varchar(255)
  • tid — varchar(255)
  • scheme_group — varchar(255)
  • scheme_code — varchar(255)
  • amount — numeric(10, 2)
  • option_json — oid
  • product_id — bigint
  • user_id — bigint
  • people_count — integer
  • visit_date — date
  • visit_time — varchar(255)
  • req_date — varchar(255)
  • cancel_tid — varchar(255)
  • result_status — varchar(255)
  • result_code — varchar(255)
  • result_message — oid
  • refunded_at — timestamp(6)
  • requested_at — timestamp(6)
  • type — varchar(10)
  • mid — varchar(10)
  • product_name — varchar(100)
  • request_currency — varchar(3)
  • request_amount — numeric(15, 2)
  • approval_no — varchar(10)
  • approval_currency — varchar(3)
  • approval_amount — numeric(15, 2)
  • approval_day — varchar(20)
  • approval_time — varchar(20)
  • cancel_currency — varchar(3)
  • cancel_amount — numeric(15, 2)
  • cancel_day — varchar(20)
  • cancel_time — varchar(20)
  • mall_reserved — varchar(255)
  • sign — varchar(255)
  • people_option_json — oid
  • applied_coupon_issuance_history_id — bigint

people_count

  • id — bigserial
  • people_count — integer

people_option

  • id — bigserial
  • option_name — varchar(255)
  • option_price — numeric(38, 2)
  • product_id — bigint

place

  • id — bigint
  • favorite — boolean
  • name — varchar(255)
  • user_id — bigint — NOT NULL
  • color_code — varchar(255)
  • secret — boolean
  • thumbnail — varchar(255)

place_location

  • id — bigint
  • location_id — bigint — NOT NULL
  • place_id — bigint — NOT NULL

playlist

  • id — bigint
  • created_at — timestamp(6)
  • updated_at — timestamp(6)
  • name — varchar(255) — NOT NULL
  • user_id — bigint
  • secret — boolean — NOT NULL
  • thumbnail_url — varchar(500)

playlist_contents

  • id — bigserial
  • playlist_id — bigint
  • contents_id — bigint

product

  • id — bigserial
  • created_at — timestamp(6)
  • updated_at — timestamp(6)
  • category — varchar(255)
  • (TASTY::character — varying)::text
  • (MAKE::character — varying)::text
  • (BEAUTY::character — varying)::text
  • (ALL::character — varying)::text))
  • name — varchar(255)
  • price — double
  • bussiness_company — bigint
  • images_url_string_list — varchar(1000)
  • discount_percentage — integer
  • include_service — varchar(500)
  • exclude_service — varchar(500)
  • detail_description — text
  • notices — text
  • maximum_people — double
  • original_price — double
  • product_status — varchar(255)
  • likes — bigint
  • minimum_people — double
  • service_detail — text
  • people_count_type — varchar(255)
  • reservation_deadline_hours — integer

product_available_time

  • id — bigint
  • day_of_week — varchar(255)
  • (TUESDAY::character — varying)::text
  • (WEDNESDAY::character — varying)::text
  • (THURSDAY::character — varying)::text
  • (FRIDAY::character — varying)::text
  • (SATURDAY::character — varying)::text
  • (SUNDAY::character — varying)::text))
  • end_time — time(6)
  • start_time — time(6)
  • product_schedule_id — bigint
  • maximum_people — double
  • minimum_people — double
  • group_id — varchar(255)

product_like_history

  • product_id — bigint
  • id — bigint
  • liked_at — timestamp(6)
  • users_id — bigint

product_option

  • id — bigserial
  • created_at — timestamp(6)
  • updated_at — timestamp(6)
  • product_id — bigint
  • essential — boolean — NOT NULL
  • option_type — varchar(255)
  • option_name — varchar(255)

product_schedule

  • id — bigserial
  • product_id — bigint
  • end_date — date
  • start_date — date

refund_policy

  • id — bigint
  • days_before — integer
  • refund_ratio — integer
  • group_id — bigint
  • created_at — timestamp
  • updated_at — timestamp

refund_policy_group

  • id — bigint
  • group_name — varchar(255)
  • company_id — bigint
  • created_at — timestamp
  • updated_at — timestamp

reservation

  • people_count — integer
  • total_price — numeric(10, 2)
  • visit_date — date
  • visit_time — varchar(255)
  • created_at — timestamp(6)
  • id — bigint
  • product_id — bigint
  • updated_at — timestamp(6)
  • user_id — bigint
  • status — varchar(255)
  • (CANCELLED::character — varying)::text
  • (REJECTED::character — varying)::text
  • (FAILED::character — varying)::text))
  • payment_id — bigint
  • applied_coupon_issuance_history_id — bigint

reservation_option

  • option_price — numeric(10, 2)
  • quantity — integer
  • created_at — timestamp(6)
  • id — bigint
  • reservation_id — bigint
  • updated_at — timestamp(6)
  • option_name — varchar(255)
  • option_value — varchar(255)

reservation_people_option

  • id — bigint
  • option_name — varchar(255)
  • option_price — numeric(10, 2)
  • quantity — integer
  • reservation_id — bigint

review

  • id — bigserial
  • reservation_id — bigint — NOT NULL
  • user_id — bigint — NOT NULL
  • rating — double
  • comment — varchar(255) — archar(255
  • images_url_string_list — varchar(1000)
  • created_at — timestamp
  • updated_at — timestamp
  • likes — bigint

review_like_history

  • id — bigint
  • liked_at — timestamp(6)
  • review_id — bigint
  • users_id — bigint

submitted_contents

  • id — bigserial
  • campaign_apply_id — bigint — NOT NULL
  • creator_id — bigint — NOT NULL
  • contents_id — bigint — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • status — varchar(255) — NOT NULL

theme_contents

  • id — bigint
  • created_at — timestamp(6)
  • updated_at — timestamp(6)
  • theme_type — varchar(255)
  • contents_id — bigint — NOT NULL

users

  • id — bigint
  • created_at — timestamp(6)
  • updated_at — timestamp(6)
  • background_image — varchar(255)
  • birthday — date
  • country — varchar(255)
  • email — varchar(255)
  • gender — varchar(255)
  • WOMAN::character — varying
  • OTHERS::character — varying)::text))
  • nationality — varchar(255)
  • nickname — varchar(255)
  • password — varchar(255)
  • phone_number — varchar(255)
  • profile_image — varchar(255)
  • role — varchar(255)
  • USER::character — varying
  • CREATOR::character — varying
  • COMPANY::character — varying
  • UNKNOWN::character — varying)::text))
  • user_id — varchar(255)
  • name — varchar(255)

watched_history

  • id — bigint
  • watched_at — timestamp(6)
  • contents_id — bigint
  • users_id — bigint