미래해양

테이블 (13)

ApiItem (Untitled10)

  • Key (id) — 기본 키 — NOT NULL
  • Field (name)
  • Field2 (explain)
  • Field3 (price)

Order (Untitled8)

  • Key (id) — 기본 키 — NOT NULL
  • Key (mb_no) — INT((11) — 외래 키 → tbl_member.Key — NOT NULL
  • Field (created_at)

OrderItem (Untitled11)

  • Key (id) — 기본 키 — NOT NULL
  • Key (item_id) — 외래 키 → ApiItem.Key — NOT NULL
  • Key (order_id) — 외래 키 → Order.Key — NOT NULL
  • Field (created_at)

PaidItem (Untitled12)

  • Key (id) — 기본 키 — NOT NULL
  • Key (payment_id) — 외래 키 → Payment.Key — NOT NULL
  • Key (item_id) — 외래 키 → ApiItem.Key — NOT NULL
  • Key (mb_no) — INT((11) — 외래 키 → tbl_member.Key — NOT NULL
  • Field (expiry_date)
  • Field2 (start_date)

Payment (Untitled9)

  • Key (id) — 기본 키 — NOT NULL
  • Key (order_id) — 외래 키 → Order.Key — NOT NULL
  • Field (payment_key)
  • Field2 (approved_at)
  • Field3 (requested_at)
  • Field4 (method)
  • Field5 (status)

stt_voice_err_log (Untitled7)

  • Key (id) — 기본 키 — NOT NULL
  • Key (vl_id) — 외래 키 → stt_voice_log.Key — NOT NULL
  • Field (created_at)
  • Field (downloaded_at)

stt_voice_log (Untitled5)

  • Key (id) — 기본 키 — NOT NULL
  • Key (user_group_member_id) — 외래 키 → tbl_user_group_member.Key — NOT NULL
  • Field (vl_group)
  • Field2 (vl_result)
  • Field3 (vl_model)
  • Field4 (vl_datetime)
  • Field (vl_lat)
  • Field2 (vl_lng)
  • Field (vl_ip)
  • Field (vl_path)
  • Field (vl_size)
  • Field (vl_name)
  • Field (stt_response)

tbl_member (Untitled)

  • Key (mb_no) — INT((11) — 기본 키 — NOT NULL
  • Field (mb_id) — VARCHAR(100)
  • Field2 (mb_password) — VARCHAR(255)
  • Field3 (mb_name) — VARCHAR(255)
  • Field4 (mb_email) — VARCHAR(255)
  • Field5 (mb_level) — INT(11)
  • Field6 (mb_hp) — VARCHAR(255)
  • Field7 (mb_datetime) — DATETIME
  • Field8 (mb_access_token) — VARCHAR(255)
  • Field9 (mb_refresh_token) — VARCHAR(255)
  • Field10 (mb_token_expire_time) — DATETIME
  • Field11 (mb_update_date) — DATETIME
  • Field (mb_laboratory_term) — TINYINT(1)
  • Field2 (mb_personalInfo_term) — TINYINT(1)
  • Field12 (mb_positionInfo_term) — TINYINT(1)
  • Field13 (mb_profileInfo_term) — TINYINT(1)
  • Field (mb_user_type) — VARCHAR(255)
  • Field (mb_user_group) — VARCHAR(255)
  • Field (mb_user_group_level) — TINYINT(2)
  • Field (mb_payment) — VARCHAR(255)

tbl_member_social_profiles (Untitled2)

  • Key (mp_no) — INT(11) — 기본 키 — NOT NULL
  • Field (mb_no) — INT(11)
  • Field2 (social_id) — VARCHAR(255)
  • Field3 (social_token) — VARCHAR(255)

tbl_ship_device (Untitled6)

  • Key (id) — 기본 키 — NOT NULL
  • Key (user_group_member_Id) — 외래 키 → tbl_user_group_member.Key — NOT NULL
  • Field (device_id)
  • Field2 (created_at)
  • Field (is_deleted)
  • Field2 (updated_at)

tbl_user_group (Untitled3)

  • Key (id) — INT — 기본 키 — NOT NULL
  • Field (name) — VARCHAR(100)
  • Field2 (capacity) — INT
  • Field3 (created_at) — DATE
  • Field5 (updated_at) — DATE
  • Field (is_deleted) — TINYINT(1)

tbl_user_group_member (Untitled4)

  • Key (id) — 기본 키 — NOT NULL
  • Key (user_group_id) — 외래 키 → tbl_user_group.Key — NOT NULL
  • Key (mb_no) — INT((11) — 외래 키 → tbl_member.Key — NOT NULL
  • Field (created_at)
  • Field2 (updated_at)
  • Field3 (is_deleted)
  • Field (group_role)

tbl_voice_statistics (Untitled13)

  • Key (id) — 기본 키 — NOT NULL
  • Key (user_group_member_id) — 외래 키 → tbl_user_group_member.Key — NOT NULL
  • Field (total_file_cnt)
  • Field2 (total_file_len)
  • Field (date)