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