black alarm
Tables (5)
TB_DEV (tb_dev)
- DEV_NUM (Key) — INT — Primary key — NOT NULL
- MB_SEQ (mb_seq2) — INT — Foreign key → TB_MEMBER.MB_SEQ — NOT NULL
- DEV_NAME (dev_name) — VARCHAR
TB_GPS (tb_gps)
- GPS_SEQ (key) — INT — Primary key — NOT NULL
- DEV_NUM (Key) — INT — Foreign key → TB_DEV.DEV_NUM — NOT NULL
- MB_SEQ (mb_seq2) — INT — Foreign key → TB_DEV.MB_SEQ — NOT NULL
- DEV_LONGITUDE (dev_longitude) — decimal
- DEV_LATITUDE (dev_latitude) — decimal
TB_LIST (tb_list)
- LI_SEQ (Key) — INT — Primary key — NOT NULL
- DEV_NUM (Key2) — INT — Foreign key → TB_DEV.DEV_NUM — NOT NULL
- MB_SEQ (mb_seq22) — INT — Foreign key → TB_DEV.MB_SEQ — NOT NULL
- LI_TITELE (li_title) — VARCHAR
- LI_DATE (li_date) — TIME
TB_MB_LOGIN_HST (tb_mb_login_hst)
- MB_LOGIN_SEQ (mb_login_seq) — INT — Primary key — NOT NULL
- MB_SEQ (mb_seq2) — INT — Foreign key → TB_MEMBER.MB_SEQ — NOT NULL
- LOGIN_YN (login_yn) — CHAR
- LOGIN_DESC (login_desc) — VARCHAR
TB_MEMBER (tb_member)
- MB_SEQ (mb_seq) — INT — Primary key — NOT NULL
- MB_ID (mb_id) — CHAR
- MB_PASSWORD (mb_pasword) — VARCHAR
- MB_NAME (mb_name) — VARCHAR
- LOGIN_FAIL_CASCNT (login_fail_cascnt) — INT