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: