미래해양
테이블 (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)