FamilyEvents

Tables (7)

Account

  • ID (id) — BIGINT(20) — Primary key — NOT NULL
  • Email (email) — VARCHAR(255) — NOT NULL
  • Nickname (nickname) — VARCHAR(64) — NOT NULL
  • Password (password) — VARCHAR(60) — NOT NULL
  • EmailVerified (emailverified) — TINYINT(1) — NOT NULL — default 0 verified 1
  • EmailCheckToken (emailchecktoken) — VARCHAR(255)
  • JoinedAt (joinedat) — DATETIME — NOT NULL
  • Bio (bio) — VARCHAR(255)
  • Age (age) — TINYINT
  • ProfileImage (profileImage) — TEXT
  • emailCheckTokenGeneratedAt — DATETIME

Board (board)

  • Id (id) — INT(11) — Primary key — NOT NULL
  • ID (id2) — BIGINT(20) — Foreign key → Account.ID — NOT NULL

Events (events)

  • Id (id) — INT(11) — Primary key — NOT NULL
  • account_id — BIGINT(20) — Foreign key → Account.ID — NOT NULL
  • category_id — INT(11) — Foreign key → event_category.Id — NOT NULL
  • events_cost_id — INT(11) — Foreign key → Events_Cost.Id — NOT NULL
  • relationship_id — INT(11) — Foreign key → Relationship_category.Id — NOT NULL
  • date — LOCALDATETIME — NOT NULL
  • memo — VARCHAR(255) — NOT NULL

Events_Cost (events_cost)

  • Id (id) — INT(11) — Primary key — NOT NULL
  • Cost_type (cost_type) — Boolean — NOT NULL — True-> 수입/False->지출
  • Price (price) — INT(11) — NOT NULL

Relationship

  • Id (id) — INT(11) — Primary key — NOT NULL
  • account_id — BIGINT(20) — Foreign key → Account.ID — NOT NULL
  • relationship_category_id — INT(11) — Foreign key → Relationship_category.Id — NOT NULL
  • name — VARCHAR(50) — NOT NULL — 아무개
  • tel — VARCHAR(255)
  • email — VARCHAR(255)

Relationship_category (relationship_category)

  • Id (id) — INT(11) — Primary key — NOT NULL
  • relation — VARCHAR(50) — NOT NULL — 가족,친구,지인 등의 관계

event_category (events_category)

  • Id (id) — INT(11) — Primary key — NOT NULL
  • ID (id2) — BIGINT(20) — Foreign key → Account.ID — NOT NULL
  • Name (name) — VARCHAR(50) — NOT NULL