digitalTalk

Tables (4)

accessory (Untitled4)

  • accessory_id — bigint — Primary key — NOT NULL
  • name — varchar
  • created_at — timestamp
  • updated_at — timestamp
  • deleted_at — timestamp
  • member_id — bigint — Foreign key → member.member_id — NOT NULL

member (Untitled)

  • member_id — bigint — Primary key — NOT NULL
  • name — varchar
  • email — varchar
  • phone_number — varchar
  • nickname — varchar
  • created_at — timestamp
  • updated_at — timestatmp
  • deleted_at — timestamp

member_picture (Untitled3)

  • member_picture_id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • member_id — bigint — Foreign key → member.member_id — NOT NULL
  • picture_id (picture_id2) — bigint — Foreign key → picture.picture_id — NOT NULL

picture (Untitled2)

  • picture_id — bigint — Primary key — NOT NULL
  • title — varchar
  • picture_url — varchar
  • is_default — boolean
  • created_at — timestamp
  • updated_at — timestamp
  • deleted_at — timestamp
  • accessory_id — bigint — Foreign key → accessory.accessory_id — NOT NULL