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