dongsoop-2
Tables (36)
chat_messages
- message_id — character — NOT NULL
- content — character — NOT NULL
- room_id — character — NOT NULL
- sender_id — bigint — NOT NULL
- timestamp — timestamp(6) — NOT NULL
- type — character
- ENTER::character — varying
- LEAVE::character — varying)::text)))
chat_room_participants
- room_id — character — NOT NULL
- participant_id — bigint
chat_rooms
- room_id — character — NOT NULL
- created_at — timestamp(6)
- is_group_chat — boolean — NOT NULL
- last_activity_at — timestamp(6)
- manager_id — bigint
- title — character
department
- id — character — NOT NULL
- name — character
- notice_url — character
- DEPT_2001::character — varying
- DEPT_2002::character — varying
- DEPT_2003::character — varying
- DEPT_3001::character — varying
- DEPT_3002::character — varying
- DEPT_4001::character — varying
- DEPT_4002::character — varying
- DEPT_5001::character — varying
- DEPT_5002::character — varying
- DEPT_5003::character — varying
- DEPT_5004::character — varying
- DEPT_6001::character — varying
- DEPT_6002::character — varying
- DEPT_6003::character — varying
- DEPT_6004::character — varying
- DEPT_6005::character — varying
- DEPT_6006::character — varying
- DEPT_7001::character — varying
- DEPT_7002::character — varying
- DEPT_7003::character — varying
- DEPT_7004::character — varying
- DEPT_7005::character — varying
- DEPT_7006::character — varying
- DEPT_8001::character — varying
- DEPT_9001::character — varying)::text)))
feedback
- id — bigint — NOT NULL
- created_at — timestamp(6)
- is_deleted — boolean — NOT NULL
- updated_at — timestamp(6)
- feature_requests — character — NOT NULL
- improvement_suggestions — character — NOT NULL
- status — character — NOT NULL
- member_id — bigint
- PROCESSING::character — varying
- RESOLVED::character — varying
- REJECTED::character — varying)::text)))
feedback_service_feature
- service_feature — character — NOT NULL
- feedback_id — bigint — NOT NULL
- MEAL_INFORMATION::character — varying
- ACADEMIC_SCHEDULE::character — varying
- TIMETABLE_AUTO_MANAGE::character — varying
- TEAM_RECRUITMENT::character — varying
- MARKETPLACE::character — varying
- CHATBOT_CAMPUS_INFO::character — varying)::text)))
marketplace_board
- id — bigint — NOT NULL
- created_at — timestamp(6)
- is_deleted — boolean — NOT NULL
- updated_at — timestamp(6)
- content — character — NOT NULL
- title — character — NOT NULL
- price — bigint — NOT NULL
- status — character — NOT NULL
- type — character — NOT NULL
- author — bigint — NOT NULL
- CLOSED::character — varying)::text)))
- BUY::character — varying)::text)))
marketplace_contact
- marketplace_id — bigint — NOT NULL
- created_at — timestamp(6)
- is_deleted — boolean — NOT NULL
- updated_at — timestamp(6)
- applicant — bigint — NOT NULL
marketplace_image
- url — character — NOT NULL
- created_at — timestamp(6)
- is_deleted — boolean — NOT NULL
- updated_at — timestamp(6)
- marketplace_board_id — bigint — NOT NULL
meal
- id — bigint — NOT NULL
- created_at — timestamp(6) — NOT NULL
- day_of_week — character — NOT NULL
- meal_date — date — NOT NULL
- meal_type — character — NOT NULL
- menu_items — text
- SPECIAL::character — varying)::text)))
member
- id — bigint — NOT NULL
- created_at — timestamp(6)
- is_deleted — boolean — NOT NULL
- updated_at — timestamp(6)
- email — character — NOT NULL
- nickname — character — NOT NULL
- password — character — NOT NULL
- student_id — character
- department_id — character
member_block
- blocker_id — bigint — NOT NULL
- blocked_member_id — bigint — NOT NULL
member_device
- id — bigint — NOT NULL
- device_token — character — NOT NULL
- member_device_type — character — NOT NULL
- member_id — bigint
- IOS::character — varying
- WEB::character — varying)::text)))
member_notification
- created_at — timestamp(6)
- is_deleted — boolean — NOT NULL
- updated_at — timestamp(6)
- is_read — boolean — NOT NULL
- member_id — bigint — NOT NULL
- notification_details_id — bigint — NOT NULL
member_role
- member_id — bigint — NOT NULL
- role_id — bigint — NOT NULL
member_schedule
- id — bigint — NOT NULL
- created_at — timestamp(6)
- is_deleted — boolean — NOT NULL
- updated_at — timestamp(6)
- end_at — timestamp(6) — NOT NULL
- location — character
- start_at — timestamp(6) — NOT NULL
- title — character — NOT NULL
- member_id — bigint — NOT NULL
notice
- notice_details_id — bigint — NOT NULL
- department_id — character — NOT NULL
notice_details
- id — bigint — NOT NULL
- created_at — date
- link — character
- title — character
- writer — character
notification_details
- id — bigint — NOT NULL
- created_at — timestamp(6)
- is_deleted — boolean — NOT NULL
- updated_at — timestamp(6)
- body — character — NOT NULL
- title — character — NOT NULL
- type — character — NOT NULL
- value — character — NOT NULL
- (NOTICE::character — varying)::text
- (RECRUITMENT_STUDY_APPLY::character — varying)::text
- (RECRUITMENT_PROJECT_APPLY::character — varying)::text
- (RECRUITMENT_TUTORING_APPLY::character — varying)::text
- (RECRUITMENT_STUDY_APPLY_RESULT::character — varying)::text
- (RECRUITMENT_PROJECT_APPLY_RESULT::character — varying)::text
- (RECRUITMENT_TUTORING_APPLY_RESULT::character — varying)::text
- (TIMETABLE::character — varying)::text
- (CALENDAR::character — varying)::text)))
official_schedule
- id — bigint — NOT NULL
- created_at — timestamp(6)
- is_deleted — boolean — NOT NULL
- updated_at — timestamp(6)
- end_at — date — NOT NULL
- start_at — date — NOT NULL
- title — character — NOT NULL
project_apply
- apply_time — timestamp(6) — NOT NULL
- introduction — character
- motivation — character
- status — character — NOT NULL
- project_board_id — bigint — NOT NULL
- member_id — bigint — NOT NULL
- PASS::character — varying
- FAIL::character — varying)::text)))
project_board
- id — bigint — NOT NULL
- created_at — timestamp(6)
- is_deleted — boolean — NOT NULL
- updated_at — timestamp(6)
- content — character — NOT NULL
- title — character — NOT NULL
- end_at — timestamp(6) — NOT NULL
- start_at — timestamp(6) — NOT NULL
- tags — character
- author — bigint — NOT NULL
- chat_room_id — character
project_board_department
- project_board_id — bigint — NOT NULL
- department_id — character — NOT NULL
report
- id — bigint — NOT NULL
- created_at — timestamp(6)
- is_deleted — boolean — NOT NULL
- updated_at — timestamp(6)
- description — character
- is_processed — boolean — NOT NULL
- report_reason — character — NOT NULL
- report_type — character — NOT NULL
- target_id — bigint — NOT NULL
- target_url — character — NOT NULL
- admin_id — bigint
- reporter_id — bigint — NOT NULL
- sanction_id — bigint
- target_member_id — bigint
- is_sanction_active — boolean — NOT NULL
- INAPPROPRIATE_CONTENT::character — varying
- HATE_SPEECH::character — varying
- FRAUD::character — varying
- PRIVACY_VIOLATION::character — varying
- COPYRIGHT_INFRINGEMENT::character — varying
- OTHER::character — varying)::text)))
- STUDY_BOARD::character — varying
- MARKETPLACE_BOARD::character — varying
- TUTORING_BOARD::character — varying
- MEMBER::character — varying)::text)))
restaurant
- id — bigint — NOT NULL
- created_at — timestamp(6)
- is_deleted — boolean — NOT NULL
- updated_at — timestamp(6)
- category — character — NOT NULL
- distance — double — NOT NULL
- external_map_id — character — NOT NULL
- name — character — NOT NULL
- place_url — character — NOT NULL
- CHINESE::character — varying
- JAPANESE::character — varying
- WESTERN::character — varying
- BUNSIK::character — varying
- FAST_FOOD::character — varying
- CAFE_DESSERT::character — varying)::text)))
restaurant_like
- member_id — bigint — NOT NULL
- restaurant_id — bigint — NOT NULL
restaurant_report
- id — bigint — NOT NULL
- created_at — timestamp(6)
- is_deleted — boolean — NOT NULL
- updated_at — timestamp(6)
- description — character
- reason — character — NOT NULL
- reporter_id — bigint — NOT NULL
- restaurant_id — bigint — NOT NULL
- WRONG_INFORMATION::character — varying
- OTHER::character — varying)::text)))
restaurant_tags
- restaurant_id — bigint — NOT NULL
- tag — character — NOT NULL
- DELICIOUS::character — varying
- GOOD_FOR_LUNCH::character — varying
- GOOD_FOR_SOLO::character — varying
- GOOD_VALUE::character — varying
- GOOD_FOR_GATHERING::character — varying
- GOOD_FOR_CONVERSATION::character — varying
- VARIOUS_MENU::character — varying)::text)))
role
- id — bigint — NOT NULL
- role_type — character
- USER::character — varying)::text)))
sanction
- id — bigint — NOT NULL
- created_at — timestamp(6)
- is_deleted — boolean — NOT NULL
- updated_at — timestamp(6)
- description — character
- end_date — timestamp(6) — NOT NULL
- is_active — boolean — NOT NULL
- reason — character — NOT NULL
- sanction_type — character — NOT NULL
- start_date — timestamp(6) — NOT NULL
- member_id — bigint — NOT NULL
- admin_id — bigint — NOT NULL
- report_id — bigint — NOT NULL
- target_member_id — bigint — NOT NULL
- TEMPORARY_BAN::character — varying
- PERMANENT_BAN::character — varying
- CONTENT_DELETION::character — varying)::text)))
study_apply
- apply_time — timestamp(6) — NOT NULL
- introduction — character
- motivation — character
- status — character — NOT NULL
- member_id — bigint — NOT NULL
- study_board_id — bigint — NOT NULL
- PASS::character — varying
- FAIL::character — varying)::text)))
study_board
- id — bigint — NOT NULL
- created_at — timestamp(6)
- is_deleted — boolean — NOT NULL
- updated_at — timestamp(6)
- content — character — NOT NULL
- title — character — NOT NULL
- end_at — timestamp(6) — NOT NULL
- start_at — timestamp(6) — NOT NULL
- tags — character
- author — bigint — NOT NULL
- chat_room_id — character
study_board_department
- department_id — character — NOT NULL
- study_board_id — bigint — NOT NULL
timetable
- id — bigint — NOT NULL
- created_at — timestamp(6)
- is_deleted — boolean — NOT NULL
- updated_at — timestamp(6)
- end_at — time(6) — NOT NULL
- location — character
- name — character — NOT NULL
- professor — character
- semester — character — NOT NULL
- start_at — time(6) — NOT NULL
- week — smallint — NOT NULL
- year — integer — NOT NULL
- member_id — bigint — NOT NULL
- SECOND::character — varying
- SUMMER::character — varying
- WINTER::character — varying)::text)))
tutoring_apply
- created_at — timestamp(6)
- is_deleted — boolean — NOT NULL
- updated_at — timestamp(6)
- apply_time — timestamp(6) — NOT NULL
- introduction — character
- motivation — character
- status — character — NOT NULL
- tutoring_board_id — bigint — NOT NULL
- member_id — bigint — NOT NULL
- PASS::character — varying
- FAIL::character — varying)::text)))
tutoring_board
- id — bigint — NOT NULL
- created_at — timestamp(6)
- is_deleted — boolean — NOT NULL
- updated_at — timestamp(6)
- content — character — NOT NULL
- title — character — NOT NULL
- end_at — timestamp(6) — NOT NULL
- start_at — timestamp(6) — NOT NULL
- tags — character
- author — bigint — NOT NULL
- department_id — character — NOT NULL
- chat_room_id — character