Data Standard Terminology Application Skill

When writing DB-related code, you must follow the standards below. For the detailed guide, refer to data-standard-terminology-guide.md in this directory.

Target Files

• •JPA/Hibernate entity classes (.java)
• •TypeORM/Prisma entities/schemas (.ts)
• •SQLAlchemy/Django models (.py)
• •SQL files (.sql)
• •Migration files
• •DTO/VO classes

Core Rules

1. Use standard terminology English abbreviations for column names

Search for the Korean term name in the standard terminology dictionary (data/standard_terms.json) and use the English abbreviation.

Key examples:

2. Follow suffix patterns

3. Table name rules

4. Data type mapping based on domain rules

Date/Time

Amount/Number

String

Code/Boolean

5. Forbidden words must not be used

Words in the 금칙어목록 (forbidden word list) field of the standard word dictionary (data/standard_words.json) are prohibited. When found, replace them with the standard word from the 이음동의어목록 (synonym list).

6. How to look up terminology

When DB-related naming is needed:

1. •Search by Korean 공통표준용어명 (common standard term name) in data/standard_terms.json
2. •Use the 공통표준용어영문약어명 (common standard term English abbreviation) value as the column name
3. •Determine the data type and length from the 공통표준도메인명 (common standard domain name)
4. •If not found in the standard terms, combine individual word abbreviations from 공통표준단어영문약어명 in data/standard_words.json

7. JPA Entity Example

@Entity
@Table(name = "TB_CSTMR")
public class Customer {

  @Id
  @GeneratedValue(strategy = GenerationType.IDENTITY)
  @Column(name = "CSTMR_SN")
  private Long customerSn;

  @Column(name = "CSTMR_NM", length = 100, nullable = false)
  private String customerNm;

  @Column(name = "BRNO", length = 10, columnDefinition = "CHAR(10)")
  private String brno;

  @Column(name = "TELNO", length = 11)
  private String telno;

  @Column(name = "JOIN_YMD", length = 8, columnDefinition = "CHAR(8)")
  private String joinYmd;

  @Column(name = "REG_DT")
  private LocalDateTime regDt;

  @Column(name = "USE_YN", length = 1, columnDefinition = "CHAR(1) DEFAULT 'Y'")
  private String useYn;
}