LG
Tables (6)
CheckedLog (Untitled)
- unique_id (고육 식별번호) — text — Primary key — NOT NULL
- user (유저) — User
- checked_at (확인 일자) — date
Comment (댓글)
- unique_id (고유 식별번호) — text — Primary key — NOT NULL
- user (작성자) — User
- contents (내용) — text
- depth (댓글깊이) — num
- created_at (생성일자) — date
- parent_comment (부모 댓글) — Comment
- post_state (댓글상태) — POST_STATE(ACTIVE, DELETE)
- withdrawal_at (삭제일자) — date
Device (FB토큰 저장용)
- Key — Primary key — NOT NULL
- device_token (디바이스 토큰) — text
- user_id (유저 unique_id) — text
Notification (아직 미정)
- unique_id (고유 식별번호) — text — Primary key — NOT NULL
- title (제목) — text
- contents (내용) — text
- send_user (송신자) — User(ADMIN)
- receive_user (수신자) — User(USER)
- created_at (발신일) — date
Post (공지)
- unique_id (고유 식별번호) — text — Primary key — NOT NULL
- user (작성자) — User
- title (제목) — text
- contents (내용) — text
- file (첨부파일) — file
- created_at (생성일자) — date
- post_state (공지상태) — POST_STATE(ACTIVE, DELETE)
- withdrawal_at (삭제일자) — date
User (유저)
- unique_id (고유 식별번호) — text — Primary key — NOT NULL
- email (이메일) — text
- init_password (기준 비밀번호) — text
- control_password (조작 비밀번호) — text
- user_type (유저 타입) — USER_TYPE
- user_state (유저 상태) — USER_STATE
- withdrawal_at (탈퇴 일자) — date
- created_at (생성 일자) — date
- first_name (이름) — text
- last_name (성) — text