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