cs_program

Tables (3)

BUSINESS

  • BUSINESS_ID (INSTT_ID) — BIGINT — Primary key — NOT NULL
  • BUSINESS_NM — VARCHAR(10) — NOT NULL
  • ADDR — VARCHAR(50)
  • CREATED_AT — DATETIME — NOT NULL
  • Field

INSTT

  • INSTT_ID — BIGINT — Primary key — NOT NULL
  • INSTT_NM — VARCHAR(10) — NOT NULL
  • ADDR — VARCHAR(50)
  • CREATOR_ID — BIGINT
  • CREATED_AT — DATETIME — NOT NULL
  • UPDATOR_ID — BIGINT
  • UPDATED_AT (Field) — DATETIME
  • DELETOR_ID (Field2)

USER

  • USER_ID — BIGINT — Primary key — NOT NULL
  • USER_NM — VARCHAR(10) — 이름
  • LOGIN_ID — VARCHAR(20)
  • PW — TEXT
  • WORKING_STATUS — INT — 0: 재직 1: 휴직 2: 퇴직
  • CREATED_AT — DATETIME
  • UPDATED_AT — DATETIME
  • ROLE — INT — 0: 1: 2: