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