khack

Tables (20)

alarm

  • id — bigint — Primary key — NOT NULL
  • is_read — boolean — NOT NULL
  • message — character
  • timestamp — timestamp
  • receiver_user_id — bigint
  • sender_user_id — bigint

authority

  • id — bigint — Primary key — NOT NULL
  • name — character
  • member — bigint

chatroom

  • room_id — character — Primary key — NOT NULL
  • create_date — timestamp
  • is_project_started — integer
  • project_id — bigint
  • room_name — character

chatroom_participants

  • sequence — integer — Primary key — NOT NULL
  • enter_date — timestamp
  • room_id — character
  • user_id — integer — NOT NULL

friend

  • id — bigint — Primary key — NOT NULL
  • status — character
  • friend_profile_id — bigint
  • profile_id — bigint

match

  • match_id — bigint — Primary key — NOT NULL
  • match_success — character
  • matching_date — timestamp
  • matching_request — character
  • project_id — bigint
  • uid1 — bigint
  • uid2 — bigint

member

  • id — bigint — Primary key — NOT NULL
  • account — character
  • birthday — date
  • email — character
  • gender — character
  • major — character
  • name — character
  • password — character
  • phone_number — character
  • token — character

message

  • sequence — integer — Primary key — NOT NULL
  • message — character
  • room_id — character
  • send_date — date
  • sender — integer — NOT NULL
  • sender_name — character

peer_review

  • peer_review_id — integer — Primary key — NOT NULL
  • current_reviewer_number — integer — NOT NULL
  • is_reviewed — boolean
  • max_reviewer_number — integer — NOT NULL
  • peer_review_score — integer — NOT NULL
  • project_id — bigint
  • user_id — bigint

profile

  • id — bigint — Primary key — NOT NULL
  • instruction — character
  • nickname — character
  • peer — integer — NOT NULL
  • personal_link — character
  • photo — character
  • project_experience — boolean — NOT NULL
  • promise — character
  • role — character
  • member_id — bigint

project

  • project_id — bigint — Primary key — NOT NULL
  • creation_date — date
  • number_of_members — integer — NOT NULL
  • project_deadline_date — date
  • project_introduction — character
  • project_manager — bigint
  • project_name — character
  • project_one_line_introduction — character
  • project_start_date — date
  • project_started — boolean — NOT NULL
  • views — bigint
  • project_finished — boolean — NOT NULL

project_member_profiles

  • project_id — bigint — NOT NULL
  • profile_id — bigint — NOT NULL

project_profile_card

  • project_id — integer — Primary key — NOT NULL
  • project_introduce — character
  • project_name — character
  • project_period — timestamp
  • project_status — boolean
  • room_id — integer

team

  • team_id — bigint — Primary key — NOT NULL
  • creation_date — date
  • number_of_members — integer — NOT NULL
  • project_started — boolean — NOT NULL
  • team_description — character
  • team_name — character

team_member_profiles

  • team_id — bigint — NOT NULL
  • profile_id — bigint — NOT NULL

technology

  • id — bigint — Primary key — NOT NULL
  • name — character

technology_level

  • id — bigint — Primary key — NOT NULL
  • level — integer — NOT NULL
  • member_account — bigint
  • profile_id — bigint
  • technology_id — bigint

todo

  • todo_id — bigint — Primary key — NOT NULL
  • content — character
  • project_id — integer
  • status — boolean — NOT NULL
  • title — character
  • todo_type — character
  • user_id — bigint

vote

  • vote_id — integer — Primary key — NOT NULL
  • end_date — date — NOT NULL
  • room_id — character — NOT NULL
  • start_date — date — NOT NULL
  • total_vote_number — integer — NOT NULL
  • vote_status — boolean — NOT NULL
  • vote_title — character — NOT NULL

vote_contents

  • vote_contents_id — integer — Primary key — NOT NULL
  • content — character — NOT NULL
  • vote_id — integer — NOT NULL
  • vote_num — integer — NOT NULL