1234
Tables (7)
comment
- comment_id — BIGINT — Primary key — NOT NULL
- project_id — BIGINT — Foreign key → project.project_id — NOT NULL
- user_id — BIGINT — Foreign key → user.user_id — NOT NULL
- content — TEXT
- create_time — DATE
- update_time — DATE
project
- project_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → user.user_id — NOT NULL
- use_user_id — BIGINT — Foreign key → user.use_user_id — NOT NULL
- recruitment_type — ENUM("STUDY", "PROJECT")
- recruitment_number — INT
- is_online — BOOLEAN
- period — INT
- expected_start_date — DATE
- contact — VARCHAR(255)
- create_date — DATE
- update_date — DATE
- is_recruitment — BOOLEAN
- view — VARCHAR(255)
- address — VARCHAR(255)
project_stack
- project_stack_id — BIGINT — Primary key — NOT NULL — auto_increment
- project_id — BIGINT — Foreign key → project.project_id — NOT NULL
- stack_id — BIGINT — Foreign key → stack.stack_id — NOT NULL
stack
- stack_id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(255)
- classification — ENUM("FRONT", "BACK", "MOBILE", "ETC")
- image — VARCHAR(255)
use_user
- use_user_id — BIGINT — Primary key — NOT NULL
- project_id — BIGINT — Foreign key → project.project_id — NOT NULL
- recuitment_date — DATE
- 멘토님 — 질문`
- nick_name — VARCHAR(255)
user
- user_id — BIGINT — Primary key — NOT NULL
- use_user_id — BIGINT — Foreign key → use_user.use_user_id — NOT NULL
- project_id — BIGINT — Foreign key → use_user.project_id — NOT NULL
- name — VARCHAR(255)
- nick_name — VARCHAR(255)
- image — VARCHAR(255)
- email — VARCHAR(255)
- phone — VARCHAR(255)
- profile_link — VARCHAR(255)
- is_withdrawal — BOOLEAN
- date_withdrawal — DATE
- Field — VARCHAR(255)
user_stack
- user_stack_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → user.user_id — NOT NULL
- stack_id — BIGINT — Foreign key → stack.stack_id — NOT NULL