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