Spark ERD

Tables (10)

entry

  • Entry ID (entry_id) — INT — Primary key — NOT NULL
  • User ID (user_id) — INT — Foreign key → user.User ID — NOT NULL
  • Room ID (room_id) — INT — Foreign key → room.Room ID — NOT NULL
  • Rest (rest) — INT
  • Purpose (priv_purpose) — Varchar(255)
  • Join At (join_at) — timestamp
  • Is Out (is_out) — boolean
  • Out At (out_at) — timestamp
  • Thumbnail Img (thumbnail_img) — Text
  • Moment detail (moment_detail) — varchar(30)
  • Moment ID (moment_id) — INT — Foreign key → purpose_moment.Moment ID — NOT NULL
  • Is Kicked (is_kicked) — boolean

like

  • Like ID (like_id) — INT — Primary key — NOT NULL
  • User ID (Sender) — INT — Foreign key → user.User ID — NOT NULL
  • Record ID (record_id) — INT — Foreign key → record.Record ID — NOT NULL

notice_active

  • Notice ID (notice_id) — INT — Primary key — NOT NULL
  • Receiver (receiver) — INT — Foreign key → user.User ID — NOT NULL
  • Sender (sender) — INT — Foreign key → user.User ID — NOT NULL
  • Action (action) — Varchar(50)
  • Is Spark (is_spark) — boolean
  • Spark ID (spark_id) — INT — Foreign key → spark.Spark ID — NOT NULL
  • Is Read (is_read) — boolean
  • Read At (read_at) — Timestamp
  • Is Deleted (is_deleted) — boolean
  • Deleted At (deleted_at) — Timestamp

notice_service

  • Notice ID (notice_id) — INT — Primary key — NOT NULL
  • Record ID (record_id) — INT — Foreign key → record.Record ID — NOT NULL
  • Is Read (is_read) — boolean
  • Read At (read_at) — Timestamp
  • Is Deleted (is_deleted) — boolean
  • Deleted At (deleted_at) — Timestamp

purpose_moment

  • Moment ID (moment_id) — INT — Primary key — NOT NULL
  • Moment (moment) — Varchar(10)

record

  • Record ID (record_id) — INT — Primary key — NOT NULL
  • Entry ID (entry_id) — INT — Foreign key → entry.Entry ID — NOT NULL
  • Record Status (status_id) — INT — Foreign key → record_status.Status ID — NOT NULL
  • Date (date) — timestamp
  • Day (day) — INT
  • Received Spark (received_spark) — INT
  • Is Certified (is_certified) — boolean
  • Certification Img (certifying_img) — Text — NOT NULL
  • Certifying At (certifying_at) — timestamp
  • Timer Record (timer_record) — Varchar(40)

record_status

  • Status ID (status_id) — INT — Primary key — NOT NULL
  • Status Name (status_name) — Varchar(50)

room

  • Room ID (room_id) — INT — Primary key — NOT NULL
  • Room Name (room_name) — Varchar(100)
  • Code (code) — Varchar(100)
  • Created By (creater) — INT — Foreign key → user.User ID — NOT NULL
  • Is Started (is_started) — boolean
  • Is deleted (is_deleted) — boolean
  • Is Timer (is_timer) — boolean
  • Create Date (created_at) — Timestamp
  • Start Date (start_at) — Timestamp
  • End Date (end_at) — Timestamp
  • Deleted At (deleted_at) — Timestamp
  • Life (life) — INT
  • Member Number (member) — INT

spark

  • Spark ID (spark_id) — INT — Primary key — NOT NULL
  • Spark Content (content) — Varchar(255)
  • Created At (created_at) — timestamp
  • Sender (sender) — INT — Foreign key → user.User ID — NOT NULL
  • Record (record) — INT — Foreign key → record.Record ID — NOT NULL

user

  • User ID (user_id) — INT — Primary key — NOT NULL
  • Social ID (social_id) — Varchar(100)
  • Nickname (nickname) — Varchar(255)
  • Update Date (updated_at) — Timestamp
  • Is deleted (is_deleted) — boolean
  • Profile Img (profile_img) — Text