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