faily_erd

Tables (5)

Group

  • 그룹ID (group_id) — INT(11) — Primary key — NOT NULL
  • 그룹이름 (group_name) — VARCHAR(40)
  • 발급코드 (code) — VARCHAR(100)

Question

  • 질문ID (quest_id) — INT(11) — Primary key — NOT NULL
  • 질문내용 (question) — VARCHAR(100)
  • 날짜 (date)
  • 그룹ID (group_id) — INT(11) — Foreign key → Group.그룹ID — NOT NULL

User

  • 회원ID (user_id) — INT — Primary key — NOT NULL
  • 회원이름 (user_name) — VARCHAR(30)
  • 비밀번호 (passward) — VARCHAR(100)
  • 이메일 (mail) — VARCHAR(100)
  • 유형 (role) — INT(11)
  • 답변작성여부 (answer) — TINYINT(1)
  • 토큰ID (token_id) — INT(11)
  • 그룹ID (user_group_id) — INT(11) — Foreign key → Group.그룹ID — NOT NULL

answer (Answer)

  • 답변ID (answer_id) — INT(11) — Primary key — NOT NULL
  • 답변내용 (answer) — VARCHAR(30)
  • 그룹ID (group_id) — INT(11) — Foreign key → Group.그룹ID — NOT NULL
  • 회원ID (user_id) — INT — Foreign key → User.회원ID — NOT NULL

token (Token)

  • 토큰ID (token_id) — VARCHAR(40) — Primary key — NOT NULL
  • 만료시간 (expire_date) — datetime
  • 만료여부 (is_expired) — tinyint(1)
  • 생성시간 (create_date) — datetime
  • 마지막변경시간 (last_modified_date) — datetime
  • 회원ID (user_id) — INT — Foreign key → User.회원ID — NOT NULL