gotgong

Tables (8)

Q&A

  • user_id — Integer — Foreign key → room.user_id — NOT NULL
  • cord (방 코드2) — Integer — Foreign key → room.cord — NOT NULL
  • user_id (user_id2) — Integer — Foreign key → room.user_id — NOT NULL
  • Key — Foreign key → room.Key — NOT NULL
  • title (제목) — String
  • content (내용) — String
  • time (작성일시) — Datetime
  • writer (작성자) — String

performed (수행)

  • user_id — Integer — Foreign key → plan.user_id — NOT NULL
  • cord (방 코드2) — Integer — Foreign key → plan.cord — NOT NULL
  • user_id (user_id2) — Integer — Foreign key → plan.user_id — NOT NULL
  • Key — Foreign key → plan.Key — NOT NULL
  • performed (수행완료) — Bool
  • content (내용) — Text, file

plan (계획)

  • user_id — Integer — Foreign key → room.user_id — NOT NULL
  • cord (방 코드2) — Integer — Foreign key → room.cord — NOT NULL
  • user_id (user_id2) — Integer — Foreign key → room.user_id — NOT NULL
  • Key — Foreign key → room.Key — NOT NULL
  • week num (n주차) — Integer
  • content (내용) — String
  • dislike (평가) — Integer

post (게시물)

  • user_id — Integer — Foreign key → room.user_id — NOT NULL
  • cord (방 코드2) — Integer — Foreign key → room.cord — NOT NULL
  • user_id (user_id2) — Integer — Foreign key → room.user_id — NOT NULL
  • Key — Foreign key → room.Key — NOT NULL
  • title (제목) — String
  • content (내용) — String
  • time (작성일시) — Datetime
  • writer (작성자) — String

room (방)

  • Key — Primary key — NOT NULL
  • user_id — Integer — Foreign key → user.user_id — NOT NULL
  • cord (방 코드2) — Integer — Foreign key — NOT NULL
  • user_id (user_id2) — Integer — Foreign key → user.user_id — NOT NULL
  • room_name (스터디방 이름) — String
  • leader (방장) — String
  • member_num (멤버수) — Integer
  • freinds (그룹멤버수) — String
  • rule (룰) — Integer
  • fee (참가비) — Integer
  • endercode (방코드) — Integer

schedule (스터디 기간)

  • user_id — Integer — Foreign key → room.user_id — NOT NULL
  • cord (방 코드2) — Integer — Foreign key → room.cord — NOT NULL
  • user_id (user_id2) — Integer — Foreign key → room.user_id — NOT NULL
  • Key — Foreign key → room.Key — NOT NULL
  • total_week (기간) — Integer
  • current_week (현재 주차) — Integer
  • start_day (시작 요일) — Integer
  • today (오늘요일) — Date

unperformed (미수행)

  • user_id — Integer — Foreign key → plan.user_id — NOT NULL
  • cord (방 코드2) — Integer — Foreign key → plan.cord — NOT NULL
  • user_id (user_id2) — Integer — Foreign key → plan.user_id — NOT NULL
  • Key — Foreign key → plan.Key — NOT NULL
  • content (내용) — String
  • dislike (평가) — Integer

user (사용자)

  • user_id — Integer — Primary key — NOT NULL
  • user_id (user_id2) — Integer — Foreign key → room.user_id — NOT NULL
  • Key — Foreign key → room.Key — NOT NULL
  • username (사용자 이름) — String
  • userid (사용자 아이디) — String
  • password (비밀번호) — String
  • email (이메일) — String