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