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