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