STUDY
Tables (3)
Untitled (online study)
- Key (studycode) — varchar(10) — Primary key — NOT NULL
- Field (title) — text
- Field2 (place) — text
- Field (date) — datetime
- Field (money) — int
- Field (onoff) — int
Untitled (my study)
- Key (no) — int — Primary key — NOT NULL
- Field (study code) — varchar(10)
- id (member_id) — varchar(45) — Foreign key → member.id — NOT NULL
- Key (studycode) — varchar(10) — Foreign key → Untitled.Key — NOT NULL
member
- id — varchar(45) — Primary key — NOT NULL
- pw — text
- name — varchar(45)
- Field2 (kakaoUser) — TINYINT
- Field (email) — varchar(45)