ABCProject

Tables (17)

Copy Of Untitled (COMMON_POSTS)

  • Key (id) — int — Primary key — NOT NULL
  • Key (writer) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (content) — String
  • Field (board) — String
  • Field (created_date) — Date
  • Field (view) — int

Copy Of Untitled2 (COMMON_POST_LIKES)

  • Key (id) — int — Primary key — NOT NULL
  • Key (common_study_id) — int — Foreign key → Copy Of Untitled.Key — NOT NULL
  • Key (user_id) — int — Foreign key → Untitled.Key — NOT NULL

STUDIES

  • id — Int — Primary key — NOT NULL
  • Key (minor_class_id) — int — Foreign key → Untitled2.Key — NOT NULL
  • Field (name) — String
  • Field (goal) — String
  • Field (description) — String
  • Field (user_limit) — int
  • Field (start_time) — int
  • Field (end_time) — int
  • Field (status) — String
  • Field (start_date) — Date
  • Field (isopen) — bool
  • Field (created_date) — Date
  • Field

Untitled (WORKS)

  • Key (id) — int — Primary key — NOT NULL
  • id (study_id) — Int — Foreign key → STUDIES.id — NOT NULL
  • Key (writer) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (start_date) — Date
  • Field (end_date) — Date
  • Field (content) — String
  • Field (status) — String

Untitled (DAYS)

  • Key (id) — init — Primary key — NOT NULL
  • id (study_id) — Int — Foreign key → STUDIES.id — NOT NULL
  • Field (day) — varchar(3)

Untitled (USERS_AND_STUDIES)

  • Key (id) — int — Primary key — NOT NULL
  • id (study_id) — Int — Foreign key → STUDIES.id — NOT NULL
  • Key (user_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (auth) — String

Untitled (APPLIES)

  • Key (id) — int — Primary key — NOT NULL
  • id (study_id) — Int — Foreign key → STUDIES.id — NOT NULL
  • Key (user_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (comment) — String

Untitled (STUDIES_AND_TAGS)

  • Key (id) — init — Primary key — NOT NULL
  • Key (tag_id) — int — Foreign key → Untitled.Key — NOT NULL
  • id (study_id) — Int — Foreign key → STUDIES.id — NOT NULL

Untitled (TAGS)

  • Key (id) — int — Primary key — NOT NULL
  • Field (name) — String

Untitled (COMMENTS_LIKES)

  • Key (id) — int — Primary key — NOT NULL
  • Key (comment_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (user_id) — int — Foreign key → Untitled.Key — NOT NULL

Untitled (COMMENTS)

  • Key (id) — int — Primary key — NOT NULL
  • Key (writer) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (post_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (content) — String
  • Field (created_date) — Date

Untitled (STUDY_POST_LIKES)

  • Key (id) — int — Primary key — NOT NULL
  • Key (study_post_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (user_id) — int — Foreign key → Untitled.Key — NOT NULL

Untitled (STUDY_POSTS)

  • Key (id) — int — Primary key — NOT NULL
  • Key (writer) — int — Foreign key → Untitled.Key — NOT NULL
  • id (study_id) — Int — Foreign key → STUDIES.id — NOT NULL
  • Field (content) — String
  • Field (board) — String
  • Field (created_date) — Date
  • Field (view) — int

Untitled (USERS_AND_MINOR_CLASSES)

  • Key (id) — int — Primary key — NOT NULL
  • Key (minor_class_id) — int — Foreign key → Untitled2.Key — NOT NULL
  • Key (user_id) — int — Foreign key → Untitled.Key — NOT NULL

Untitled (USERS)

  • Key (id) — int — Primary key — NOT NULL
  • Field (email) — String
  • Field (password) — String
  • Field (name) — string
  • Field (nickname) — string
  • Field (gender) — char
  • Field (auth) — int

Untitled (MAJOR_CLASSES)

  • Key (id) — int — Primary key — NOT NULL
  • Field (name) — String
  • Field

Untitled2 (MINOR_CLASSES)

  • Key — int — Primary key — NOT NULL
  • Key (major_class_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (name) — String