3차프로젝트_ERD
테이블 (8)
available_date_time
- id — BIGINT
- time_block_id — BIGINT — 외래 키 → time_block.id — NOT NULL
- meeting_id — BIGINT — 외래 키 → meeting.id — NOT NULL
- date — DATE — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- modified_at — TIMESTAMP — NOT NULL
available_time
- id — BIGINT
- available_date_time_id — BIGINT — 외래 키 → available_date_time.id — NOT NULL
- time_block_id — BIGINT — 외래 키 → time_block.id — NOT NULL
- meeting_id — BIGINT — 외래 키 → meeting.id — NOT NULL
- participant_id — BIGINT — 외래 키 → participant.id — NOT NULL
- time — TIME — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- modified_at — TIMESTAMP — NOT NULL
meeting
- id — BIGINT
- member_id — BIGINT — 외래 키 → member.id — NOT NULL
- title — VARCHAR(255) — NOT NULL
- category — VARCHAR(100) — NOT NULL
- duration — INT — NOT NULL
- random_url — VARCHAR(255) — NOT NULL
- status — VARCHAR(50) — NOT NULL
- local_time — VARCHAR(100)
- confirmed_date — DATE
- confirmed_time — TIME
- created_at — TIMESTAMP — NOT NULL
- modified_at — TIMESTAMP — NOT NULL
meetings_date
- id — BIGINT
- meeting_id — BIGINT — 외래 키 → meeting.id — NOT NULL
- date — DATE — NOT NULL
- created_by — VARCHAR(255) — NOT NULL
- modified_by — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- modified_at — TIMESTAMP — NOT NULL
member
- id — BIGINT
- email — VARCHAR(255) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(255) — NOT NULL
- timezone — VARCHAR(50) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- modified_at — TIMESTAMP — NOT NULL
participant
- id — BIGINT
- meeting_id — BIGINT — 외래 키 → meeting.id — NOT NULL
- guest_name — VARCHAR(100) — NOT NULL
- guest_password — VARCHAR(100) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- modified_at — TIMESTAMP — NOT NULL
time_block
- id — BIGINT
- meeting_id — BIGINT — 외래 키 → meeting.id — NOT NULL
- participant_id — BIGINT — 외래 키 → participant.id
- created_at — TIMESTAMP — NOT NULL
- modified_at — TIMESTAMP — NOT NULL
time_table
- id — BIGINT
- meeting_id — BIGINT — 외래 키 → meeting.id — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- modified_at — TIMESTAMP — NOT NULL