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