Dsm Team Organization System
Tables (7)
Alarm (알람)
- user_ID (학번) — INTEGER — Foreign key → User.user_ID — NOT NULL
- contents (내용) — VARCHAR(225) — NOT NULL
- date (날짜) — DATE — NOT NULL
Post (게시물)
- post_ID (글 번호) — INTEGER — Primary key — NOT NULL — AI
- writer_ID (학번) — INTEGER — Foreign key → User.user_ID — NOT NULL
- cartegory_ID (카테고리 아이디) — INTEGER — Foreign key → cartegory.cartegory_ID — NOT NULL
- title (제목) — VARCHAR(50) — NOT NULL
- content (내용) — VARCHAR(225) — NOT NULL
- is_finished (종료 여부) — Boolean — NOT NULL
Reqest (참가 요청)
- user_ID (학번) — INTEGER — Foreign key → User.user_ID — NOT NULL
- post_ID (글 번호) — INTEGER — Foreign key → Post.post_ID — NOT NULL — AI
- is_allowed (수락 여부) — BOOLEAN
- Req_Date (요청 날짜) — DATE
User (유저)
- user_ID (학번) — INTEGER — Primary key — NOT NULL
- username (이름) — VARCHAR(50) — NOT NULL
- password (비밀번호) — VARCHAR(50) — NOT NULL
- major (majorId) — INTEGER — Foreign key → major.메이저 키 — NOT NULL
- skills (기술스택) — VARCHAR(200)
- mail (이메일) — VARCHAR(100)
- tel (전화번호) — VARCHAR(100)
cartegory (카테고리)
- cartegory_ID (카테고리 아이디) — INTEGER — Primary key — NOT NULL
- cartegory_Name (카테고리 이름) — NOT NULL
major (전공)
- 메이저 키 (majorId) — INTEGER — Primary key — NOT NULL
- 전공 (major) — VARCHAR(50) — NOT NULL
members (멤버)
- post_ID (글 번호) — INTEGER — Foreign key → Post.post_ID — NOT NULL — AI
- user_ID (학번) — INTEGER — Foreign key → User.user_ID — NOT NULL
- role (역할) — VARCHAR(225) — NOT NULL