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