AMS
Tables (10)
AUTHORITIES
- USER_ID — varchar(45) — Foreign key → USERS.USER_ID — NOT NULL
- AUTHORITY — varchar(45) — NOT NULL
GROUP_APPLICATIONS
- APPLICATION_ID — int — Primary key — NOT NULL
- Key — Primary key — NOT NULL
- GROUP_ID — int — NOT NULL
- USER_ID — varchar(45) — Foreign key → USERS.USER_ID — NOT NULL
- MSG — longtext
- REG_DATE — timestamp — NOT NULL
GROUP_ATTENDANCES
- GROUP_ID — INT — NOT NULL
- SCHEDULE_ID — INT — Foreign key → GROUP_SCHEDULES.SCHEDULE_ID — NOT NULL
- USER_ID — VARCHAR(45) — NOT NULL
- ATTENDANCE_STATUS — VARCHAR(45) — NOT NULL
- REG_DATE — TIMESTAMP — NOT NULL
- MOD_DATE — TIMESTAMP — NOT NULL
GROUP_SCHEDULES
- SCHEDULE_ID — INT — Primary key — NOT NULL
- GROUP_ID — INT — NOT NULL
- PLACE_LATITUDE — double — NOT NULL
- PLACE_LONGITUDE — double — NOT NULL
- PLACE_ADDRESS — varchar(80)
- BUILDING_NAME — varchar(45)
- BEGIN_TIME — DATETIME — NOT NULL
- END_TIME — DATETIME — NOT NULL
- REG_DATE — TIMESTAMP — NOT NULL
- MOD_DATE — TIMESTAMP — NOT NULL
OAUTH_AUTHORITIES
- USER_ID — int — Foreign key → OAUTH_USERS.USER_ID — NOT NULL
- AUTHORITY — varchar(45) — NOT NULL
- REG_DATE — timestamp — NOT NULL
- MOD_DATE — timestamp — NOT NULL
OAUTH_USERS
- USER_ID — int — Primary key — NOT NULL
- USER_NAME — varchar(45) — NOT NULL
- USER_EMAIL — varchar(45)
- ENABLED — tinyint — NOT NULL
- ACCESS_TOKEN — varchar(100) — NOT NULL
- REFRESH_TOKEN — varchar(100) — NOT NULL
- REG_DATE — timestamp — NOT NULL
- MOD_DATE — timestamp — NOT NULL
STUDY_GROUPS
- group_id — int — Primary key — NOT NULL
- group_category — varchar(45) — NOT NULL
- group_master_id — varchar(45) — NOT NULL
- group_name — varchar(45) — NOT NULL
- group_detail — longtext — NOT NULL
- group_member_limit — int — NOT NULL
- group_period — varchar(45)
- group_area — varchar(45) — NOT NULL
- group_status — varchar(45) — NOT NULL
- group_start_age — int
- group_end_age — int
- group_view_cnt — int — NOT NULL
- reg_date — timestamp — NOT NULL
- mod_date — timestamp — NOT NULL
- group_comment_cnt — int — NOT NULL
USERS
- ID — int — Primary key — NOT NULL
- USER_ID — varchar(45) — NOT NULL
- USER_PW — varchar(100) — NOT NULL
- USER_NAME — varchar(45) — NOT NULL
- USER_EMAIL — varchar(45) — NOT NULL
- ENABLED — tinyint — NOT NULL
- REG_DATE — timestamp — NOT NULL
- MOD_DATE — timestamp — NOT NULL
group_comment
- comment_id — int — Primary key — NOT NULL
- group_id — int — NOT NULL
- user_id — varchar(45) — NOT NULL
- comment_msg — longtext — NOT NULL
- reg_date — timestamp — NOT NULL
- mod_date — timestamp — NOT NULL
group_members
- group_id — int — NOT NULL
- user_id — varchar(45) — NOT NULL
- group_authority — varchar(45) — NOT NULL
- demerit_cnt — int — NOT NULL
- reg_date — timestamp — NOT NULL
- mod_date — timestamp — NOT NULL