moamoa

Tables (19)

APPLY

  • apply_no — BIGINT — Primary key — NOT NULL
  • project_no (apply_receive) — BIGINT — Foreign key → PROJECT.project_no — NOT NULL
  • user_no (apply_send) — BIGINT — Foreign key → USER.user_no — NOT NULL — Auto_Increment
  • apply_time — TIMESTAMP

AREA

  • area_no — BIGINT — Primary key — NOT NULL
  • area_name — VARCHAR(20) — NOT NULL

CATEGORY

  • category_no — BIGINT — Primary key — NOT NULL
  • category_name — VARCHAR(20) — NOT NULL

CHATROOM

  • chatroom_no — BIGINT — Primary key — NOT NULL
  • chatroom_title — VARCHAR(20) — NOT NULL
  • user_no (chatroom_user_one) — BIGINT — Foreign key → USER.user_no — NOT NULL — Auto_Increment
  • user_no (chatroom_user_two) — BIGINT — Foreign key → USER.user_no — NOT NULL — Auto_Increment

MESSAGE

  • message_no — BIGINT — Primary key — NOT NULL
  • chatroom_no — BIGINT — Foreign key → CHATROOM.chatroom_no — NOT NULL
  • user_no (message_sender) — BIGINT — Foreign key → USER.user_no — NOT NULL — Auto_Increment
  • message_text — TEXT — NOT NULL
  • message_date — TIMESTAMP — NOT NULL

OFFER

  • offer_no — BIGINT — Primary key — NOT NULL
  • project_no (offer_send) — BIGINT — Foreign key → PROJECT.project_no — NOT NULL
  • user_no (offer_receive) — BIGINT — Foreign key → USER.user_no — NOT NULL — Auto_Increment
  • offer_time — TIMESTAMP

PROFILE

  • user_no (profile_no) — BIGINT — Foreign key → USER.user_no — NOT NULL — Auto_Increment
  • profile_nickname — VARCHAR(20) — NOT NULL
  • profile_pjt_state — TINYINT — 프로젝트 검색 온/오프 0: off 1: on
  • profile_study_state — TINYINT — 스터디 검색 온/오프 0: off 1: on
  • profile_img — BLOB
  • profile_context — TEXT

PROJECT

  • project_no — BIGINT — Primary key — NOT NULL
  • project_title — VARCHAR(20) — NOT NULL
  • project_contents — TEXT
  • project_img — VARCHAR(20) — 이미지 경로
  • project_onoffline — TINYINT — 온오프라인 유무 0: off 1: on
  • project_hit — INT — NOT NULL
  • project_cnt_offer — INT — NOT NULL
  • project_category (projectcategory) — VARCHAR(100) — NOT NULL
  • project_start_date — DATE — NOT NULL
  • project_end_date — DATE
  • project_create_date — DATE — NOT NULL

PROJECT_AREA

  • prokect_area_no — BIGINT — Primary key — NOT NULL
  • project_no — BIGINT — Foreign key → PROJECT.project_no — NOT NULL
  • area_no — BIGINT — Foreign key → AREA.area_no — NOT NULL

PROJECT_TECH_STACK

  • project_stack_no — BIGINT — Primary key — NOT NULL
  • project_no — BIGINT — Foreign key → PROJECT.project_no — NOT NULL
  • tech_stack_no — BIGINT — Foreign key → TECH_STACK.tech_stack_no — NOT NULL

REVIEW

  • review_no — BIGINT — Primary key — NOT NULL
  • user_no (review_receive) — BIGINT — Foreign key → USER.user_no — NOT NULL — Auto_Increment
  • user_no (review_send) — BIGINT — Foreign key → USER.user_no — NOT NULL — Auto_Increment
  • review_context — TEXT — NOT NULL
  • review_time — TIMESTAMP — NOT NULL

SIDEPJT

  • sidepjt_no — BIGINT — Primary key — NOT NULL
  • user_no — BIGINT — Foreign key → USER.user_no — NOT NULL — Auto_Increment
  • sidepjt_name — VARCHAR(20) — NOT NULL
  • sidepjt_context — VARCHAR(20) — NOT NULL
  • sidepjt_year — YEAR

SIDEPJT_TECH_STACK

  • sidepjt_tech_stack_no — BIGINT — Primary key — NOT NULL
  • sidepjt_no — BIGINT — Foreign key → SIDEPJT.sidepjt_no — NOT NULL
  • tech_stack_no — BIGINT — Foreign key → TECH_STACK.tech_stack_no — NOT NULL

TEAM

  • team_no — BIGINT — Foreign key → PROJECT.project_no — NOT NULL
  • user_no — BIGINT — Foreign key → USER.user_no — NOT NULL — Auto_Increment
  • team_leader — TINYINT — NOT NULL — 팀장 유무 0: 무 1: 유

TECH_STACK

  • tech_stack_no — BIGINT — Primary key — NOT NULL
  • tech_stack_name — VARCHAR(20) — NOT NULL
  • tech_stack_logo

TECH_STACK_CATEGORY

  • tech_stack_category_no — BIGINT — Primary key — NOT NULL
  • category_no — BIGINT — Foreign key → CATEGORY.category_no — NOT NULL
  • tech_stack_no — BIGINT — Foreign key → TECH_STACK.tech_stack_no — NOT NULL

USER

  • user_no — BIGINT — Primary key — NOT NULL — Auto_Increment
  • user_email — BIGINT — NOT NULL — email
  • user_pwd — VARCHAR(20) — NOT NULL
  • user_refresh_token (user_token) — VARCHAR(20) — NOT NULL
  • user_join_date — DATE

USER_AREA

  • user_area_no — Primary key — NOT NULL
  • user_no — BIGINT — Foreign key → USER.user_no — NOT NULL — Auto_Increment
  • area_no — BIGINT — Foreign key → AREA.area_no — NOT NULL

USER_TECH_STACK

  • user_tech_stack_no — BIGINT — Primary key — NOT NULL
  • user_no — BIGINT — Foreign key → USER.user_no — NOT NULL — Auto_Increment
  • tech_stack_no — BIGINT — Foreign key → TECH_STACK.tech_stack_no — NOT NULL