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