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)