ERDPRA

Tables (7)

Untitled (Project)

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

Untitled (Project_application)

  • Key (application_id) — bigint(20) — Primary key — NOT NULL
  • id (applicant_id) — bigint(20) — Foreign key → User.id — NOT NULL
  • Key (project_id) — bigint(20) — Foreign key → Untitled.Key — NOT NULL
  • Field (apply_date) — datetime — NOT NULL
  • Field (apply_status) — enum(대기, 완료, 거부) — NOT NULL

Untitled (Sellpost)

  • Key (sell_id) — bigint(20) — Primary key — NOT NULL
  • id (seller_id) — bigint(20) — Foreign key → User.id — NOT NULL
  • Field (title) — VARCHAR(255) — NOT NULL
  • Field (text) — VARCHAR(255) — NOT NULL
  • Field (price) — bigint(20) — NOT NULL
  • Field (category) — enum(전공서적, 물건, 식권) — NOT NULL
  • Field (sell_status) — boolean — NOT NULL
  • Field (view) — bigint(20)
  • Field (date_created) — datetime — NOT NULL
  • Field (date_edited) — datetime
  • Field (imageURL) — VARCHAR(255)

Untitled (Notice)

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

Untitled (Post)

  • Key (post_id) — bigint(20) — Primary key — NOT NULL
  • id (poster_id) — bigint(20) — Foreign key → User.id — NOT NULL
  • Field (title) — VARCHAR(255) — NOT NULL
  • Field (category) — enum — NOT NULL
  • Field (anonymity) — boolean — NOT NULL
  • Field (text) — VARCHAR(255)
  • Field (view_count) — bigint(20) — NOT NULL
  • Field (like_count) — bigint(20) — NOT NULL
  • Field (scrap_count) — bigint(20) — NOT NULL
  • Field (poster_name) — VARCHAR(255) — NOT NULL
  • Field (date_created) — datetime — NOT NULL
  • Field (date_edited) — datetime

Untitled (comment)

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

User

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