Schedule
Tables (4)
Comments (comments)
- CommentsKey (comments_key) — bigint — Primary key — NOT NULL
- commenter — varchar(100)
- comments — varchar(100)
- createdDateTime (created_date_time) — datetime
- modifiedDateTime (modified_date_time) — datetime
- scheduleKey (schedule_key) — bigint — Foreign key → Schedule.scheduleKey — NOT NULL
Member (member)
- userKey (user_key) — bigint — Primary key — NOT NULL
- userName (user_name) — varchar(100)
- userEmail (user_email) — varchar(100)
- password — varchar(100)
- createdDateTime (created_date_time) — datetime
- modifiedDateTime (modified_date_time) — datetime
Schedule (schedule)
- scheduleKey (schedule_key) — bigint — Primary key — NOT NULL
- writerName (writer_name) — varchar(100)
- scheduleDate (schedule_date) — date
- scheduleTitle (schedule_title) — varchar(100)
- scheduleDescription (schedule_description) — varchar(100)
- createdDateTime (created_date_time) — datetime
- ModifiedDateTime (modified_date_time) — datetime
schedule_member (schedule_mamber)
- scheduleKey (schedule_key) — bigint — Foreign key → Schedule.scheduleKey — NOT NULL
- userKey (user_key) — bigint — Foreign key → Member.userKey — NOT NULL