Logic

Tables (18)

Account (계정)

  • Account_ID (계정 아이디) — Number — Primary key — NOT NULL
  • Name (이름) — varchar — NOT NULL
  • Nickname (닉네임) — varchar
  • Email (이메일) — varchar
  • Contact (연락처) — Number — NOT NULL
  • Point (포인트) — Number
  • Level (레벨) — Number
  • Exp (경험치) — Number
  • Autograph (서명) — Text — NOT NULL
  • Mailing_Service (메일링 서비스) — Boolean
  • Disclosure (정보 공개) — Boolean
  • Last_time (최종 접속 시간) — Datetime — YYYY-MM-DD-HH:MM
  • Online (접속중) — Boolean

Account_auth (Untitled2)

  • Auth_ID (인증 아이디) — Number — Primary key — NOT NULL
  • Account_ID (계정 아이디) — Number — Foreign key → Account.Account_ID — NOT NULL
  • Provider (인증 경로) — ENUM
  • Provider_User_ID (인증 ID) — varchar
  • Provider_Hash (인증 비밀번호) — varchar — NOT NULL
  • Created_Time (생성시간)

Board_post (게시판글)

  • Post_ID (게시글_ID) — Number — Primary key — NOT NULL
  • Account_ID (계정 아이디) — Number — Foreign key → Account.Account_ID — NOT NULL
  • Board_Type (게시판 구분) — ENUM
  • Title (제목) — Varchar
  • Content (본문) — Text
  • View_Count (조회수) — Number
  • Created_Time (작성시간) — Datetime
  • Updated_Time (수정시간) — Datetime

Comments (댓글)

  • Comments_ID (로직 댓글 ID) — Number — Primary key — NOT NULL
  • Account_ID (계정 아이디) — Number — Foreign key → Account.Account_ID — NOT NULL
  • Post_ID (게시글_ID) — Number — Foreign key → Board_post.Post_ID
  • Nono_ID (로직 ID) — Number — Foreign key → Nonogram.Nono_ID
  • Type (타입설정) — ENUM
  • Parents_ID (부모 댓글 ID) — Number — Foreign key → Comments.Comments_ID
  • Comments (댓글) — Text
  • Created_time (생성시간) — datetime
  • Updated_time (수정 시간) — datetime
  • Deleted (삭제됨) — boolean
  • Secret (비밀댓글) — boolean

Comments_reports (신고 댓글)

  • report_id (신고_ID) — Number — Primary key — NOT NULL
  • Account_ID (계정 아이디) — Number — Foreign key → Account.Account_ID — NOT NULL
  • Comments_ID (로직 댓글 ID) — Number — Foreign key → Comments.Comments_ID — NOT NULL
  • Created_time (생성시간) — datetime
  • Account_ID (계정 아이디2) — Number — Foreign key — NOT NULL

Contents_reactions (사용자 반응)

  • Reactions_list_ID (반응 리스트 ID) — Number — Primary key — NOT NULL
  • Nono_ID (로직 ID) — Number — Foreign key → Nonogram.Nono_ID — NOT NULL
  • Comments_ID (로직 댓글 ID) — Number — Foreign key → Comments.Comments_ID — NOT NULL

Follows (팔로우)

  • Follow_ID (팔로우_ID) — Number — Primary key — NOT NULL
  • Follower_ID (팔로워 아이디) — Number — Foreign key → Account.Account_ID — NOT NULL
  • Following_ID (팔로잉 아이디) — Number — Foreign key → Account.Account_ID — NOT NULL

Likes (좋아요)

  • Likes_ID (좋아요_ID) — Number — Primary key — NOT NULL
  • Target_ID (좋아요 대상) — Number — Foreign key → Account.Account_ID — NOT NULL
  • Liked_ID (좋아한 아이디) — Number — Foreign key → Account.Account_ID — NOT NULL

