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