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