Posco store
Tables (14)
access_log
- id — int — Primary key — NOT NULL
- code — varchar(100) — NOT NULL
- type — varchar(100) — NOT NULL
- msg — varchar(300) — NOT NULL
- insert_date — datetime
- device_id — int — NOT NULL
- user_id — int — NOT NULL
- app_id — varchar(100) — NOT NULL
- os_version — varchar(100) — NOT NULL
- page_code — varchar(45)
admin
- id — int — Primary key — NOT NULL
- user_id — varchar(100) — NOT NULL
- password — varchar(100) — NOT NULL
- name — varchar(45)
app_grant
- id — int — Primary key — NOT NULL
- type — varchar(45) — NOT NULL
- app_id — varchar(100) — Foreign key → application.id — NOT NULL
- company — varchar(45) — Foreign key → company.id — NOT NULL
- team — varchar(45) — Foreign key → company.id — NOT NULL
- ranked — varchar(45) — Foreign key → ranked.id — NOT NULL
- user — int — Foreign key → user.id — NOT NULL
app_info
- id — int — Primary key — NOT NULL
- app_name — varchar(100) — NOT NULL
- access_date — datetime
- version — varchar(100) — NOT NULL
- ip — varchar(100)
- network — varchar(100)
- user_id — int — Foreign key → device.id — NOT NULL
- app_id — varchar(100) — Foreign key → application.version — NOT NULL
- device_id — int — Foreign key → user.id — NOT NULL
application
- id — varchar(100) — Primary key — NOT NULL
- version — varchar(100) — Primary key — NOT NULL
- app_name — varchar(100) — NOT NULL
- admin — varchar(30) — NOT NULL
- desc — varchar(1000)
- update_desc — varchar(1000)
- update_date — date
- extra_url — varchar(500)
- os — char(2) — NOT NULL
- reg_date — datetime
- update_reg_date — datetime
- package_name — varchar(300)
- scheme — varchar(300)
- del — int
- app_server — varchar(300)
- icon_file — int — Foreign key → file.id — NOT NULL
- install_file — int — Foreign key → file.id — NOT NULL
- detail_file — int — Foreign key → file.seq — NOT NULL
company
- id — int — Primary key — NOT NULL
- company_name — varchar(100) — NOT NULL
- company_code — varchar(100) — NOT NULL
- team_name — varchar(100)
- team_code — varchar(100)
- depth — int
device
- id — int — Primary key — NOT NULL
- device_id — varchar(100)
- phone_number — varchar(100) — NOT NULL
- social_token — varchar(300)
- user_name — varchar(100) — NOT NULL
- fcm_active — int
- device_os — char(1) — NOT NULL
- device_model — varchar(100) — NOT NULL
- fcm_token — varchar(300)
- reg_date — datetime
- update_date — datetime
- device_os_type — char(1)
- update_fcm_active — int
- carrier — varchar(30)
- user_id — int — Foreign key → user.id — NOT NULL
error_information
- id — int — Primary key — NOT NULL
- error_name — varchar(45)
- error_code — varchar(45)
error_log
- id — int — Primary key — NOT NULL
- code — varchar(100) — NOT NULL
- type — varchar(100) — NOT NULL
- msg — varchar(300) — NOT NULL
- insert_date — datetime
- device_id — int — NOT NULL
- user_id — int — NOT NULL
- app_id — varchar(20) — NOT NULL
- os_version — varchar(100) — NOT NULL
- page_code — varchar(45)
fcm_info
- id — int — Primary key — NOT NULL
- fcm_token — varchar(300)
- app_id — varchar(100) — Foreign key → application.id — NOT NULL
- device_id — int — Foreign key → device.id — NOT NULL
- user_id — int — Foreign key → user.id — NOT NULL
file
- id — int — Primary key — NOT NULL
- seq — int — Primary key — NOT NULL
- original_name — varchar(100) — NOT NULL
- changed_name — varchar(100) — NOT NULL
- location — varchar(300) — NOT NULL
log_score
- id — int — Primary key — NOT NULL
- reg_date — datetime
- score — float
- app_id — varchar(100)
- app_name — varchar(100)
ranked
- id — int — Primary key — NOT NULL
- ranked_name — varchar(100) — NOT NULL
- ranked_code — varchar(100) — NOT NULL
user
- id — int — Primary key — NOT NULL
- name — varchar(100) — NOT NULL
- user_id — varchar(100) — NOT NULL
- team — varchar(12) — NOT NULL
- tester — int — NOT NULL
- email — varchar(200)
- password — varchar(100) — NOT NULL
- phone_number — varchar(45) — NOT NULL
- ranked — varchar(100) — Foreign key → ranked.id — NOT NULL
- company — varchar(100) — Foreign key → company.id — NOT NULL