Built-In
Tables (24)
ApplyBoardDomain (apply_board_domain)
- id (Key) — bigint — Primary key — NOT NULL
- domain_id (Key2) — bigint — Foreign key → Domain.id — NOT NULL
- board_id (Key3) — bigint — Foreign key → Board.id — NOT NULL
- created_at (Field) — timestamp — NOT NULL
- updated_at (Field2) — timestamp — NOT NULL
ApplyBoard_Position (apply_board_position)
- id (Key) — bigint — Primary key — NOT NULL
- position_id — bigint — Foreign key → Position.id — NOT NULL
- board_id — bigint — Foreign key → Board.id — NOT NULL
- created_at (Field) — timestamp — NOT NULL
- updated_at (Field2) — timestamp — NOT NULL
ApplyBoard_Tech (apply_board_tech)
- id (Key) — bigint — Primary key — NOT NULL
- tech_id (Key2) — bigint — Foreign key → Tech.id — NOT NULL
- board_id (Key3) — bigint — Foreign key → Board.id — NOT NULL
- created_at (Field) — timestamp — NOT NULL
- updated_at (Field2) — timestamp — NOT NULL
ApplyInfo (applyInfo)
- id (Key) — bigint — Primary key — NOT NULL
- team_id (Key2) — bigint — Foreign key → Team.id — NOT NULL
- member_id (Key3) — bigint — Foreign key → Member.id — NOT NULL
- read (Field) — boolean — NOT NULL
- content (Field3) — varchar(255) — NOT NULL
- created_at (Field2) — timestamp — NOT NULL
- updated_at (Field5) — timestamp — NOT NULL
ApplyInfo_Domain (apply_info_domain)
- id (Key) — bigint — Primary key — NOT NULL
- domain_id (Key3) — bigint — Foreign key → Domain.id — NOT NULL
- apply_info_id (Key2) — bigint — Foreign key → ApplyInfo.id — NOT NULL
- created_at (Field) — timestamp — NOT NULL
- updated_at (Field2) — timestamp — NOT NULL
ApplyInfo_Position (apply_info_position)
- id (Key) — bigint — Primary key — NOT NULL
- position_id — bigint — Foreign key → Position.id — NOT NULL
- apply_info_id — bigint — Foreign key → ApplyInfo.id — NOT NULL
- created_at (Field) — timestamp — NOT NULL
- updated_at (Field2) — timestamp — NOT NULL
ApplyInfo_Tech (apply_info_tech)
- id (Key) — bigint — Primary key — NOT NULL
- tech_id (Key2) — bigint — Foreign key → Tech.id — NOT NULL
- apply_info_id (Key3) — bigint — Foreign key → ApplyInfo.id — NOT NULL
- created_at (Field) — timestamp — NOT NULL
- updated_at (Field2) — timestamp — NOT NULL
Board (board)
- id (Key) — bigint — Primary key — NOT NULL
- author_id (Key2) — bigint — Foreign key → Member.id — NOT NULL
- team_id (Key3) — bigint — Foreign key → Team.id
- type (Field3) — int — NOT NULL
- title (Field) — varchar(50) — NOT NULL
- content (Field2) — varchar(255)
- created_at (Field6) — timestamp — NOT NULL
- updated_at (Field4) — timestamp — NOT NULL
Build (build)
- id (Key2) — bigint — Primary key — NOT NULL
- team_id (Key) — bigint — Foreign key → Team.id — NOT NULL
- status (Field) — varchar(50)
- created_at (Field2) — timestamp — NOT NULL
- updated_at (Field3) — timestamp — NOT NULL
BuildSetting (build_setting)
- id (Key) — bigint — Primary key — NOT NULL
- buid_id (Key2) — bigint — Foreign key → Build.id — NOT NULL
- git_token (Field) — varchar(127)
- jenkins_url (Field2) — varchar(127)
- docker_image (Field3) — varchar(127)
- created_at (Field4) — timestamp — NOT NULL
- updated_at (Field5) — timestamp — NOT NULL
Comment (comment)
- id (Key) — bigint — Primary key — NOT NULL
- board_id (Key2) — bigint — Foreign key → Board.id — NOT NULL
- author_id (Key3) — bigint — Foreign key → Member.id — NOT NULL
- content (Field2) — varchar(100)
- created_at (Field) — timestamp — NOT NULL
- updated_at (Field3) — timestamp — NOT NULL
Domain (domain)
- id (Key) — bigint — Primary key — NOT NULL
- name (Field) — varchar(50) — NOT NULL
- created_at (Field2) — timestamp — NOT NULL
- updated_at (Field3) — timestamp — NOT NULL
Following (following)
- id (Key) — bigint — Primary key — NOT NULL
- follwer_id (Key2) — bigint — Foreign key → Member.id — NOT NULL
- followed_id (Key3) — bigint — Foreign key → Member.id — NOT NULL
- notification (Field) — boolean — NOT NULL
- status (Field2) — varchar(20)
- created_at (Field3) — timestamp — NOT NULL
- updated_at (Field4) — timestamp — NOT NULL
Meeting (meeting)
- id (Key) — bigint — Primary key — NOT NULL
- team_id (Key2) — bigint — Foreign key → Team.id — NOT NULL
- name (Field) — varchar(20) — NOT NULL
- user_count (Field2) — int
- max_user_count (Field3) — int — NOT NULL
- secret (Field4) — boolean — NOT NULL
- created_at (Field5) — timestamp — NOT NULL
- updated_at (Field6) — timestamp — NOT NULL
Member (member)
- id (Key) — bigint — Primary key — NOT NULL
- email (asdf) — varchar(50) — NOT NULL
- nickname (Field3) — varchar(50) — NOT NULL
- profile_url (Field2) — varchar(255)
- phone (Field) — varchar(20)
- address (Field4) — varchar(255)
- deleted (Field5) — boolean — NOT NULL
- created_at (Field6) — timestamp — NOT NULL
- updated_at (Field7) — timestamp — NOT NULL
MemberChat (member_chat)
- id (Key) — bigint — Primary key — NOT NULL
- from_id (Key2) — bigint — Foreign key → Member.id — NOT NULL
- to_id (Key3) — bigint — Foreign key → Member.id — NOT NULL
- subject (Field) — varchar(127) — NOT NULL
- status (Field3) — varchar(20)
- time (Field2) — timestamp — NOT NULL
- created_at (Field4) — timestamp — NOT NULL
- updated_at (Field5) — timestamp — NOT NULL
MemberDomain (member_domain)
- id (Key) — bigint — Primary key — NOT NULL
- member_id (Key2) — bigint — Foreign key → Member.id — NOT NULL
- domain_id (Key3) — bigint — Foreign key → Domain.id — NOT NULL
- created_at (Field) — timestamp — NOT NULL
- updated_at (Field2) — timestamp — NOT NULL
MemberPosition (member_position)
- id (Key) — bigint — Primary key — NOT NULL
- member_id (f) — bigint — Foreign key → Member.id — NOT NULL
- position_id (Key2) — bigint — Foreign key → Position.id — NOT NULL
- created_at (Field) — timestamp — NOT NULL
- updated_at (Field2) — timestamp — NOT NULL
MemberTeam (member_team)
- id (Key) — bigint — Primary key — NOT NULL
- member_id (Key2) — bigint — Foreign key → Member.id — NOT NULL
- team_id (Key3) — bigint — Foreign key → Team.id — NOT NULL
- leader (Field) — boolean — NOT NULL
- created_at (Field2) — timestamp — NOT NULL
- updated_at (Field3) — timestamp — NOT NULL
MemberTech (member_tech)
- id (Key) — bigint — Primary key — NOT NULL
- member_id (Key3) — bigint — Foreign key → Member.id — NOT NULL
- tech_id (Key2) — bigint — Foreign key → Tech.id — NOT NULL
- career (Field) — int
- created_at (Field2) — timestamp — NOT NULL
- updated_at (Field3) — timestamp — NOT NULL
Message (message)
- id (Key) — bigint — Primary key — NOT NULL
- member_chat_id (Key3) — bigint — Foreign key → MemberChat.id — NOT NULL
- is_from_sender (Field) — boolean — NOT NULL
- read (Field2) — boolean — NOT NULL
- content (Field3) — varchar(127) — NOT NULL
- message_visible_to (Field5) — varchar(20)
- created_at (Field4) — timestamp — NOT NULL
- updated_at (Field6) — timestamp — NOT NULL
Position (position)
- id (Key) — bigint — Primary key — NOT NULL
- name (Field) — varchar(20) — NOT NULL
- created_at (Field2) — timestamp — NOT NULL
- updated_at (Field3) — timestamp — NOT NULL
Team (team)
- id (Key) — bigint — Primary key — NOT NULL
- name (Field3) — varchar(50) — NOT NULL
- status (Field7) — varchar(20) — NOT NULL
- content (Field4) — varchar(255)
- start_time (Field5) — timestamp — NOT NULL
- end_time (Field6) — timestamp — NOT NULL
- git_url (Field8) — varchar(255)
- jira_url (Field9) — varchar(255)
- created_at (Field) — timestamp — NOT NULL
- updated_at (Field2) — timestamp — NOT NULL
Tech (tech)
- id (Key) — bigint — Primary key — NOT NULL
- name (Field) — varchar(50) — NOT NULL
- created_at (Field2) — timestamp — NOT NULL
- updated_at (Field3) — timestamp — NOT NULL