senty_erd
Tables (6)
anniversary
- id (Key) — text — Primary key — NOT NULL
- title (Field) — varchar(255)
- date (Field2) — datetime
- location (Field3) — varchar(255)
- create_at (Field4) — datetime
- update_at (Field5) — datetime
- memo (Field6) — text
friend
- id (Key) — text — Primary key — NOT NULL
- name (Field) — varchar(15)
- birthday (Field2) — char(4)
- memo (Field3) — text
- group_id (Key2) — bigint — Foreign key → friend_group.id — NOT NULL
- anniversary_id (Key3) — bigint — Foreign key → anniversary.id — NOT NULL
friend_group
- id (Key) — text — Primary key — NOT NULL
- name (Field) — varchar(20) — NOT NULL
- create_at (Field2) — datetime — NOT NULL
- update_at (Field4) — datetime — NOT NULL
- color (Field3) — char(10)
gift
- id (Key) — text — Primary key — NOT NULL
- date (Field) — datetime
- create_at (Field2) — datetime
- update_at (Field3) — datetime
- memo (Field4) — text
- img_url (Field5) — text
- mood (Field6) — text
- share_flag (Field7) — bit(1)
- isReceive (Field8) — bit(1)
- friend_id (Key2) — bigint — Foreign key → friend.id — NOT NULL
- category_id (Key3) — bigint — Foreign key → gift_category.id — NOT NULL
- anniversary_id (Key4) — bigint — Foreign key → anniversary.id — NOT NULL
gift_category
- id (Key) — text — Primary key — NOT NULL
- name (Field) — varchar(20)
- create_at (Field2) — datetime
- update_at (Field3) — datetime
gift_img (Untitled)
- name (Field) — text
- gift_id (Key2) — text — Foreign key → gift.id — NOT NULL