codeculum
테이블 (12)
Copy Of Copy Of Untitled2 (review)
- Key (review_id) — int — 기본 키 — NOT NULL
- (curriculum_id) — int — 외래 키 → curriculum.curriculum_id — NOT NULL
- (user_id) — int — 외래 키 → User.user_id — NOT NULL
- Field (title) — char — NOT NULL
- Field (contents) — text — NOT NULL
- Field (created_at) — datetime — NOT NULL
- Field (updated_at) — datetime — NOT NULL
- Field (rate) — float — NOT NULL
Copy Of Copy Of 동호회 게시글 (forum_comment_list)
- Key (forum_comment_list) — int — 기본 키 — NOT NULL
- Key (board_id) — int — 외래 키 → Copy Of Untitled.Key — NOT NULL
- 내용 (contents) — text — NOT NULL
- 게시일 (createdAt) — datetime — NOT NULL
- 수정일 (updatedAt) — datetime
Copy Of Untitled (forum)
- Key (forum_board_id) — int — 기본 키 — NOT NULL
- (user_id) — int — 외래 키 → User.user_id — NOT NULL
- Field (title) — char(50) — NOT NULL
- Field (category) — int — NOT NULL
- Field (contents) — text — NOT NULL
- Field (created_at) — datetime — NOT NULL
- Field (updated_at) — datetime — NOT NULL
Untitled (curriculum_board)
- Key (board_id) — int — 기본 키 — NOT NULL
- (user_id) — int — 외래 키 → User.user_id — NOT NULL
- (curriculum_id) — int — 외래 키 → curriculum.curriculum_id — NOT NULL
- Field (title) — char(100) — NOT NULL
- Field (category) — int — NOT NULL
- Field (contents) — text — NOT NULL
- Field (created_at) — datetime — NOT NULL
- Field (updated_at) — datetime — NOT NULL
User
- (user_id) — int — 기본 키 — NOT NULL
- (bio) — char(60)
- (my_curriculum) — int
- (subscribed_curriculum) — int
- (email_verified) — bool
- (email_secret) — char
- Field (favorite_curriculum) — int
- Field (job_status) — char(50)
Userlist (userlist)
- (user_id) — int — 외래 키 → User.user_id — NOT NULL
- (curriculum_id) — int — 외래 키 → curriculum.curriculum_id — NOT NULL
board_list (comment)
- Key (comment_id) — int — 기본 키 — NOT NULL
- Key — 외래 키 → Untitled.Key — NOT NULL
- (user_id2) — int — 외래 키 → User.user_id — NOT NULL
- 내용 (contents) — text — NOT NULL
- 게시일 (createdAt) — datetime — NOT NULL
- 수정일 (updatedAt) — datetime
converstation (conversation)
- (conversataion_id) — int — 기본 키 — NOT NULL
- (user_id) — int — 외래 키 → User.user_id
curriculum
- (curriculum_id) — int — 기본 키 — NOT NULL
- (user_id) — int — 외래 키 → User.user_id — NOT NULL
- (title) — varchar(140)
- (description) — text
- (created_at) — datetime — NOT NULL
- (period) — int — NOT NULL
- (budget) — int — NOT NULL
- (related_skill) — char(140)
- (education_background) — char(30)
- (learning_goal) — text
- (owner) — char(20) — NOT NULL
- Field (challenge) — bool
- Field (updated_at) — datetime — NOT NULL
day (time)
- (time_id) — int — 기본 키 — NOT NULL
- (curriculum_id) — int — 외래 키 → curriculum.curriculum_id — NOT NULL
- (user_id) — int — 외래 키 → curriculum.user_id — NOT NULL
- (title) — varchar
- (curriculum) — int
message
- (message_id) — int — 기본 키 — NOT NULL
- (conversataion_id) — int — 외래 키 → converstation.conversataion_id — NOT NULL
- (user_id) — int — 외래 키 → converstation.user_id — NOT NULL
- (message) — char(500)
task
- (task_id) — int — 기본 키 — NOT NULL
- (time_id) — int — 외래 키 → day.time_id — NOT NULL
- (curriculum_id) — int — 외래 키 → day.curriculum_id — NOT NULL
- (user_id) — int — 외래 키 → day.user_id — NOT NULL
- (title) — char(50)
- (complete) — bool