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 — 삭제일시