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