gondgdal
Tables (8)
tb_comment_bas
- id — bigint — Primary key — NOT NULL
- parent_id — bigint — Foreign key → tb_comment_bas.id
- schedule_id — bigint — Foreign key → tb_schedule_bas.id
- user_id — bigint — Foreign key → tb_user_bas.id
- content — varchar(255)
- create_date — datetime(6)
- modify_date — datetime(6)
tb_file_bas
- id — bigint — Primary key — NOT NULL
- original_name — varchar(255)
- url — varchar(255)
- file_key — varchar(255)
- create_date — datetime(6)
- modify_date — datetime(6)
tb_group_bas
- id — bigint — Primary key — NOT NULL
- cover_id — bigint — Foreign key → tb_file_bas.id
- color — varchar(255)
- group_key — varchar(255)
- name — varchar(255)
- password — varchar(255)
- description — varchar(255)
- create_date — datetime(6)
- modify_date — datetime(6)
tb_notice_bas
- id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → tb_user_bas.id
- active — bit(1)
- message — varchar(255)
- schedule_id — bigint
- type — int
- writer_id — bigint
- create_date — datetime(6)
- modify_date — datetime(6)
tb_schedule_bas
- id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → tb_user_bas.id
- writer_id — bigint — Foreign key → tb_user_bas.id
- corrector_id — bigint — Foreign key → tb_user_bas.id
- group_id — bigint — Foreign key → tb_group_bas.id
- file_id — bigint — Foreign key → tb_file_bas.id
- description — varchar(255)
- name — varchar(255)
- start_date — timestamp
- create_date — datetime(6)
- end_date — timestamp
- modify_date — datetime(6)
tb_sub_leader_group
- group_id — bigint — Foreign key → tb_group_bas.id — NOT NULL
- user_id — bigint — Foreign key → tb_user_bas.id — NOT NULL
tb_user_bas
- id — bigint — Primary key — NOT NULL
- profile_id — bigint — Foreign key → tb_file_bas.id
- birth — date
- join_type — enum('A','G','K','N')
- login_id — varchar(255)
- nick_name — varchar(255)
- password — varchar(255)
- status — enum('ACTIVE','INACTIVE')
- notice — bit(1)
- fcm_token — varchar(255)
- access_token — varchar(255)
- refresh_token — varchar(255)
- create_date — datetime(6)
- modify_date — datetime(6)
tb_user_group
- user_id — bigint — Foreign key → tb_user_bas.id — NOT NULL
- group_id — bigint — Foreign key → tb_group_bas.id — NOT NULL