Message (메시지)

  • Message_ID (쪽지_ID) — Number — Primary key — NOT NULL
  • Sender_ID (송신자 아이디) — Number — Foreign key → Account.Account_ID — NOT NULL
  • Receiver_ID (수신자 아이디) — Number — Foreign key → Account.Account_ID — NOT NULL
  • Content (내용) — Text
  • Sent_Time (보낸 시간) — datetime — YYYY-MM-DD-HH:MM
  • Read_Time (받은 시간) — datetime — NOT NULL
  • Deleted (삭제됨) — boolean

My_Contents (내 게시글)

  • MyContents_ID (내글관리_ID) — Number — Primary key — NOT NULL
  • Account_ID (계정 아이디) — Number — Foreign key → Account.Account_ID — NOT NULL
  • Nono_ID (로직 ID) — Number — Foreign key → Nonogram.Nono_ID — NOT NULL

Nono_Complete (노노완성)

  • Complete_ID (완료ID) — Number — Primary key — NOT NULL
  • Account_ID (계정 아이디) — Number — Foreign key → Account.Account_ID — NOT NULL
  • Nono_ID (로직 ID) — Number — Foreign key → Nonogram.Nono_ID — NOT NULL
  • Start_time (시작시간) — datetime
  • Last_time (완료시간) — datetime
  • Total_seconds (누적시간) — number — 풀이시간(초)

Nono_Solving (노노푸는중)

  • Complete_ID (완료ID) — Number — Primary key — NOT NULL
  • Account_ID (계정 아이디) — Number — Foreign key → Account.Account_ID — NOT NULL
  • Nono_ID (로직 ID) — Number — Foreign key → Nonogram.Nono_ID — NOT NULL
  • Start_time (시작시간) — datetime
  • Last_time (완료시간) — datetime
  • Total_seconds (누적시간) — number — 풀이시간(초)

Nono_View (노노그램 뷰)

  • View_ID (뷰_ID) — Number — Primary key — NOT NULL
  • Account_ID (계정 아이디) — Number — Foreign key → Account.Account_ID — NOT NULL
  • Nono_ID (로직 ID) — Number — Foreign key → Nonogram.Nono_ID — NOT NULL
  • View_Time (생성시간) — Datetime

Nonogram (노노그램)

  • Nono_ID (로직 ID) — Number — Primary key — NOT NULL
  • Account_ID (계정 아이디) — Number — Foreign key → Account.Account_ID — NOT NULL
  • Title (제목) — varchar
  • Size (크기) — Number
  • average_time (평균 기록) — time
  • Contents (본문글) — Text
  • Status (상태) — ENUM

Nonogram_View (페이지 조회용)

  • Nono_ID (로직 ID) — Number — Foreign key → Nonogram.Nono_ID — NOT NULL
  • View_count (조회수) — Number
  • Complete_count (완료수) — Number
  • Recommend_count (추천수) — Number
  • Updated_time (집계시간) — Number

Recommends (추천)

  • Recommends_ID (추천_ID) — Number — Primary key — NOT NULL
  • Account_ID (계정 아이디) — Number — Foreign key → Account.Account_ID — NOT NULL
  • Nono_ID (로직 ID) — Number — Foreign key → Nonogram.Nono_ID — NOT NULL
  • Recommend_time (추천한시간) — Datetime

Saved (저장된로직)

  • Saved_id (저장한 아이디) — Number — Primary key — NOT NULL
  • Account_ID (계정 아이디) — Number — Foreign key → Account.Account_ID — NOT NULL
  • Nono_ID (로직 ID) — Number — Foreign key → Nonogram.Nono_ID — NOT NULL
  • Saved_time (저장한 시간) — Datetime

Scrap (스크랩)

  • Scrap_ID (스크랩_ID) — Number — Primary key — NOT NULL
  • Account_ID (계정 아이디) — Number — Foreign key → Account.Account_ID — NOT NULL
  • Nono_ID (로직 ID) — Number — Foreign key → Nonogram.Nono_ID — NOT NULL
  • Created_Time (생성시간) — datetime
  • Scraped_at (스크랩한게시판) — varchar