test

Tables (22)

attend_tb

  • perform_id — integer — Foreign key — NOT NULL
  • user_id — integer — Foreign key — NOT NULL
  • created_at — timestamp(6)

club_img_tb

  • id — serial
  • club_id — integer — NOT NULL
  • user_id — integer — NOT NULL
  • file_path — varchar(255)
  • created_at — timestamp
  • updated_at — timestamp
  • is_main — boolean
  • file_size — bigint
  • original_name — varchar(255)

club_keyword_summary

  • id — serial
  • club_id — integer — NOT NULL
  • keyword_id — integer — NOT NULL
  • review_id — integer — NOT NULL

club_review_keyword_tb

  • id — serial
  • keyword_id — integer — NOT NULL
  • review_id — integer — NOT NULL

club_review_tb

  • id — serial
  • club_id — integer — NOT NULL
  • user_id — integer — NOT NULL
  • rating — double
  • created_at — timestamp
  • updated_at — timestamp
  • content — text

club_tb

  • id — serial
  • user_id — integer — NOT NULL
  • created_at — timestamp
  • name — varchar(20)
  • location — geography(Point, 4326)
  • phone — varchar(15)
  • open_time — time
  • close_time — time
  • capacity — integer
  • address — varchar(50)
  • description — text
  • avg_rating — double
  • review_cnt — integer
  • updated_at — timestamp
  • sns_links — jsonb
  • latest_review_at — timestamp
  • longitude — double
  • latitude — double

favorite_tb

  • id — serial
  • club_id — integer — NOT NULL
  • user_id — integer — NOT NULL

keyword_category_code

  • id — serial
  • code — varchar(10)
  • name — varchar(10)

keyword_tb

  • id — serial
  • category_id — integer — NOT NULL
  • name — varchar(50)
  • icon_path — text
  • sort_order — integer

nickname_word_tb

  • id — serial
  • category — varchar(10) — NOT NULL
  • (adjective::character — varying)::text
  • (species::character — varying)::text))
  • word — varchar(10) — NOT NULL

perform_img_tb

  • id — serial
  • perform_id — integer — NOT NULL
  • file_path — varchar(255)
  • created_at — timestamp
  • updated_at — timestamp
  • is_main — boolean
  • original_name — varchar(255)
  • file_size — bigint

perform_review_like_tb

  • id — serial
  • review_id — integer — NOT NULL
  • user_id — integer — NOT NULL
  • created_at — timestamp

perform_review_tb

  • id — serial
  • perform_id — integer — NOT NULL
  • user_id — integer — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • content — varchar(100) — NOT NULL
  • like_count — integer — NOT NULL

perform_tb

  • id — serial
  • club_id — integer — NOT NULL
  • user_id — integer — NOT NULL
  • title — varchar(100)
  • description — text
  • perform_date — timestamp
  • booking_price — integer
  • created_at — timestamp
  • updated_at — timestamp
  • is_cancelled — boolean
  • artists — jsonb
  • sns_links — jsonb
  • onsite_price — integer
  • booking_url — varchar(255)

report_category_code

  • id — serial
  • code — varchar(50)
  • name — varchar(50)

report_status_code

  • id — serial
  • code — varchar(20)
  • name — varchar(10)

report_tb

  • id — serial
  • user_id — integer — NOT NULL
  • category_id — integer — NOT NULL
  • type_id — integer — NOT NULL
  • status_id — integer — NOT NULL
  • entity_id — integer — NOT NULL
  • created_at — timestamp
  • content — text

report_type_code

  • id — serial
  • code — varchar(20)
  • name — varchar(10)

review_img_tb

  • id — serial
  • review_id — integer — NOT NULL
  • file_path — text
  • created_at — timestamp
  • updated_at — timestamp
  • is_main — boolean
  • original_name — varchar(255)
  • file_size — bigint

social_code

  • id — serial
  • code — varchar(10)
  • name — varchar(20)

user_settings_tb

  • user_id — integer — NOT NULL
  • favorite_clubs_privacy — varchar(20) — NOT NULL
  • private::character — varying
  • friends::character — varying)::text))
  • attendance_privacy — varchar(20) — NOT NULL
  • private::character — varying
  • friends::character — varying)::text))
  • perform_history_privacy — varchar(20) — NOT NULL
  • private::character — varying
  • friends::character — varying)::text))
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

user_tb

  • id — serial
  • social_id — integer — NOT NULL
  • nickname — varchar(23)
  • created_at — timestamp
  • updated_at — timestamp
  • profile_path — text
  • role — varchar(20)
  • provider_id — varchar(255)
  • bio — text
  • email — varchar(255)
  • public_id — varchar(13)