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