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