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