pdicle

Tables (10)

board

  • board_id — BIGINT — Primary key — NOT NULL
  • writer_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • board_type — VARCHAR(30)
  • title — VARCHAR(200)
  • content — TEXT
  • approval_status — VARCHAR(20)
  • post_status — VARCHAR(20)
  • created_at — DATETIME
  • updated_at — DATETIME

calendar_event

  • event_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • title — VARCHAR(200)
  • description — TEXT
  • start_at — DATETIME
  • end_at — DATETIME
  • event_type — VARCHAR(30)
  • created_at — DATETIME
  • updated_at — DATETIME

coffee_chat

  • coffeechat_id — BIGINT — Primary key — NOT NULL
  • writer_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • title — VARCHAR(200)
  • content — TEXT
  • meeting_date — DATETIME
  • meeting_place — VARCHAR(255)
  • capacity — INT
  • status — VARCHAR(20)
  • created_at — DATETIME
  • updated_at — DATETIME

coffee_chat_application

  • application_id — BIGINT — Primary key — NOT NULL
  • coffeechat_id — BIGINT — Foreign key → coffee_chat.coffeechat_id — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • applied_at — DATETIME
  • payment_status — VARCHAR(20)
  • participation_status — VARCHAR(20)
  • cancelled_at — DATETIME

comments

  • comment_id — BIGINT — Primary key — NOT NULL
  • board_id — BIGINT — Foreign key → board.board_id — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • parent_comment_id — BIGINT — Foreign key → comments.comment_id
  • content — TEXT
  • created_at — DATETIME
  • updated_at — DATETIME

notification

  • notification_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • notification_type — VARCHAR(30)
  • title — VARCHAR(100)
  • message — TEXT
  • target_type — VARCHAR(30)
  • target_id — BIGINT
  • is_read — BOOLEAN
  • created_at — DATETIME

project

  • project_id — BIGINT — Primary key — NOT NULL
  • writer_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • title — VARCHAR(200)
  • content — TEXT
  • project_start — DATE
  • project_end — DATE
  • recruitment_status — VARCHAR(20)
  • approval_status — VARCHAR(20)
  • created_at — DATETIME
  • updated_at — DATETIME

project_application

  • application_id — BIGINT — Primary key — NOT NULL
  • project_id — BIGINT — Foreign key → project.project_id — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • apply_role — VARCHAR(30)
  • introduction — VARCHAR(500)
  • applied_at — DATETIME
  • result_status — VARCHAR(20)
  • cancelled_at — DATETIME
  • reviewed_at — DATETIME

project_member

  • project_member_id — BIGINT — Primary key — NOT NULL
  • project_id — BIGINT — Foreign key → project.project_id — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • role — VARCHAR(30)
  • joined_at — DATETIME

users

  • user_id — BIGINT — Primary key — NOT NULL
  • kakao_id — VARCHAR(100) — NOT NULL
  • nickname — VARCHAR(30) — NOT NULL
  • profile_image — VARCHAR(500)
  • introduction — TEXT
  • specialty — VARCHAR(100)
  • career_year — INT
  • job — VARCHAR(30)
  • activity_type — VARCHAR(30)
  • interest_field — VARCHAR(100)
  • purpose — VARCHAR(100)
  • gender — VARCHAR(10)
  • phone — VARCHAR(20)
  • email — VARCHAR(100)
  • age_group — VARCHAR(20)
  • region — VARCHAR(50)
  • depositor_name — VARCHAR(30)
  • referrer — VARCHAR(30)
  • created_at — DATETIME
  • updated_at — DATETIME
  • deleted_at — DATETIME