lambda-yumi
Tables (5)
Group
- group_id (Key) — int(autocremental) — Primary key — NOT NULL
- create_at (생성일시) — DateTime(TimeStamp)
- name (그룹명) — String
- description (그룹설명) — int
- userCnt (회원수) — Type
User
- user_id (Key) — int(autocremental) — Primary key — NOT NULL
- created_at (가입날짜) — DateTime(TimeStamp)
- social (소셜로그인) — int(autocremental)
- email (이메일) — string
- password (비밀번호) — string
- id (아이디) — string
- url (프로필사진 주소) — string
UserGroup
- group_id (Key) — int(autocremental) — Primary key — NOT NULL
- create_at (가입일시) — DateTime
- user_id (Key2) — int(autocremental) — Foreign key → User.user_id — NOT NULL
- group_id (Key3) — int(autocremental) — Foreign key → Group.group_id — NOT NULL
vote (Untitled2)
- vote_id (Key) — String — Primary key — NOT NULL
- title (투표제목) — String
- create_at (생성날짜) — Datetime
- start (시작날짜) — Datetime
- end (종료날짜) — Datetime
- create_user (만든사람) — user_id
- group_id (Key2) — int(autocremental) — Foreign key → Group.group_id — NOT NULL
voteInfo (Untitled4)
- vote_id (Key) — String — Foreign key → vote.vote_id — NOT NULL
- Field