ERD/v1

Tables (6)

User (users)

  • id (Key) — bigint — Primary key — NOT NULL
  • profile_nickname (Field2) — varchar(20)
  • profile_image (Field3) — varchar(250)
  • friends (Field11)

frend (frends)

  • Key — bigint — Primary key — NOT NULL
  • profile_nickname (Field)

group (Groups)

  • Key — bigint — Primary key — NOT NULL
  • group_leader (Field)
  • group_name (Field2)
  • create_by (Field4)

group_mark (marks(place))

  • Key — bigint — Primary key — NOT NULL
  • group_id (Field4)
  • place_name (Field)
  • latitude (Field2)
  • longitude (Field3)

member (Members)

  • Key — bigint — Primary key — NOT NULL
  • group_id (Field)
  • member_id (Field2)

memo

  • Key — bigint — Primary key — NOT NULL
  • group_mark_id (Field)
  • memo_text (Field2) — varchar(250)
  • created_by (Field3) — date
  • modified_by (Field4) — date