YouHaveTo
Tables (13)
accuse
- accuse_id — bigserial
- accuse_type — varchar(255)
- content — varchar(1000)
- canceled_at — varchar(255)
- created_at — varchar(255)
- updated_at — varchar(255)
- post_id — bigint
- comment_id — bigint
- accuse_get_type — varchar(255)
chat_list
- chat_list_id — bigserial
- member_id — bigint
chat_message
- chat_message_id — bigserial
- chat_content — varchar(255)
- canceled_at — varchar(255)
- created_at — varchar(255)
- updated_at — varchar(255)
- message_type — varchar(255)
- CHAT::character — varying
- OUT::character — varying)::text))
- chat_room — bigint
- member_id — bigint
chat_room
- chat_room_id — bigserial
- chat_title — varchar(255)
- canceled_at — varchar(255)
- created_at — varchar(255)
- updated_at — varchar(255)
- chat_list — bigint
- room_name — varchar(255)
comment
- comment_id — bigserial
- comment_content — varchar(300)
- canceled_at — varchar(255)
- created_at — varchar(255)
- updated_at — varchar(255)
- writer_id — bigint
- parent_id — bigint
- post_id — bigint
diary
- Key — Primary key — NOT NULL
- diary_id — bigserial
- canceled_at — varchar(255)
- created_at — varchar(255)
- updated_at — varchar(255)
- exercise_date — varchar(255)
- review — varchar(1000)
- member_id — bigint
diary_exercise_info
- diary_diary_id — bigint — NOT NULL
- body_part — varchar(255)
- cardio — boolean — NOT NULL
- cardio_time — integer — NOT NULL
- ex_set_count — integer — NOT NULL
- exercise_name — varchar(255)
- finished — boolean — NOT NULL
- reps — integer — NOT NULL
email_code
- email_code_id — bigserial
- code — varchar(255)
- created_at — timestamp(6)
- email — varchar(255)
like_count
- like_id — bigserial
- member_id — bigint
- post_id — bigint
media
- media_id — bigserial
- canceled_at — varchar(255)
- created_at — varchar(255)
- updated_at — varchar(255)
- file_path — varchar(255)
- filename — varchar(255)
- original_filename — varchar(255)
- diary_id — bigint
- post_id — bigint
member
- member_id — bigserial
- canceled_at — varchar(255)
- created_at — varchar(255)
- updated_at — varchar(255)
- email — varchar(255)
- field — varchar(255)
- login_id — varchar(20)
- password — varchar(255)
- role — varchar(255)
- username — varchar(20)
- media_id — bigint
- token_id — bigint
post
- post_id — bigserial
- content — varchar(1000)
- canceled_at — varchar(255)
- created_at — varchar(255)
- updated_at — varchar(255)
- post_type — varchar(255)
- title — varchar(100)
- views — bigint
- work_out_category — varchar(255)
- member_id — bigint
refresh_token
- token_id — bigserial
- canceled_at — varchar(255)
- created_at — varchar(255)
- updated_at — varchar(255)
- refresh_token — varchar(255)