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