Tukether

Tables (7)

Comment

  • comment_id — bigint(20) — Primary key — NOT NULL
  • post_id — bigint(20) — Foreign key → Post.post_id — NOT NULL
  • commenter_id — bigint(20) — Foreign key → User.user_id — NOT NULL
  • anonymity — boolean — NOT NULL
  • text — VARCHAR(255) — NOT NULL
  • like_count — bigint(20) — NOT NULL
  • date_created — datetime — NOT NULL
  • date_edited — datetime

Notice

  • notice_id — bigint(20) — Primary key — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • text — TEXT
  • scrap_count — bigint(20) — NOT NULL
  • date_created — datetime — NOT NULL

Post

  • post_id — bigint(20) — Primary key — NOT NULL
  • poster_id — bigint(20) — Foreign key → User.user_id — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • category — ENUM('자유', '정보', '질문') — NOT NULL
  • anonymity — boolean — NOT NULL
  • text — TEXT
  • view_count — bigint(20) — NOT NULL
  • like_count — bigint(20) — NOT NULL
  • scrap_count — bigint(20) — NOT NULL
  • date_created — datetime — NOT NULL
  • date_edited — datetime

Project

  • project_id — bigint(20) — Primary key — NOT NULL
  • user_id — bigint(20) — Foreign key → User.user_id — NOT NULL
  • project_name — VARCHAR(255) — NOT NULL
  • status — ENUM('모집중', '진행중', '완료') — NOT NULL
  • out_date — bigint(20) — NOT NULL
  • recruit_number — bigint(20) — NOT NULL
  • category — ENUM('졸업작품', '사이드 프로젝트', '스터디') — NOT NULL
  • text — TEXT
  • date_created — datetime — NOT NULL
  • date_edited — datetime

Project_application

  • application_id — bigint(20) — Primary key — NOT NULL
  • applicant_id — bigint(20) — Foreign key → User.user_id — NOT NULL
  • project_id — bigint(20) — Foreign key → Project.project_id — NOT NULL
  • apply_date — datetime — NOT NULL
  • apply_status — ENUM('대기', '완료', '거부') — NOT NULL

Sellpost

  • sell_id — bigint(20) — Primary key — NOT NULL
  • seller_id — bigint(20) — Foreign key → User.user_id — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • text — TEXT — NOT NULL
  • price — bigint(20) — NOT NULL
  • category — ENUM('전공서적', '물건', '식권') — NOT NULL
  • sell_status — ENUM('판매중', '예약중', '판매완료') — NOT NULL
  • view — bigint(20)
  • date_created — datetime — NOT NULL
  • date_edited — datetime
  • imageURL — VARCHAR(255)

User

  • user_id — bigint(20) — Primary key — NOT NULL
  • school_id — bigint(20) — NOT NULL
  • department — VARCHAR(255) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • date_created — datetime — NOT NULL