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