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