sparta_scheduleapp
Tables (5)
member
- id — int — Primary key — NOT NULL
- email — varchar(100)
- pwd — varchar(100)
- username — varchar(100)
- created_at — datetime
- modified_at — datetime
schedules
- schedule_id — int — Primary key — NOT NULL
- id — long — Foreign key → users.id — NOT NULL
- todo — varchar(45)
- password — int
- last_update — date
schedules (CopyOfschedules)
- id — int — Primary key — NOT NULL
- title — varchar(100)
- contents — varchar(100)
- writer — varchar(100)
- pwd — varchar(100)
- created_at — datetime
- modified_at — datetime
schedules (schedule)
- id — int — Primary key — NOT NULL
- member_id — int — Foreign key → member.id — NOT NULL
- title — varchar(100)
- contents — varchar(100)
- created_at — datetime
- modified_at — datetime
users
- id — long — Primary key — NOT NULL
- name — varchar(10)