스터디 erd ver2
테이블 (7)
BORROW_LIST
- BRRW_ID — INT(20) — 기본 키 — NOT NULL
- BRRW_DT — VARCHAR(8) — 기본 키 — NOT NULL
- PRKG_LCTN_SEQ — INT(10) — 외래 키 → PRKG__DTL.PRKG_LCTN_SEQ — NOT NULL
- PRKG_ID — INT(20) — 외래 키 → PRKG__DTL.PRKG_ID — NOT NULL
- BRRW_STRT_DT — VARCHAR(255)
- BRRW_END_DT — VARCHAR(255)
- USE_YN — VARCHAR(1)
- REG_DT — VARCHAR(8)
- UPD_DT — VARCHAR(8)
- USER_ID — INT(20) — 외래 키 → USER_INFO.USER_ID — NOT NULL
OWNER_INFO
- OWNR_ID — INT(20) — 기본 키 — NOT NULL — OWNER PK
- OWNR_NAME — VARCHAR(30)
- USE_YN — VARCHAR(1)
- REG_DT — VARCHAR(8)
- UPD_DT — VARCHAR(8)
PARKING_LOT
- PRKG_ID — INT(20) — 기본 키 — NOT NULL
- PRKG_NAME — VARCHAR(30)
- Field — VARCHAR(255)
- OWNR_ID — INT(20) — NOT NULL — OWNER PK
- USE_YN — VARCHAR(1)
- REG_DT — VARCHAR(8)
- UPD_DT — VARCHAR(8)
PRKG_DTL_LCTN
- PRKG_LCTN_SEQ — INT(10) — 외래 키 → PRKG__DTL.PRKG_LCTN_SEQ — NOT NULL
- PRKG_ID — INT(20) — 외래 키 → PRKG__DTL.PRKG_ID — NOT NULL
- Field — VARCHAR(255)
- Field2 — VARCHAR(255)
- USE_YN — VARCHAR(1)
- REG_DT — VARCHAR(8)
- UPD_DT — VARCHAR(8)
PRKG_PRINCING
- PRKG_PRCG_SEQ — INT(10) — 기본 키 — NOT NULL
- PRKG_ID — INT(20) — 외래 키 → PARKING_LOT.PRKG_ID — NOT NULL
- KIND_CD — int(6)
- PRICE — int(10)
- USE_YN — VARCHAR(1)
- REG_DT — VARCHAR(8)
- UPD_DT — VARCHAR(8)
PRKG__DTL
- PRKG_LCTN_SEQ — INT(10) — 기본 키 — NOT NULL
- PRKG_ID — INT(20) — 외래 키 → PARKING_LOT.PRKG_ID — NOT NULL
- Field — VARCHAR(255)
- AREA_SIZE_CD — int(6)
- USE_YN — VARCHAR(1)
- REG_DT — VARCHAR(8)
- UPD_DT — VARCHAR(8)
- OWNR_ID — INT(20) — 외래 키 → OWNER_INFO.OWNR_ID — NOT NULL — OWNER PK
USER_INFO
- USER_ID — INT(20) — 기본 키 — NOT NULL
- USER_NM — VARCHAR(255)
- USE_YN — VARCHAR(1)
- REG_DT — VARCHAR(8)
- UPD_DT — VARCHAR(8)