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