kcs
Tables (6)
account
- account_id — BIGINT — Primary key — NOT NULL
- username — VARCHAR(45) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- role — VARHCAR(25) — NOT NULL
- refresh_token — VARCHAR(255) — NOT NULL
- created_at — DATETIME — NOT NULL
- last_modified_at — DATETIME — NOT NULL
- created_by — VARCHAR(45) — NOT NULL
- last_modified_by — VARCHAR(45) — NOT NULL
comment
- comment_id — BIGINT — Primary key — NOT NULL
- content — VARCHAR(255) — NOT NULL
- group_num — BIGINT — NOT NULL
- order_num — BIGINT — NOT NULL
- created_at — DATETIME — NOT NULL
- last_modified_at — DATETIME — NOT NULL
- created_by — VARCHAR(45) — NOT NULL
- last_modified_by — VARCHAR(45) — NOT NULL
- study_id — BIGINT — Foreign key → study.study_id — NOT NULL
- member_id — BIGINT — Foreign key → member.member_id — NOT NULL
email_auth
- email_auth_id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(45) — NOT NULL
- code — VARCHAR(25) — NOT NULL
- is_authenticated — TINYINT — NOT NULL
- created_at — DATETIME — NOT NULL
- last_modified_at — DATETIME — NOT NULL
member
- member_id — BIGINT — Primary key — NOT NULL
- account_id — BIGINT — Foreign key → account.account_id — NOT NULL
- name — VARCHAR(25) — NOT NULL
- email — VARCHAR(45) — NOT NULL
- created_at — DATETIME — NOT NULL
- last_modified_at — DATETIME — NOT NULL
- created_by — VARCHAR(45) — NOT NULL
- last_modified_by — VARCHAR(45) — NOT NULL
study
- study_id — BIGINT — Primary key — NOT NULL
- title — VARCHAR(45) — NOT NULL
- description — VARCHAR(255) — NOT NULL
- schedule — VARCHAR(255) — NOT NULL
- how_to — VARCHAR(255) — NOT NULL
- max_num — INT — NOT NULL
- study_category — VARCHAR(25) — NOT NULL
- recruitment_completed — TINYINT — NOT NULL
- create_at (created_at) — DATETIME — NOT NULL
- last_modified_at — DATETIME — NOT NULL
- created_by — VARCHAR(45) — NOT NULL
- last_modified_by — VARCHAR(45) — NOT NULL
study_member
- study_member_id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → member.member_id — NOT NULL
- study_id — BIGINT — Foreign key → study.study_id — NOT NULL
- study_member_type — VARCHAR(25) — NOT NULL — 개설자 참여자 ...
- created_at — DATETIME — NOT NULL
- last_modified_at — DATETIME — NOT NULL
- created_by — VARCHAR(45) — NOT NULL
- last_modified_by — VARCHAR(45) — NOT NULL