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