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