test

Tables (8)

component

  • id — bigint — Primary key — NOT NULL
  • project_id — bigint — NOT NULL — Project ID
  • name — varchar(24) — NOT NULL — Name of Component
  • description — varchar(256) — NOT NULL — Description of Component
  • github_url — varchar(1000) — Github URL
  • custom_attributes — json — Custom Attributes
  • deleted — bit — NOT NULL — 0: Not deleted, 1: Deleted
  • created_by — varchar(20) — 생성자
  • created_at — datetime — 생성일시
  • updated_by — varchar(20) — 수정자
  • updated_at — datetime — 수정일시
  • deleted_by — varchar(20) — 삭제자
  • deleted_at — datetime — 삭제일시

component_user

  • id — bigint — Primary key — NOT NULL
  • id (id2) — bigint — Primary key — NOT NULL
  • component_id — bigint — NOT NULL — Component ID
  • user_id — bigint — NOT NULL — User ID
  • created_by — varchar(20) — 생성/수정자
  • created_at — datetime — 생성/수정일시

flyway_schema_history

  • installed_rank — int — NOT NULL
  • version — varchar(50)
  • description — varchar(200) — NOT NULL
  • type — varchar(20) — NOT NULL
  • script — varchar(1000) — NOT NULL
  • checksum — int
  • installed_by — varchar(100) — NOT NULL
  • installed_on — timestamp — NOT NULL
  • execution_time — int — NOT NULL
  • success — tinyint(1) — NOT NULL

project

  • id — bigint — Project ID' primary ke
  • name — varchar(24) — NOT NULL — Name of Project
  • description — varchar(256) — NOT NULL — Description of Project
  • team_name — varchar(80) — 프로젝트를 관리하는 팀명
  • custom_attributes — json — Custom Attributes
  • deleted — bit — NOT NULL — 0: Not deleted, 1: Deleted
  • created_by — varchar(20) — 생성자
  • created_at — datetime — 생성일시
  • updated_by — varchar(20) — 수정자
  • updated_at — datetime — 수정일시
  • deleted_by — varchar(20) — 삭제자
  • deleted_at — datetime — 삭제일시

project_user

  • id — bigint — ID' primary ke
  • project_id — bigint — NOT NULL — Project ID
  • user_id — bigint — NOT NULL — User ID
  • created_by — varchar(20) — 생성/수정자
  • created_at — datetime — 생성/수정일시

stack

  • id — bigint — Stack ID' primary ke
  • project_id — bigint — NOT NULL — Project ID
  • component_id — bigint — NOT NULL — Component ID
  • name — varchar(24) — NOT NULL — Name of Stack
  • description — varchar(256) — NOT NULL — Description of Stack
  • deleted — bit — NOT NULL — 0: Not deleted, 1: Deleted
  • created_by — varchar(20) — 생성자
  • created_at — datetime — 생성일시
  • updated_by — varchar(20) — 수정자
  • updated_at — datetime — 수정일시
  • deleted_by — varchar(20) — 삭제자
  • deleted_at — datetime — 삭제일시

test

  • id — varchar(20) — NOT NULL — test!!!

user

  • id — bigint — User ID' primary ke
  • fullname — varchar(45) — NOT NULL — Fullname e.g., donghoon.lee
  • display_name — varchar(45) — NOT NULL — Display name e.g., 이동훈
  • email — varchar(45) — NOT NULL — e-mail address
  • slack_id — varchar(45) — Slack ID e.g., U032JKGMWGY
  • deleted — bit — NOT NULL — 0: Not deleted, 1: Deleted
  • created_by — varchar(20) — 생성자
  • created_at — datetime — 생성일시
  • updated_by — varchar(20) — 수정자
  • updated_at — datetime — 수정일시
  • deleted_by — varchar(20) — 삭제자
  • deleted_at — datetime — 삭제일시