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