BCSDLab

Tables (3)

dues

  • id — BIGINT — Primary key — NOT NULL
  • created_at — datetime
  • updated_at — datetime
  • memo — VARCHAR(255)
  • member_id — BIGINT — Foreign key → member.id
  • date — date
  • status — VARCHAR(255)
  • is_delete — BIT(1)

member

  • id — BIGINT — Primary key — NOT NULL
  • created_at — datetime
  • updated_at — datetime
  • join_date — date
  • track_id — BIGINT — Foreign key → track.id
  • member_type — VARCHAR(255)
  • status — VARCHAR(255)
  • name — VARCHAR(255)
  • profile_image_url — VARCHAR(255)
  • company — VARCHAR(255)
  • department — VARCHAR(255)
  • student_number — VARCHAR(255)
  • phone_number — VARCHAR(255)
  • email — VARCHAR(255)
  • password — VARCHAR(255)
  • authority — VARCHAR(255)
  • github_name — VARCHAR(255)
  • is_authed — BIT(1)
  • is_deleted — BIT(1)

track

  • id — BIGINT — Primary key — NOT NULL
  • created_at — datetime
  • updated_at — datetime
  • name — VARCHAR(255) — NOT NULL
  • is_deleted — BIT(1) — NOT NULL